1 Reply Latest reply: Aug 28, 2012 3:19 AM by rockyzhou RSS

    ON- INSERT trigger not working

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



      Thanks,

      R