O2C Technical
Order Management Module
(OE,OM)
Order Entry Screen – Table Relations
OE_TRANSACTION_TYPES_TL
HZ_PARTIES HZ_CUST_ACCOUNTS_ALL
HZ_CUST_SITE_USES_ALL OE_PRICE_LISTS
Order Entry Screen – Table Relations
MTL_SYSTEM_ITEMS_B OE_PRICE_LIST_LINES
OE_TRANSACTION_TYPES_TL
WSH_CARRIER_SHIP_METHODS
Order Hold Definitions – Table Relations
OE_HOLD_DEFINITIONS
Order Import – Table Relations
OE_ORDER_PUB
OE_ORDER_PVT
OE_HEADERS_INTERFACE OE_ORDER_HEADERS_ALL
ORDER
IMPORT
OE_LINES_INTERFACE OE_ORDER_LINES_ALL
Order Holds – Table Relations
OE_HOLD_DEFINITIONS
Base Tables – Order Header
OE_TRANSACTION_TYPES_ALL OE_ORDER_SOURCES
TRANSACTION_TYPE_ID
ORDER_SOURCE_ID
TRANSACTION_TYPE_ID
OE_TRANSACTION_TYPES_TL
ORDER_TYPE_ID ORDER_SOURCE_ID
NAME
OE_ORDER_HEADERS_ALL
SOLD_TO_ORG_ID (Customer) SHIP_TO_ORG_ID (Ship Location)
INVOICE_TO_ORG_ID (Bill To Location)
Transaction SITE_USE_ID
Types Form
(Transaction Type Name) HZ_CUST_SITE_USES_ALL
CUST_ACCT_SITE_ID
CUST_ACCOUNT_ID
HZ_PARTIES PARTY_ID HZ_CUST_ACCOUNTS_ALL CUST_ACCOUNT_ID HZ_CUST_ACCT_SITES_ALL
Base Tables – Order Lines
TRANSACTION_TYPE_ID
OE_TRANSACTION_TYPES_ALL
OE_ORDER_HEADERS_ALL
PRICE_LIST_ID
HEADER_ID
MTL_SYSTEM_ITEMS_B
OE_PRICE_LISTS SEGMENT1
SEGMENT1
PRICE_LIST_ID
ITEM_DESCRIPTION ORDERED_ITEM HEADER_ID
UNIT_LIST_PRICE
OE_PRICE_LIST_LINES OE_ORDER_LINES_ALL
LIST_PRICE
SHIPPING_METHOD_CODE FREIGHT_CARRIER_CODE
SHIP_METHOD_CODE FREIGHT_CODE
WSH_CARRIER_SHIP_METHODS WSH_CARRIERS
Account Receivables Module
(AR,RA)
Terms in AR
Invoice: Given to Customer who bought the Item (also
called a transaction)
Receipt: Customer Payment Entry
Unapplied Receipt: A receipt created but invoice is not
identified (e.g. Customer Paid in Advance)
Applied Receipt: A receipt is created and the invoice is
identified.
Credit Memo: Return of goods by Customer (Negative
Invoice)
OM to AR Interface Details
TRANSACTION_TYPE_ID
OE_ORDER_HEADERS_ALL
ORDER_NUMBER
HEADER_ID
OE_ORDER_LINES_ALL
TRANSACTION_TYPE_ID
LINE_NUMBER
OE_TRANSACTION_TYPES_TL
INVOICE_SOURCE_ID NAME
Order Management
INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE1
(Setup Dependent) (Setup Dependent)
LINE_NUMBER
RA_INTERFACE_LINES_ALL
BATCH_SOURCE_ID BATCH_SOURCE_NAME
NAME
RA_BATCH_SOURCES_ALL
Account Receivables
OM to AR (Invoicing)
HEADER_ID
OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL
ORDER_NUMBER LINE_NUMBER
Order Management
INTERFACE_LINE_ATTRIBUTE1 LINE_NUMBER
INTERFACE_LINE_ID
RA_INTERFACE_LINES_ALL RA_INTERFACE_ERRORS_ALL
INTERFACE_LINE_ATTRIBUTE1 LINE_NUMBER
INTERFACE_LINE_CONTEXT
Auto invoice
Import Program
INTERFACE_HEADER_CONTEXT
INTERFACE_HEADER_ATTRIBUTE1
LINE_NUMBER
CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_ALL RA_CUSTOMER_TRX_LINES_ALL
Account Receivables
Payment Schedules
Table: AR_PAYMENT_SCHEDULES_ALL
List of Invoices Created
How much is paid (Applied)?
How much is left to pay (Schedules)?
Receipts
AP_BANK_ACCOUNTS_ALL HZ_CUST_SITE_USES_ALL
BANK_ACCOUNT_ID
SITE_USE_ID
REMITTANCE_BANK_ACCOUNT_ID CUSTOMER_SITE_USE_ID
AR_CASH_RECEIPTS_ALL
RECEIPT_METHOD_ID PAY_FROM_CUSTOMER
RECEIPT_METHOD_ID CUST_ACCOUNT_ID
AR_RECEIPT_METHODS HZ_CUST_ACCOUNTS_ALL
Receipts Application
RA_CUSTOMER_TRX_ALL AR_CASH_RECEIPTS_ALL
CUSTOMER_TRX_ID CUSTOMER_TRX_ID CASH_RECEIPT_ID
CASH_RECEIPT_ID
APPLIED_CUSTOMER_TRX_ID
AR_RECEIVABLE_APPLICATIONS_ALL
APPLIED_PAYMENT_SCHEDULE_ID
PAYMENT_SCHEDULE_ID
CUSTOMER_TRX_ID
AR_PAYMENT_SCHEDULES_ALL
Assignment
Step1: Create an Item <Yourname>_item
Step2: Create a Customer <Your_name>
Step3: Create an Order by this customer and item. Functional
Step4: Bring the Order to a closure.
Step5: Invoice it.
Step6: Create a receipt and apply it to the invoice.
Step7: write a query with following columns for your
order: Customer Name, Order Number, Item, Order
Technical
Status, Line Status, Invoice Number, receipt Number,
Fully Paid?.
Mail me the Query. SUB: O2C Training Assignment
Questions?