How to enable history for order line?

How to enable audit history for order line?

Requirement:
How to store values in the order Line History (Audit History)?

Solution:
1. Logon to oracle application using Order Management Super User –> Setup –> Rules –> Processing Constraint

2. Query Record for:
    Application – Order Management
    Entity – Order Line


3. Create entery with following attributes value:
    Operation – Update
    Attribute – Unit Selling Price
    User Action – Require reason and Require History OR Require History .


4. Enable it and save your work.
5. Now try to change “Unit Selling Price” for order line.

6.  And review order line history data using  following query.

    SELECT   header_id,
             line_id,
             unit_selling_price,
             TRUNC (HIST_CREATION_DATE) HIST_CREATION_DATE
      FROM   oe_order_lines_history
     WHERE   line_id = <oe_line_id>

 ===========
Keywords
===========
ORDER LINE HISTORY; OE_AUDIT_ATTR_HISTORY; OE_ORDER_LINES_HISTORY; PROCESSING CONSTRAINTS; REQUIRE REASON

This entry was posted in Oracle E-Business Suite.

One Response to How to enable history for order line?

  1. Luciana says:

    I truly knew about a lot of this, but never the less, I still assumed it turned out practical. Great blog!