Order Management - EBS (MOSC)

MOSC Banner

How to fetch the order line number info. for the quantity changed on the sales order.

edited Jul 18, 2020 5:12AM in Order Management - EBS (MOSC) 1 commentAnswered

Hello:

   We're running Oracle EBS R12.1.3 and we capturing the certain changes on the order lines via audit history. Currently, we're able to fetch the changes in order quantity or price via OE_AUDIT_ATTR_DESC_V view.

   However, we're having hard time linking the change to a specific order line since, the line_id is not recorded in this view. What is the approach of linking the change to the corresponding order line or is there any specific view or table

   from where I can get the corresponding line_id or line_number info. pertaining to the order? I'd check in oe_order_lines_history table, but I'm unable to link it to OE_AUDIT_ATTR_DESC_V view.

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