This content has been marked as final. Show 5 replies
The exception message has a line number? In that case you can open the package and look at the query that gives the error.
You can look at PO_INTERFACE_ERRORS table too.
Actually there are no error message in PO_INTERFACE_ERRORS table and I didn't find any package named PO in PO schema!
You should look at APPS schema for standard packages of all modules.
I can't find it in my working instances, but I'm on 11i. Are you working on release 12?
Can you please advise the value for column "PROCESS_CODE" in the PO_HEADERS_INTERFACE table? Did you check the Purchasing Interface Errors report also for any errors?
Additionally, it will help if you can copy/paste the insert code for the interface tables ....
A good detailed explanation of the Purchase Order interface is in the following document:
See if that helps.
I found the problem...its because I am running my request from a wrong responsibility.