Technology Stack - EBS (MOSC)

MOSC Banner

FRM-40743 - This operation with no base table requires the ON-LOCK trigger

edited Aug 20, 2021 10:46AM in Technology Stack - EBS (MOSC) 2 commentsAnswered
Hello,
I have a form that requires DML operations. 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 data block has following property set at block level

Key Modke - Non Updatable
DML Data Target Type -  Table
DML Data Target  Name - Custom_View1
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