After Changing Status Of Delivery, expected data did not appear in the Billing Interface (Doc ID 2276805.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

There is a delivery whose RELEASED_STATUS is Shipped instead of interfaced after run the interfaced request.In order to repair the status,we queried the OE_INTERFACED_FLAG and INV_INTERFACED_FLAG in wsh_delivery_details and found the status of the two shipping lines under this delivery is incorrect,which one had OE_INTERFACED_FLAG was N and INV_INTERFACED_FLAG was N,and the other one had OE_INTERFACED_FLAG was Y and INV_INTERFACED_FLAG was N.

As a result,we changed the two shipping lines as follows.

One shipping line's OE_INTERFACED_FLAG was changed into Y and INV_INTERFACED_FLAG was changed into P,and the other's INV_INTERFACED_FLAG was updated to P.

After changing the status in wsh_delivery_details,we ran the request Interface Trip Stop - SRS.

Then the status of the two shipping lines of the same delivery has become correct.However,there is an other question that the shipping line whose original OE_INTERFACED_FLAG was Y and INV_INTERFACED_FLAG was N before updating doesn't appear in the billing interface.As for another shipping line,it has generated AR Invoice.

Now we need your help to solve the question as above.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms