My Oracle Support Banner

EBI 9.2: Standard and Express Billing Invoice Accounting Pages Allowing Budgetary Only Accounts To Be Selected (Doc ID 2877861.1)

Last updated on JUNE 20, 2022

Applies to:

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

Symptoms

When entering Invoices on the Standard Billing, or Express Billing pages, users are able to select Accounts that have been defined as 'Budgetary Only', which should not be the case.

The issue appears to be caused by the logic in the GL_ACCT_MON_VW delivered Record. The SQL for the view is below does not consider any Effective Date rows in the logic pointing to the PS_GL_ACCOUNT_TBL table.  This allows any account that has ever had the BUDGETARY_ONLY box unchecked to be selected even if the current Effective Dated row has the Account ChartField Value set to 'Budgetary Only'.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as a Billing User
    2.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Design Chartfields > Define ChartField Value
    3.- Open delivered Account 430300 under Set ID SHARE
    4.- Confirm that there is one Effective Date row, with value 01-01-1900, and the 'Budgetary Only' flag is not selected
    5.- Add a new Effective Date row, with a value of 01-01-2021, and ensure that this time the 'Budgetary Only' check-box is selected
    6.- Save the changes
    7.- Navigate to: Billing > Maintain Bills > Standard Billing
    8.- Proceed to enter a new Invoice under Business Unit US001, with an Invoice Date and Accounting Date of 12-20-2021
    9.- At the Revenue Distribution tab, select the look-up icon for the Account field
    10.- Confirm that the Account 430300 is available for selection, and that the transaction can be saved without problems
    11.- Go to the AR Offset tab
    12.- Do the exact same steps for the Look-Up icon on Account field for the AR Distribution section, and confirm that Account 430300 is eligible for selection as well
    13.- Navigate to: Billing > Maintain Bills > Express Billing
    14.- Proceed to enter a new Invoice under Business Unit US001, with an Invoice Date and Accounting Date of 12-20-2021
    15.- Go to the Revenue Distribution tab, and select the look-up icon for the Account field on both AR Offset and Revenue sections
    16.- Confirm that the Account 430300 is available for selection on both fields, and that the transaction can be saved without problems

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.

The ability to select an Account that is marked as 'Budgetary Only' for the Dates the Invoice is created on creates downstream issues when the entries are sent to the General Ledger module. The Billing Journal Entries cannot post due to an edit error, so the Journal(s) must be updated manually, and the PS_BI_ACCT_ENTRY and PS_BI_LINE_DST tables must be updated via SQL on the back end in order to keep the information in sync.

The delivered SQL Views behind the Loo-Up features on the Account fields from both Standard and Express Billing should filter out Account values whose Effective Date row for the transaction is defined as 'Budgetary Only', or if allowed to be selected, there should be online validations triggering an Error Message stating that the Account selected needs to be modified in order to proceed.

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.