Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Thursday, November 10, 2011

[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