My Oracle Support Banner

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)






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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.