[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