EAR 9.2: AR Update Abending At Step AR_PGG_SERV.ARLNPREP.SET_IU When Processing Transfer Worksheets Even Though No Inter Unit Transactions Are Present

(Doc ID 2265486.1)

Last updated on MAY 12, 2017

Applies to:

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

Symptoms

ISSUE:

If no InterUnit functionality is needed, it is often the case that the System Transaction Map configuration is not set up. While this should not be cause of problems, one has been detected with AR Update abending in an Error Message when a Transfer Worksheet is being handled, transferring an existing Item ID transaction from one Customer's Account to another's, all within the same Receivables Business Unit.

In this case, System Transaction ARTR (Receivables Transfers) is not configured with a System Transaction Code, as it is theoretically not needed, but AR Update still is making reference to it, and as such, an Error Message is triggered stating the program cannot inserty a NULL value into PS_PG_PENDST_TAO4.IU_TRAN_CD Record Field.

REPLICATION STEPS:

     1.- Ensure that the FSCM Online Application being used is not configured for InterUnit functionality, specially around Receivables Transfer Worksheets (ARTR)
     2.- Create a new Pending Item Group, for Business Unit US001, and Customer ID 1001
     3.- Launch AR Update to post the Pending Item Group into the Customer's Account
     4.- Navigate to: Accounts Receivable > Receivables Maintenance > Transfer Worksheet > Create Worksheet
     5.- Build a new Transfer Worksheet under Business Unit US001, transferring the Item ID just created from Customer ID 1001 to 1005
     6.- Place the Transfer Worksheet into Post Action Batch Standard
     7.- Launch AR Update to post the Transfer Worksheet
     8.- AR Update AE Program abends with an Error Message

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

     " -- 12:21:44.263 ........(AR_PGG_SERV.ARLNPREP.SET_IU) (SQL)
       UPDATE PS_PG_PENDST_TAO4 SET IU_SYS_TRAN_CD = 'ARTR',IU_TRAN_CD=( SELECT IU_TRAN_CD FROM PS_IU_TRAN_MAP_TBL WHERE IU_SYS_TRAN_CD = 'ARTR' AND DEFAULT_FLAG = 'Y') WHERE PROCESS_INSTANCE = 103638 AND SYSTEM_DEFINED = 'A' AND EXISTS ( SELECT 'X' FROM PS_PG_PNDTMP_TAO4 I WHERE I.PROCESS_INSTANCE = 103638 AND I.GROUP_BU = PS_PG_PENDST_TAO4.GROUP_BU AND I.GROUP_ID = PS_PG_PENDST_TAO4.GROUP_ID AND I.BUSINESS_UNIT = PS_PG_PENDST_TAO4.BUSINESS_UNIT AND I.CUST_ID = PS_PG_PENDST_TAO4.CUST_ID AND I.ITEM = PS_PG_PENDST_TAO4.ITEM AND I.ITEM_LINE = I.ITEM_LINE AND I.GROUP_SEQ_NUM = PS_PG_PENDST_TAO4.GROUP_SEQ_NUM AND I.ENTRY_USE_ID IN ('TR-01', 'TR-02', 'TR-03'))
       -- Row(s) affected: 0
       -- 12:21:44.483 Process 103638 ABENDED at Step AR_PGG_SERV.ARLNPREP.SET_IU (Action SQL) -- RC = 1407
       ROLLBACK
       -- 12:21:44.506 SQL Error: ORA-01407: cannot update ("EMDBO"."PS_PG_PENDST_TAO4"."IU_TRAN_CD") to NULL "

ACTUAL RESULT:

Due to this Error Message, Users are unable to transfer Receivables Items between customers.

EXPECTED BEHAVIOR:

The Transfer Worksheet functionality should properly generate the needed Accounting Entries if no Inter Unit transactions are being processed, even if no Inter Unit configuration be set up.

 

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