My Oracle Support Banner

EBI 9.2: BIRECUR Abends at Step BIRECUR.PRCCHGS.UPDLND1 (SQL) With an Error ’Cannot Update ("SYSADM"."PS_BI_LINE"."DESCR") to Null ' (Doc ID 2758728.1)

Last updated on MARCH 08, 2021

Applies to:

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

Symptoms

Generate Recurring Bills process BIRECUR Abends at Step BIRECUR.PRCCHGS.UPDLND1 (Action SQL) -- RC = 1407 when enabling the installation option of "Use Effective Dated Identifier Description for Generating Recurring Bills and Copied Bills".

ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1738 Error Position: 22 Return: 14 07 - ORA-01407: cannot update ("SYSADM"."PS_BI_LINE"."DESCR") to NULL Failed SQL stmt: UPDATE PS_BI_LINE SET DESCR = ( SELECT CHARGE.DESCR FROM PS_BI_CHARGE CHARGE WHERE CHARGE.BI_CURRENCY_CD = 'USD' AND CHARGE.SETID = ( SELECT Z.SETID FROM PS_SET_CNTRL_REC Z WHERE Z.SE TCNTRLVALUE = 'US001' AND Z.RECNAME = 'BI_CHARGE') AND CHARGE.CHARGE_ID = 'TEST_NO_IDENTIFIER' AND C HARGE.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_BI_CHARGE C WHERE C.SETID = CHARGE.SETID AND C.CHARGE_ID = CHARGE.CHARGE_ID AND C.EFFDT <= TO_DATE('2020-12-08','YYYY-MM-DD')) AND CHARGE.EFF_STATUS = 'A') WHERE BUSINESS_UNIT = 'US001' AND INVOICE = '0000678689' AND LINE_SEQ_NUM = 1



Replication Step
-----------------------
1. Enable the billing general installation option of "Use Effective Dated Identifier Description for Generating Recurring Bills and Copied Bills". (Setup financials - Installation option - Billing General Options)
2. Enter weekly recurring bill. ( Billing - Maintain Bills - Standard Bills)
3. Do not populate the identifier from the available identifier but just populate the identifier as a test and description as a test.
4: Generate recurring schedule. (Billing - Maintain Bills - Recurring Bill Schedules)
5: RDY bill and run BIRECUR (create recurring bills) by invoice id. The process will fail. ((Billing - Maintain Bills - Create recurring Bills)

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.