1 Reply Latest reply on Aug 28, 2012 8:19 AM by rockyzhou

    ON- INSERT trigger not working

    Rich V

      This is on forms 6i Oracle EBS

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