Order Management Tables

-


Entered
OE_ORDER_HEADERS_ALL
1 record created in header table
OE_ORDER_LINES_ALL
Lines for particular records
OE_PRICE_ADJUSTMENTS
When discount gets applied
OE_ORDER_PRICE_ATTRIBS
If line has price attributes then populated
OE_ORDER_HOLDS_ALL
If any hold applied for order like credit check etc
Booked
OE_ORDER_HEADERS_ALL
Booked_Flag=Y, Order booked.
WSH_DELIVERY_DETAILS
Released_Status Ready to release
Pick Released
WSH_DELIVERY_DETAILS
Released_Status=Y Released to Warehouse (Line has been released to Inventory for processing)
WSH_PICKING_BATCHES
After batch is created for pick release
MTL_RESERVATIONS
This is only soft reservations. No physical movement of stock

Full Transaction
MTL_MATERIAL_TRANSACTIONS
No records in MTL_MATERIAL_TRANSACTIONS
MTL_TXN_REQUEST_HEADERS

MTL_TXN_REQUEST_LINES

WSH_DELIVERY_DETAILS
Released to warehouse
WSH_NEW_DELIVERIES
If Auto-Create is Yes then data populated
WSH_DELIVERY_ASSIGNMENTS
Deliveries get assigned
Pick Confirmed
WSH_DELIVERY_DETAILS
Released_Status=Y Hard Reservations. Picked the stock. Physical movement of stock
Ship Confirmed
WSH_DELIVERY_DETAILS
Released_Status=C ;Shipped ;Delivery Note get printed Delivery assigned to trip stop quantity will be decreased
MTL_MATERIAL_TRANSACTIONS
On the ship confirm form, check Ship all box
WSH_NEW_DELIVERIES
If Defer Interface is checked then OM & inventory not updated. If Defer Interface is not checked: Shipped
OE_ORDER_LINES_ALL
Shipped_Quantity get populated
WSH_DELIVERY_LEGS
1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.
OE_ORDER_HEADERS_ALL
If all the lines get shipped then only flag N
Auto Invoice
WSH_DELIVERY_DETAILS
Released_Status=I Need to run workflow background process.
RA_INTERFACE_LINES_ALL
Data will be populated after work flow process.
RA_CUSTOMER_TRX_ALL
After running Auto Invoice Master Program for
RA_CUSTOMER_TRX_LINES_ALL
Specific batch transaction tables get populated


Customer Information
HZ_PARTIES
Get Customer information include Name, 
Contacts, Address and Phone
HZ_PARTY_SITES

HZ_LOCATIONS

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_SITES_ALL

HZ_CUST_SITE_USES_ALL

RA_CUSTOMERS

Price Details
QP_LIST_HEADERS_B
To Get Item Price Details.
QP_LIST_LINES

Items On Hand Qty
MTL_ONHAND_QUANTITIES
To check On Hand Qty Items.
Payment Terms
RA_TERMS
Payment terms
Sales Order Holds
OE_HOLD_DEFINITIONS
Order Hold and Managing Details
OE_HOLD_AUTHORIZATIONS

OE_HOLD_SOURCES_ALL

OE_ORDER_HOLDS_ALL

Hold Release
OE_HOLD_RELEASES_ALL
Hold released Sales Order
Credit Check Details
OE_CREDIT_CHECK_RULES
To get the Credit Check Against Customer.
Cancel Orders
OE_ORDER_LINES_ALL
Cancel Order Details.
Automatic Numbering System
AR_SYSTEM_PARAMETES_ALL
You can check Automatic Numbering is enabled/disabled
Document Sequence
FND_DOCUMENT_SEQUENCES
Document Sequence Numbers
FND_DOC_SEQUENCE_CATEGORIES

FND_DOC_SEQUENCE_ASSIGNMENTS

Default Rules For Price List
OE_DEF_ATTR_DEF_RULES
Price List Default Rules
OE_DEF_ATTR_CONDNS

AK_OBJECT_ATTRIBUTES

End User Details
CSI_T_PARTY_DETAILS
To capture End user Details
Sales Credit
OE_SALES_CREDITS
Sales Credit Information
Attaching Documents
FND_ATTACHED_DOCUMENTS
Attached Documents and Text information
FND_DOCUMENTS_TL
Fnd documents short text
Blanket Sales Order
OE_BLANKET_HEADERS_AL
Blanket Sales Order Information.
OE_BLANKET_LINES_ALL

Processing Constraints
OE_PC_ASSIGNMENTS
Sales order Shipment Schedule Processing Constraints
OE_PC_EXCLUSIONS

Comments

  1. Unknown15 July 2016 at 23:49

    This comment has been removed by the author.

    ReplyDelete
  2. Amber Taylor16 June 2021 at 02:33

    Very efficiently written information. It will be beneficial to anybody who utilizes it, including me. Keep up the good work. For sure i will check out more posts. This site seems to get a good amount of visitors. Best Order Management Software

    ReplyDelete
  3. Fin29 October 2021 at 01:08

    I have read a few of the articles on your website now, and I really like your style of blogging. I added it to my favorites blog site list and will be checking back soon. Please check out my site as well and let me know what you think. How to make a po

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle Purchasing Module Step by Step in R12

-
Image
PURCHASING  All the Purchasing related activity information will be declared in Purchasing              Procure 2 Pay Cycle : Requisition à RFQ à Quotation à Quotation Analysis à Purchasing à Receiving à Invoice  à  Payment à Reconciliation PO-Integration :  PO  is integrated by GL, AP, I Supplier, Procurement, and Project Accounting  PO  Responsibility             Step1: Define  PO  Responsibility                         Nav: System administrator à Security à Responsibility à Define             Step2: Assign  PO  options to the PO Responsibility                 ...
Read more

Sub Ledger Accounting SLA (Complete Functional Information)

-
Image
SubLegder Accounting in R12 SLA Part -1 In these article, we will explore the very basics of SLA and why it exists. Firstly, what exactly does SLA do? SLA is a module which now sits between the SubLedgers like AP/AR etc and the General Ledger. Have a look at this diagram below.  As you will notice, SLA can act as a mediator between the subledgers and Oracle General Ledger. Before we progress, some terminologies of R12 must be revisited. In 11i we had set of books, and in R12 we call them Ledgers. Likewise in R12 we also have secondary ledgers and reporting ledgers. Hence from 11i perspective think of Ledger as Set of Books. As for Subledger, a Subledger is nothing but a module like AP/AR/PO/Inventory etc. In the diagram below, the second scenario is explained whereby let's say that payables module generates a charge account segment combination for an invoice distribution line as A.B.C.D. In such case, if SLA module is not customized, then the very same A.B.C.D ...
Read more

Difference between ATO and PTO in oracle apps

-
Difference between ATO and PTO in oracle apps 1) MAKE TO ORDER: This is based on Customer specification, you make the product and supply it to them. This is applicable for Engineering items or any Product which you can make based on Customer order Example: Engineering Items 2) ASSEMBLE TO ORDER: This is you have items in parts and it needs to be assembled according to customer requirements For example you have Laptop coming with standard configuration of 160GB Hard disk and 1 GB RAM. But there are customer orders coming in asking for 200GB Hard Disk and 2 GB RAM and if you can assemble them to suit Customer Requirement 3) CONFIGURE TO ORDER: This is Configuring the Product itself to suit Customer requirements Example. The Thread Manufacturing unit Machineries are configured. I have seen Laxmi Machine Works in INDIA which manufactures textile Machineries configure the machineries based on No.of spindles 4) PICK TO ORDER: This is same as Computer Example in ATO. But the  differenc...
Read more