EBI 9.2: Billing Invoice Still Can Be Placed on Status RDY via Online or BIIVCSTS Batch Process Even if Customer Is Inactive (Doc ID 2827124.1)

Last updated on MARCH 02, 2023

Applies to:

Symptoms

It has been detected that the Invoice Status Change process (BIIVCSTS SQR Program) is able to place Invoices' Statuses from a value of NEW (New) to a value of RDY (Ready to Invoice) even if the transactions' Customer is set to Inactive.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as a Billing User
    2.- Create a new Customer, and place it into Active status
    3.- Create a new Invoice in Billing for this one Customer, and ensure it has a status of NEW (New)
    4.- Go back to the Customer component, and set that Customer ID into a status of Inactive
    5.- Navigate to: Billing > Maintain Bills > Change Status of Bills
    6.- Create a new Run Control ID with the below settings:
            a) From Status = New
            b) To Status = Ready
            c) Range Selection = Invoice ID
            d) Business Unit and From/To Invoice corresponding to the transaction just created on prior point #3
    7.- Launch the Invoice Status Change process (BIIVCSTS SQR Program)
    8.- Confirm that the Invoice Status Change process (BIIVCSTS SQR Program) has completed in Success
    9.- Review the resulting INVOICE STATUS CHANGE REPORT (Report ID BIIVCSTS), and confirm that the Invoice ID transaction previously created is now listing a Status value of RDY
    10.- Go to the Standard Billing component, open the Invoice transaction at hand, and confirm indeed that its Status is RDY (Ready to Invoice)

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.

Such Invoice transactions will have a Status of RDY (Ready to Invoice), which will make them eligible for being included in further processes to take part down the line.

If the Customer linked to the Invoice transaction has been set to Inactive, the Invoice Status Change process (BIIVCSTS SQR Program) should not consider as eligible such transactions, and leave them be in NEW status.

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.