My Oracle Support Banner

EBI9.2: Incorrect ERROR_STATUS_BI When Loading Unknown Customer ID in Billing Interface for VAT Enabled BU (Doc ID 2645232.1)

Last updated on FEBRUARY 01, 2023

Applies to:

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

Goal

How to solve incorrect ERROR_STATUS_BI when loading unknown Customer ID in Billing Interface for VAT enabled BU?

Business scenario:
When loading the billing interface for a BU where VAT is enabled with a Customer ID that is invalid, the billing interface creates an interface error as expected but the error code is related to Missing Required VAT data (0412) instead of Invalid Customer (0060). This causes confusion as it lets users believe the Customer was correct but something else is wrong. Also on the INTFC_BI_AEDS the correct error is shown.

When thinking about this and analyzing the program, it looks like the ERROR_STATUS_BI is updated for each error it finds.
A more logic way would be that the program should check for errors and if an interface line has already been set to error by the process, it should leave the error status (unless the error is cleared of course), since that original error is most likely the first one that needs to be resolved.

REPLICATION STEPS
=================
1. Create Billing Excel Upload file with Customer ID that doesn't Exist for a BU that has VAT enabled;
2. Load data in the interface tables by running billing interface process ;
3. Result - Billing Interface -1 page is showing incorrect message error -0412 (Missing Required VAT Data), instead of receiving error message 0060 (Invalid Customer);
Still, AEDS error does show under 0060 - under Billing Interface - 1 page.

Solution

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
Goal
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.