Technology Stack - EBS (MOSC)

MOSC Banner

Update View

edited Aug 20, 2021 11:06AM in Technology Stack - EBS (MOSC) 2 commentsAnswered ✓

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