When Running ARUPDATE for InterUnit Customer the Process is Erroring Out at IU_Processor.B001.B001-020 (Doc ID 1403383.1)

Last updated on JUNE 02, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
*** Checked for Relevance Wed 29-Jul-2015 ***

Symptoms


When attempting to run ARUPDATE job for InterUnit Customer, the following error occurs.

ERROR
-----------------------
SQL error. Function: CreateSQL
Error Position: 145 Return: 904 - ORA-00904: "SEQ_NUM": invalid identifier
Statement: select 'x' from ps_installation_fs where exists (select 'x' from ps_pg_iiu2_tao4 where iu_line_type ='1' and process_instance = 889051 group by SEQ_NUM , BUSINESS_UNIT, CUST_ID, GROUP_BU, GROUP_ID, GROUP_SEQ_NUM, ITEM, ITEM_LINE, BUSINESS_UNIT_GL, LEDGER, FOREIGN_CURRENCY, CURRENCY_CD HAVING (MIN(RT_TYPE) <> MAX(RT_TYPE)) OR (MIN(RATE_MULT) <> MAX(RATE_MULT)) OR (MIN(RATE_DIV) <> MAX(RATE_DIV)))

SQL error in Exec. (2,280) IU_PROCESSOR.B001.GBL.default.1900-01-01.B001-020.OnExecute PCPC:4359 Statement:76
Process 1200464 ABENDED at Step IU_PROCESSOR.B001.B001-020 (PeopleCode) -- RC = 8 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

Or Below error message:-

Stmt #: 1617  Error Position: 650 

Return: 904 - ORA-00904: "LN"."SEQ_NUM": invalid identifier

Failed SQL stmt:UPDATE PS_PG_IIU2_TAO4 SET IU_LINE_TYPE='z' WHERE IU_LINE_TYPE='1' AND PROCESS_INSTANCE=30228449 AND

NOT EXISTS ( SELECT 'X' FROM PS_PG_IIU_TAO4 LN WHERE LN.IU_LINE_TYPE='z' AND LN.PROCESS_INSTANCE = 30228449  AND

LN.BUSINESS_UNIT = PS_PG_IIU2_TAO4.BUSINESS_UNIT AND LN.CUST_ID = PS_PG_IIU2_TAO4.CUST_ID AND LN.GROUP_BU = PS_PG_IIU2_TAO4.GROUP_BU AND

LN.GROUP_ID = PS_PG_IIU2_TAO4.GROUP_ID AND LN.GROUP_SEQ_NUM = PS_PG_IIU2_TAO4.GROUP_SEQ_NUM AND LN.ITEM = PS_PG_IIU2_TAO4.ITEM AND LN.ITEM_LINE = PS_PG_IIU2_TAO4.ITEM_LINE GROUP BY LN.BUSINESS_UNIT_GL, LN.BUSINESS_UNIT, LN.CUST_ID, LN.GROUP_BU, LN.GROUP_ID, LN.GROUP_SEQ_NUM, LN.ITEM, LN.ITEM_LINE, LN.SEQ_NUM HAVING SUM(LN.MONETARY_AMOUNT) <> 0)

 

Process 30228449 ABENDED at Step IU_PROCESSOR.B000.B000-01A (SQL) -- RC = 904 (108,524)

 

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


Steps to replicate:-
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create a deposit.
  2. Apply the payment to an Item.
  3. Run the job AR_UPDATE.

 

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