[GTM] R12: Awaiting Export Screening

At Sales Order line, after order booked, you see the line status became "Awaiting Export Screening" and not "Awaiting Shipping". Why?

It is caused by a extra Oracle module that we have integration with, GLOBAL TRADE MANAGEMENT (GTM). GTM will do the screening and feedback to EBS that whether this order line has passed the screening rule. If Yes, order line status will changed to "Awaiting Shipping". If Not, order line status will remained as "Awaiting Export Screening", and as a result, you cannot proceed with Pick Release.

[QP] R12: BACK_CALCULATION_ERROR: QP_PREQ_PUB.BACK_CAL: NO MANUAL ADJ

BACK_CALCULATION_ERROR: QP_PREQ_PUB.BACK_CAL: NO MANUAL ADJ error after you tried to override the price defaulted from Price List.


Fix => Define Discount Modifier, set it to Manual, Modifier Type = Discount, Override flag = Yes. Assign it to the right Qualifier.

[OM] R12: Sales Agreement Activation Date

During creation of Sales Order, we can tie the Sales Order to a Sales Agreement. Sales Agreement pre-stores information like Customer, Accounting, Pricing, etc.

We can controls how the Sales Agreement get applied (similar to functionality of Qualifier in Price List). At the Main tab, we can defined Item Context, which controls how the Sales Agreement take effects. At the Pricing tab, it can links to Price List, which will get defaulted when Sales Agreement is selected.

Note:
Activation Date in Sales Agreement, it is the effective start date (OE_BLANKET_LINES_ALL.START_DATE_ACTIVE), it ties to Request Date at the order line.

[SYS] R12: Enable Audit Trail

Step to enable AuditTrail:

(1) AuditTrail->Install
ONT Oracle Order Management Account

(2) AuditTrail->Groups
Application Name: Order Management
Audit Group: XX_ABC_GROUP
Group State: Enabled
...
User Table Name: OE_ORDER_LINES_ALL

(3) AuditTrail->Tables
User Table Name: OE_ORDER_LINES_ALL
Table Name: OE_ORDER_LINES_ALL
Application: Order Management
Column: UNIT_SELLING_PRICE, etc

After completed above steps, run "AuditTrail Update Tables". It will then add additional columns into the table and create a new trigger on it.

Schedule "Audit History Consolidator" to collect the audit data.

[PO] R12: Sales Order Reference in PR Interface Table

Drop Shipment, a booked Sales Order will trigger interface records into PO_REQUISITIONS_INTERFACE_ALL table.

How to trace back the original SO number from this table?

Get GROUP_CODE, which is reference back to the Sales Order header_id.