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

Last updated on JANUARY 31, 2024

Applies to:

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.

Changes

Cause

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