Technology Stack - EBS (MOSC)

MOSC Banner

Enfore commit by user before navigating to next block

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

Dear All,

I have a custom form in which I am using master-details relationship but in actual there is no foreign and primary keys impelemented. My requirement is before going to any child block, a prompt should remind user to save record. I don't want to use commit_form. I want user should save changes if it is a new record or any change has been made to existing record. I tried when validate record trigger with builtin :SYSTEM.RECORD_STATUS IN('INSERT','CHANGED') but it did not work. Message is appearing appropriately on going to next block but it is not allowing user to save record.

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