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 MAY 30, 2016

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms