Technology Stack - EBS (MOSC)

MOSC Banner

ON-INSERT Trigger Not working

edited Aug 20, 2021 10:46AM in Technology Stack - EBS (MOSC) 3 commentsAnswered
Hello

This is on forms 6i Oracle EBS 11.5.10.2

I  have a PL SQL Api  - HZ_PARTY_SITES_V2PUB.create_location that is supposed to create new addresses in HZ tables.

The API, when run from a wrapper script  - does the job just fine.. I.E. It will create the new site in Oracle.

However when I put the same API call under ON-INSERT trigger.. the forms says - 1 record applied and saved.. but I do not see the new record in database.    It does not show any error and all debug messages indicate succeess.

What could be the reason why I am not able to see newly created site in Database when same API is run through form.  And the same API works just fine from sql plus..

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