APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IG- inserting detail record without a master

Eslam_ElbyalyMar 27 2019 — edited Mar 31 2019

Apex 18.2.

Hi,

I have a master region(schedule) and a detail one(payment). When I am trying to insert a detail record without a master one I get

is_internal_error: false
ora_sqlcode: -6502
ora_sqlerrm: ORA-06502: PL/SQL: خطأ رقمي أو قيمة: character to number conversion error ORA-06512: عند "APEX_180200.WWV_FLOW_INTERACTIVE_GRID", line 7283 ORA-06502: PL/SQL: خطأ رقمي أو قيمة: character to number conversion error
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 16251925120319954
component.name: Payment- Save Interactive Grid Data
association_type: REGION

I believe the problem is with the foreign key because I tried to show it on the page and I got " column must be numeric" error when it had "t0001" temp value and even when I tried to changed it to a number it showed the same error.

As you already know, from a database perspective, the foreign key should have a master key or be null. But that does not seem to work on my Apex page! Is there a solution for this problem?

Added on Mar 27 2019

#apex-discussions

12 comments

1,336 views