My Oracle Support Banner

EAR 9.2:AR_PAYLOAD Trying To Insert Null Value For Business_unit Into PS_PD_IDITEM_TAO4 (Doc ID 2141360.1)

Last updated on MARCH 17, 2019

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, when attempting to run AR_PAYLOAD
the following error occurs:

ERROR
-----------------------
Left 1 Cash drawer receipts in the staging tables. Verify Bank Acct. data. (6893,45)

Processed 4 deposits and 22 payments from cash drawer receipts (6893,46)

File: e:\pt85419b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 29 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_PD_IDITEM_TAO4"."BUSINESS_UNIT") to NULL
Failed SQL stmt: UPDATE PS_PD_IDITEM_TAO4 SET BUSINESS_UNIT = ( SELECT MAX(ITM.BUSINESS_UNIT) FROM PS_ITEM ITM WHERE ITM.ITEM = PS_PD_IDITEM_TAO4.ITEM AND (PS_PD_IDITEM_TAO4.CUST_ID = ' ' OR ITM.CUST_ID = PS_PD_IDITEM_TAO4.CUST_ID)) WHERE BUSINESS_UNIT = ' ' AND PROCESS_INSTANCE = XXX

Process xxx ABENDED at Step AR_PAYLOAD.PRCS_DTL.UPD_BU_I (SQL) -- RC = 1407 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create one bank to load data for two deposit business unit
  2. Load data using bank reconciliation.
  3. Run AR Payload

Changes

 

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