[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.

[QP] R12: Modifier: New Price

We can apply a modifier that totally replace the Unit Selling Price in R12.

Original List Price and Unit Selling Price is $10, a qualified modifier with value of $20. When this modifier applied, we will get Unit Selling Price of $20.

Oracle Pricing Manager
Modifier->Modifier Setup->Modifiers Summary->Override=Yes
Modifier->Modifier Setup->Discount/Charges->Modifier Type=Discount
Modifier->Modifier Setup->Discount/Charges->Application Method=New Price