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!

How to pass Master Detail Detail IG item values to a PLSQL Process to call REST API? Oracle APEX 22.2.4

MaheshPawarMar 24 2023 — edited Mar 24 2023

Hi Everyone,

I'm currently looking into something that might be an issue in approach I'm working on. The page is structured like this:

I have 3 Interactive Grids, the Master Detail Detail and upon filling all the details I have a Save button to save the data and also a Process is executed where I call a Oracle Fusion REST API to POST a Customer.

Now I have a requirement to use data from Master and Details Interactive Grids in a single PL/SQL process at once. I have tried to use :P2_CUSTOMER_NAME, :P2_CUSTOMER_SITE details from different IGs and I am getting an error Page Item Not found in the Application. I have not linked the Process to any Editable Region and it is of type Executable Code.

I am looking for some guidance or an approach to achieve this. This is basically my ‘Hello World' project.

@smithjohn45 Thanks for advice

@John Snyders-Oracle @louis-moreaux StewStrykerNH If you have some suggestion on this I will be grateful.

Thanks,

Mahesh

Comments
Post Details
Added on Mar 24 2023
2 comments
274 views