Technology Stack - EBS (MOSC)

MOSC Banner

data block item only allow update but no new insert

edited Aug 20, 2021 10:59AM in Technology Stack - EBS (MOSC) 1 commentAnswered

need some idea on how to handle this.

I was asked to customized a existed form ( oracle form 6i in EBS 11.5.10.2 ).  Add a field called "Email" in the form.  The only value is YES or NO.   Sort of like setup purpose.

When the form is opened, the Email field is populated the value from a custom table ( TABLE_A.EMAIL_COL ).  The TABLE_A has 1 column called EMAIL_COL

TABLE_A

========

EMAIL_COL ( Column )

---------------                

YES

Here is what I need help.  I want ONLY update and query in the Email field in the form.  Not allow insert or add new row into the TABLE_A through the form.  if user update the Email field in the form, it is required to save it back to this row.  The TABLE_A will always have 1 row.

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