After Changing Status Of Delivery, expected data did not appear in the Billing Interface
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms