Order Management - EBS (MOSC)

MOSC Banner

Credit Check Processor and OE_CREDIT_CHECK_RPT

edited Sep 6, 2017 5:00AM in Order Management - EBS (MOSC) 4 commentsAnswered

ALL:

Whenever an order is booked, the flow_status_code immediately goes to "Awaiting Shipping."  

When the Credit Check processor runs, it calls a private API, oe_credit_check_rpt.  In this package body, there is a query that contains the following where clause:

AND    OL.flow_status_code = ''BOOKED'' 

Since Orders always have a flow_status_code of 'AWAITING SHIPPING' when booked, this condition will always fail, therefore the Credit Check Processor will NEVER place an order on hold.

What's the purpose of this where clause?

If I want orders to be put on credit check failure hold, then this where condition needs to be removed. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center