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!

Multiple collections on one page - interference?

510477Jun 26 2008 — edited Jun 27 2008
I thought I had this figured out, but my debug page (a bunch of report regions that show the various collection contents) tells me I have a problem.

I am trying to create a timecard entry system. There are different types of work, so I have separated the entry into 5 sections - a master and 4 detail sections. Each detail section is a collection named either TC_LOAD_DTL, TC_HRLY_DTL, TC_OTHR_DTL, or TC_MILE_DTL. Each gathers different kinds of data to be processed and recorded into 7 different tables. (TC_OTHR_DTL is a miscellanous group where I filter and store based on business rules into 4 other tables).

I can prepopulate the collections simply enough using an After Header process. Writing the information to the database is also straightforward. It is the update portion that is defeating me. I have a separate Page Process for each collection that fires After Submit (for development). Each handles it's own region and updates the various collections based on user input. It isn't (or shouldn't be) complicated at this point because all I'm doing is writing the input into the appropriate column in the collection. But somehow I keep getting only the first collection to properly update. The other processes seem to be bleeding across.

Here is a sample:
http://apex.oracle.com/pls/otn/f?p=52742:1:2479505591204321::NO:::

I know there is probably something simple I am missing, but I would appreciate the gaze of another set of eyes, as three days hasn't revealed it yet to me.

Thanks in advance,
Blair
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2008
Added on Jun 26 2008
17 comments
1,195 views