My Oracle Support Banner

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.

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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.