Skip to Main Content

Java Development Tools

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!

PL/SQL based Entity Object

996913Sep 24 2014 — edited Sep 25 2014

Hi,

ADF 11.1.1.6

   I am building an ADF application which has complex screens with master-detail relation ships etc. This application is to be integrated with Oracle E-business suite. I will need to use seeded PL/SQL APIs to perform the DML operations. I understand that Entity objects can be created on top of PL/SQL procedures.

But since I have Header, Line and Line details information at the UI level, which have to be depicted using View links, how do I leverage Entity Objects based on PL/SQL procedures that has parameters as Collections like SQL Table types.

Please let me know your thoughts if anyone has come across with this scenario. My fallback options is, call the PL/SQL procedure from the application module, after collecting the data entered by user.

Thanks,

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2014
Added on Sep 24 2014
4 comments
307 views