Third part Purchase Orders into PeopleSoft Purchasing
Hello,
I am trying to load third part Purchase Orders into PeopleSoft Purchasing.
The problem is, the Orders should be generated in PSFN with PO_ID that we get in the file from third party. I did loaded those Orders into Staging tables(PO_HDR_STG,PO_ITM_STG and PO_DISTRIB_STG) with Fields PO_STG_ID,PO_ID with the third party Order Number and PO_BUILT_FLG = 'Y'. The Transaction goes into Error Status.
When I did debugged the Trace file of PO_POCALC Process, the trasaction is set to Error Status if (PO_ID<>'UNASSINGED' AND NOT EXISTS IN PO_HDR joining the temp instance of PO_ITM_STG).
I am trying to load third part Purchase Orders into PeopleSoft Purchasing.
The problem is, the Orders should be generated in PSFN with PO_ID that we get in the file from third party. I did loaded those Orders into Staging tables(PO_HDR_STG,PO_ITM_STG and PO_DISTRIB_STG) with Fields PO_STG_ID,PO_ID with the third party Order Number and PO_BUILT_FLG = 'Y'. The Transaction goes into Error Status.
When I did debugged the Trace file of PO_POCALC Process, the trasaction is set to Error Status if (PO_ID<>'UNASSINGED' AND NOT EXISTS IN PO_HDR joining the temp instance of PO_ITM_STG).
0