EBI 9.2: Validate Button Triggers Error Message for Department ID Values on InterUnit Customer Invoices for Records BI_LINE_IU_EXP and BI_HDR_AR When Bill Was Created Using Copy Bill (Doc ID 2972788.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Symptoms

The Copy Single Bill page (Panel BI_BILL_CPY) wrongly issues a Validation error on Records BI_HDR_AR, and BI_LINE_IU_EXP, marketing the Department ID ChartField value, when copying a Billing Invoice transaction pertaining to an InterUnit Customer.

The original Billing Invoice for the InterUnit Customer contains valid ChartField Values for InterUnit Expense Accounting, which were entered at the time of creating the transaction. The problem stems from the fact that each of the involved Business Units use a different Set ID value at Record Group FS_06 (Departments), so while within their respective Set IDs, the Department ID values entered exist, they are not defined on the other Business Units' Set ID.

Asides of the above problem, an additional roadblock was found upon creating the Invoice online, where the Revenue Distribution Accounting line also gets flagged the Department ID value entered as invalid, when setting the Invoice Status in RDY (Ready), while upon creation, the Department ID look-up feature displays the value selected as eligible.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as a System Administrator User
    2.- Navigate to: PeopleTools > Utilities > Administration > Maintain TableSet Controls
    3.- Under Set Control ID US005, define in Record Group FS_06 (Departments), the Set ID value of US005
    4.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Define Values > Define ChartField Value > Department
    5.- Create a new Department ID 12345 under Set ID US005
    6.- Navigate to: Customers > Customer Information > Create Customer Information
    7.- Open Customer ID USA96 under Set ID SHARE
    8.- Go to the Bill To Options tab, and ensure that InterUnit Customer check-box is selected, and the GL Business Unit is pointing to US005
    9.- Log into the FSCM Online Application as a Billing User
    10.- Navigate to: Billing > Maintain Bills > Standard Billing
    11.- Define the following values, and click then on ADD button:
              a) Business Unit = US001
              b) Invoice = NEXT
              c) Bill Type Identifier = SVC
              d) Bill Source = SERVICE
              e) Customer ID = USA96
              f) Invoice Date = Today's Date
              g) Accounting Date = Today's Date
    12.- Go to the Line - Info 1 tab, and enter the below values:
              a) Quantity = 1
              b) Unit of Measure = EA
              c) Unit Price = 2,000.00 USD
              d) Gross Extended = 2,000.00 USD
    13.- Go to the Revenue Distribution tab (Navigation = Acctg - Rev Distribution), and define the following values:
              a) Account = 100100
              b) Department ID = 25000     (Valid value under Set ID SHARE)
    14.- Go to the AR Distribution tab (Navigation = Header - AR Distribution), and define the following values:
              a) Account = 100100
              b) Department ID = 25000     (Valid value under Set ID SHARE)
    15.- Go to the InterUnit Expense tab (Navigation = Acctg - InterUnit Exp/Inv), and define the following values:
              a) Account = 200103
              b) Department ID = 12345     (Valid value under Set ID US005)
    16.- Save the changes
    17.- Go to the Header - Info tab, and set the Status in RDY (Ready)
    18.- Save the changes again
    19.- PROBLEM #1: The system throws an Error Message (12500,1027) stating that the Revenue Distribution Line Accounting has an invalid Department ID value
    20.- Go to the Revenue Distribution tab (Navigation = Acctg - Rev Distribution), blank out the Department ID value, and save the changes anew
    21.- Navigate to: Billing > Generate Invoices > Non-Consolidated > Single Action Invoice
    22.- Create a new Run Control ID, pointing to the Business Unit, and Invoice ID transaction
    23.- Launch the delivered BIJOB03 PSJob
    24.- Navigate to: PeopleTools > Process Scheduler > Process Monitor
    25.- PROBLEM #2: Find the Process Instance of PSJob BIJOB03, and confirm it went to Warning. Drilling further, it is due to Pre-process and Finalization (BIIVC000 AE Program), and Billing Pre-Load (BIPRELD AE Program) not handling any transactions
    26.- Navigate to: Billing > Maintain Bills > Copy Single Bill
    27.- Define the Business Unit US001, and the Invoice ID just created, and open the Copy Single Bill page
    28.- Select the 'Copy Bill' radio-button, click on Create Bills button, and save the changes
    29.- The new Copy Bill invoice ID will be displayed
    30.- Click on the Validate button
    31.- PROBLEM #3: The system throws a new Error Message stating that there are Validation Errors on ChartField DEPTID within Record Names BI_HDR_AR and/or BI_LINE_IU_EXP

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 MESSAGES:

The generated Invoice transactions seem to be incorrectly flagged with errors, when values selected are valid. This confuses Users upon creating, and processing the transactions further.

The VALIDATE' button/functionality on the Copy Single Bill page should only check Accounting transaction data present in Record PS_BI_ACCT_ENTRY for AR and RR lines, and not the Expense related ones.

Cause

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