Skip to Main Content

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!

master/detail seems to fail when used to insert master&details

B.DelméeOct 24 2013 — edited Nov 18 2013

I am using Application Express 4.2.1.00.08

here's what I'd like to do

  1. generate a standard master/detail via the wizard
  2. enter the generated M/D page with no master PK
  3. use the create button to enter a master record *but*
  4. stay on the same page, with a detail section now available
  5. add detail rows
  6. save all

by default the CREATE request redirects to page 0 (weird default)

if I correct that to post to self, the fields are blanked after the master record creation (which occurs as I can verify).

I do not understand this as the "reset page" process should only occur when leaving through the DELETE button.

I am puzzled.

Entering the page with the PK of an existing master works as expected,

It just does not seem to work when trying to use the page to create both a master and its details.

I found suggestions to fill the "return PK to field" property, but then I cannot even insert the master recors

(I am getting an ORA-1403)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2013
Added on Oct 24 2013
6 comments
1,138 views