MultiOrg Concept in Oracle Apps R12

Multi-Org in simple term means the implementation of multiple business units (or Organization) under a single installation of Oracle Applications. The concept of Multi-Org will manage the operations of an enterprise which has got subsidiaries across globe under a single oracle apps window, taking appropriate care of data security and data maintenance. Below are some of the features of multiple organization functionality.

·         Any number of Business Units in an Enterprise can be supported within a single installation of Oracle Application

·         User can access the data corresponding to and limited to the operating unit

·         Reporting can be managed at different organization levels like, Business Group, Ledger, Operating unit etc

·         Transactions like Procurement, Receiving, Selling, Shipping Etc. with the same Party Can be Performed through Different Organization and can be managed internally through inter company postings

how to hold sales order from backend.

oe_holds_pub.release_holds
p_release_reason_code:='hold released';

how to cancel sales order from backend.

oe_order_pub.process_order
cancelled_flag ='Y'

Explain P2P Cycle

Ø  Create a requisition

Ø  create RFQ

Ø  create a quotation from quote analysis

Ø  generate a PO

Ø  receipt of material

Ø  create Invoice in payables

Ø  Transfer to GL.

Receipt Routing

Receipt Routing is of three types

Direct: once the goods arrive at the destination, we directly move them to a specific Sub-Inv.

Standard: once the goods are at the destination, we receive it at the receiving point first and then move them to the Sub-Inv.

Inspection: once the goods are at the destination, we receive it at the receiving point and then we perform inspection and accordingly we either accept it or reject them.

Link between PO_HEADERS_ALL AND RCV_SHIPMENT_HEADERS (PO and Receipts)

RCV_SHIPMENT_LINES.PO_HEADER_ID = PO_HEADERS_ALL.PO_HEADER_ID

RCV_SHIPMENT_LINES.PO_LINE_ID = PO_LINES_ALL.PO_LINE_ID

RCV_SHIPMENT_LINES.TO_ORGANIZATION_ID = PO_LINE_LOCATION_ALL.SHIP_TO_ORGANIZATION_ID

RCV_SHIPMENT_HEADERS.SHIPMENT_HEADER_ID = RCV_SHIPMENT_LINES.SHIPMENT_HEADER_ID

RCV_SHIPMENT_HEADERS. SHIP_TO_ORGANIZATION_ID= PO_LINE_LOCATION_ALL.SHIP_TO_ORGANIZATION_ID

LInk between PO_HEADERS_ALL and PO_REQUISITION_HEADERS_ALL

PO_DISTRIBUTIONS_ALL. REQ_DISTRIBUTION_ID = PO_REQ_DISTRIBUTIONS_ALL. DISTRIBUTION_ID(+)