EAR 9.2: AR_PAYLOAD Abends at Step AR_PAYLOAD.ECREMIT.LOADITE3 (SQL) for EDI 820 Payments
(Doc ID 3063185.1)
Last updated on DECEMBER 12, 2024
Applies to:
PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
AR_PAYLOAD app engine process abend at Step AR_PAYLOAD.ECREMIT.LOADITE3 (SQL) for EDI 820 Paymens.
Error:
-----------------------
Stmt #: 1851 Error Position: 29 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_PD_IDITEM_TAO6"."ITEM_LINE") to NULL Failed SQL stmt: UPDATE PS_PD_IDITEM_TAO6 SET ITEM_LINE = ( SELECT ITEM_LINE FROM PS_ITEM WHERE PS_ITEM.BUSINESS_UNIT = PS_PD_IDITEM_TAO6.BUSINESS_UNIT AND PS_ITEM.CUST_ID = PS_PD_IDITEM_TAO6.CUST_ID AND PS_ITEM.ITEM = PS_PD_IDITEM_TAO6.REF_VALUE AND PS_ITEM.BAL_AMT = PS_PD_IDITEM_TAO6.ITEM_AMT AND PS_ITEM.ITEM_LINE <> 0 AND PS_PD_IDITEM_TAO6.PROCESS_INSTANCE = 8254126) WHERE PS_PD_IDITEM_TAO6.PROCESS_INSTANCE = 8254126 AND DATA_SOURCE = '820'Process 8225973 ABENDED at Step AR_PAYLOAD.ECREMIT.LOADITE3 (SQL) -- RC = 1407 (108,524)
-----------------------
Stmt #: 1851 Error Position: 29 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_PD_IDITEM_TAO6"."ITEM_LINE") to NULL Failed SQL stmt: UPDATE PS_PD_IDITEM_TAO6 SET ITEM_LINE = ( SELECT ITEM_LINE FROM PS_ITEM WHERE PS_ITEM.BUSINESS_UNIT = PS_PD_IDITEM_TAO6.BUSINESS_UNIT AND PS_ITEM.CUST_ID = PS_PD_IDITEM_TAO6.CUST_ID AND PS_ITEM.ITEM = PS_PD_IDITEM_TAO6.REF_VALUE AND PS_ITEM.BAL_AMT = PS_PD_IDITEM_TAO6.ITEM_AMT AND PS_ITEM.ITEM_LINE <> 0 AND PS_PD_IDITEM_TAO6.PROCESS_INSTANCE = 8254126) WHERE PS_PD_IDITEM_TAO6.PROCESS_INSTANCE = 8254126 AND DATA_SOURCE = '820'Process 8225973 ABENDED at Step AR_PAYLOAD.ECREMIT.LOADITE3 (SQL) -- RC = 1407 (108,524)
Replication:
-----------------------
1: Setup integration broker for EDI 820.
2: Run EOP_PUBLISHF to upload EDI file and populate staging (EC) tables. (Enterprise component >Integration Definitions > Initiate processes > Inbound File Publish)
3: Run AR_PAYLOAD for EDI 820. (AR > Payments > Electronic Payments > Process Payment Interface)
Please review replication document for detailed setup and replication.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |