Technology Stack - EBS (MOSC)

MOSC Banner

Updating a View through an Oracle EBS Form - How?

edited Aug 20, 2021 10:46AM in Technology Stack - EBS (MOSC) 1 commentAnswered
Hello,
I am developing a new EBS form based on a database view.

This form is an EBS form will run in an 11.5.10.2 environment and developed using 6i.

The form has one data block that is based on the view.  The view is joined and based on following tables.

Hz_Parties Hp,
 Hz_Cust_Accounts
Hz_Cust_Acct_Sites_All
Hz_Party_Sites
Hz_Locations
Ra_Salesreps_All
Hz_Cust_Site_Uses_All
Ar_Vat_Tax_All
xx_custom_table t

The view is inherently not updatable. Therefore, I am thinking to write an INSTEAD OF trigger on the view.  The question.  The form which is based on the view is require to update Oracle EBS tables mentioned above.   As you know,  there are APIs available to update above tables.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center