EBI 9.2: Record Field PS_BI_ACCT_ENTRY.APPL_JRNL_ID Not Populating Correctly if Multiple BUs and Invoices Run BIPRELD AE Program at the Same Time
(Doc ID 2799241.1)
Last updated on AUGUST 16, 2021
Applies to:PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
It has been detected that when Billing Invoices, on multiple Billing Business Units, are being processed through the Single Action Invoice process (BIJOB03 PSJob, including BIPRELD AE Program), the AR side of the Billing Accounting Entries that are created, has an incorrect Journal Template ID being defaulted, (Stored within Record Field PS_BI_ACCT_ENTRY.APPL_JRNL_ID).
The Revenue side (ACCT_ENTRY_TYPE = 'RR') of the entry has the correct Journal Template assigned, only the Receivables side (ACCT_ENTRY_TYPE = 'AR') has the incorrect value assigned.
1.- Log into the FSCM Online Application as a Billing User
2.- Navigate to: General Ledger > Journals > Subsystem Journals > Journal Generator Template
3.- Create a new Journal Template called BI_US003
4.- Create a second new Journal Template called BI_US005
5.- Navigate to: Set Up Financials/Supply Chain > Business Unit Related > Billing > Billing Definition
6.- Open Business Unit US003, go to the Business Unit 1 tab, and ensure that Journal Template is having the value of BI_US003. Additionally, ensure AR and GL Business Unit values point also to US005.
7.- Open Business Unit US005, go to the Business Unit 1 tab, and ensure that Journal Template is having the value of BI_US005
8.- Navigate to: Billing > Maintain Bills > Express Billing
9.- Create a new Billing Invoice under Business Unit US003, enter the Line Amounts, and Revenue Accounting, and set it to a Status of RDY (Ready to Invoice)
10.- Create a new Billing Invoice under Business Unit US005, enter the Line Amounts, and Revenue Accounting, and set it to a Status of RDY (Ready to Invoice)
11.- Navigate to: Billing > Generate Invoices > Non-Consolidated > Single Action Invoice
12.- Create a new Run Control ID with two Sequence Numbers, one for each Business Unit (US003, and US005), pointing to their respective newly created Invoice IDs
13.- Click on the RUN button
14.- Select the BIJOB03 PSJob
15.- Click on OK button
16.- Navigate to: PeopleTools > Process Scheduler > Process Monitor
17.- Confirm that the BIJOB03 PSJob has completed in Success
18.- Query PS_BI_ACCT_ENTRY Table for the 2 Invoices processed, and check for the rows where the Field ACCT_ENTRY_TYPE = 'AR'. On those rows, confirm that Field APPL_JRNL_ID stores the incorrect Journal Template value
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.
In General Ledger, the Journals are getting incorrectly assigned to the wrong Business Units, as the Journal Template IDs stored in the Accounting Entries are used to achieve that.
The Record Field PS_BI_ACCT_ENTRY.APPL_JRNL_ID should get properly assigned the expected values for each Billing Business Unit Invoice on the AR Accounting Entry rows.
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