My Oracle Support Banner

EBI 9.2: Billing Pre Load Process (BIPRELD AE Program) Abends at Step IU_PROCESSOR.U400.U400-010 When ChartField Inheritance for Fund Code Is Enabled (Doc ID 2786535.1)

Last updated on JUNE 28, 2021

Applies to:

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

Symptoms


The Billing Pre Load Process (BIPRELD AE Program) abends at InterUnit/IntraUnit related Step IU_PROCESSOR.U400.U400-010, with a unique constraint violation on Record PS_BI_ACCT_LN_STG2.

This happens when a request of this process was launched with a Billing Invoice containing multiple Revenue Distribution Accounting Lines, each with a different Fund Code, and having IntraUnit Balancing Entries by Fund Code configured at the Ledger Group level.

REPLICATION STEPS:

    1.- At the Ledger Group set up level, ensure that IntraUnit Balancing Entries check-box is selected, with the option of Fund Code enabled
    2.- At the Overall Installation Options level, define the InterUnit Method as Direct
    3.- Create a new Invoice in Billing module, and split the amount into multiple Revenue Distribution lines, each with a different Fund Code value
    4.- Save the Invoice in a Status of RDY (Ready)
    5.- Launch the Single Action Invoice process (BIJOB03 PSJob) for the transaction at hand
    6.- The process abends in Error Message

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

ERROR MESSAGE:

    " -- 2021-06-11 21:47:03.484 ........(IU_PROCESSOR.U400.U400-010) (SQL)
      INSERT INTO PS_BI_ACCT_LN_STG2 (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, ACCOUNTING_DT, ACCT_ENTRY_TYPE, DISC_SUR_LVL, DISC_SUR_ID, LINE_DST_SEQ_NUM, TAX_AUTHORITY_CD, DST_SEQ_NUM, PROCESS_INSTANCE, DISC_SUR_INDICATOR, CF_BAL_LINE_NUM, BUSINESS_UNIT_GL, LEDGER_GROUP, LEDGER, ACCOUNTING_PERIOD, FISCAL_YEAR, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE, STATISTICS_CODE, MONETARY_AMOUNT, STATISTIC_AMOUNT, OPEN_ITEM_KEY, JRNL_LN_REF, LINE_DESCR, USER1, USER2, USER3, USER4, USER5, JOURNAL_ID, JOURNAL_DATE, JOURNAL_LINE, BUDGET_DT, BUDGET_HDR_STATUS, BUDGET_LINE_STATUS, KK_TRAN_OVER_FLAG, KK_TRAN_OVER_OPRID, KK_TRAN_OVER_DTTM, GL_DISTRIB_STATUS, APPL_JRNL_ID, CURRENCY_CD, FOREIGN_CURRENCY, FOREIGN_AMOUNT, RT_TYPE, DOC_TYPE, DOC_SEQ_NBR, DOC_SEQ_DATE, RATE_MULT, RATE_DIV, FROM_ACCRUAL, ENTRY_EVENT, IU_ANCHOR_FLG, IU_SYS_TRAN_CD, IU_TRAN_CD, BI_PRELD_STAT, ERROR_STATUS_BI, CF_ACTION_FLG) SELECT A.BUSINESS_UNIT, A.INVOICE, A.LINE_SEQ_NUM, A.ACCOUNTING_DT, A.ACCT_ENTRY_TYPE, A.DISC_SUR_LVL, A.DISC_SUR_ID, A.LINE_DST_SEQ_NUM, A.TAX_AUTHORITY_CD, A.DST_SEQ_NUM, A.PROCESS_INSTANCE, A.DISC_SUR_INDICATOR, A.CF_BAL_LINE_NUM, A.BUSINESS_UNIT_GL, A.LEDGER_GROUP, A.LEDGER, A.ACCOUNTING_PERIOD, A.FISCAL_YEAR, A.ACCOUNT, A.ALTACCT, A.DEPTID, A.OPERATING_UNIT, A.PRODUCT, A.FUND_CODE, A.CLASS_FLD, A.PROGRAM_CODE, A.BUDGET_REF, A.AFFILIATE, A.AFFILIATE_INTRA1, A.AFFILIATE_INTRA2, A.CHARTFIELD1, A.CHARTFIELD2, A.CHARTFIELD3, A.BUSINESS_UNIT_PC, A.PROJECT_ID, A.ACTIVITY_ID, A.RESOURCE_TYPE, A.RESOURCE_CATEGORY, A.RESOURCE_SUB_CAT, ' ', A.STATISTICS_CODE, A.MONETARY_AMOUNT, A.STATISTIC_AMOUNT, ' ', A.JRNL_LN_REF, A.LINE_DESCR, A.USER1, A.USER2, A.USER3, A.USER4, A.USER5, A.JOURNAL_ID, A.JOURNAL_DATE, A.JOURNAL_LINE, A.BUDGET_DT, A.BUDGET_HDR_STATUS, A.BUDGET_LINE_STATUS, A.KK_TRAN_OVER_FLAG, A.KK_TRAN_OVER_OPRID, A.KK_TRAN_OVER_DTTM, A.GL_DISTRIB_STATUS, A.APPL_JRNL_ID, A.CURRENCY_CD, A.FOREIGN_CURRENCY, A.FOREIGN_AMOUNT, A.RT_TYPE, A.DOC_TYPE, A.DOC_SEQ_NBR, A.DOC_SEQ_DATE, A.RATE_MULT, A.RATE_DIV, A.FROM_ACCRUAL, A.ENTRY_EVENT, A.IU_ANCHOR_FLG, A.IU_SYS_TRAN_CD, A.IU_TRAN_CD, A.BI_PRELD_STAT, A.ERROR_STATUS_BI, A.CF_ACTION_FLG FROM PS_BI_IIP2_TAO4 A WHERE A.IU_LINE_TYPE='N' AND A.ACCOUNT<>' ' AND PROCESS_INSTANCE=123456789
      /
      -- Row(s) affected: 0
      -- 2021-06-11 21:47:03.642 Process 123456789 ABENDED at Step IU_PROCESSOR.U400.U400-010 (Action SQL) -- RC = 805
      ROLLBACK
      /
      -- 2021-06-11 21:47:03.668 SQL Error: ORA-00001: unique constraint (EMDBO.PS_BI_ACCT_LN_STG2) violated "

As the Billing Pre Load Process (BIPRELD AE Program) is abending, the transactions are not able to get created as Invoices in Billing module, which delays further processing.

The Billing Pre Load Process (BIPRELD AE Program) should be able to handle all possible scenarios and transactions, and not abend in such a manner.

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.