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 SEPTEMBER 09, 2024
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.
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 |