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..