Oracle Order Management Tables

oe_order_headers_all
oe_lines_all
oe_lot_serial_numbers
oe_sales_credits
oe_price_adjustments
oe_headers_iface_all
oe_lines_iface_all
oe_lotserials_iface_all
oe_credits_iface_all
oe_actions_iface_all
oe_price_adjs_iface_all
oe_reservtns_iface_all

Oracle Purchasing Tables

po_requisition_headers_all
po_requisition_lines_all
po_req_distributions_all
po_headers_all
po_lines_all
po_distributions_all
rcv_transactions
po_requisitions_interface_all
po_reschedule_interface
po_headers_interface
po_lines_interface
po_distributions_interface

Oracle Inventory Tables

mtl_system_items
mtl_item_revisions
mtl_item_categories
mtl_material_transactions
mtl_transaction_lots_numbers
mtl_serial_numbers
rcv_shipment_headers
rcv_shipment_lines
mtl_system_item_interface
mtl_item_revisions_interface
mtl_item_categories_interface
mtl_transaction_interface
mtl_transaction_lots_interface
mtl_serial_numbers_interface
rcv_headers_interface
rcv_transactions_interface

Order Management Setup Checklist

1 Define Set of Books
2 Define Flexfields
3 Multiple Organization
4 Inventory Organizations
5 Profile Options
6 Parameters
7 Invoicing
8 Salespersons
9 Tax
10 Quick Codes
11 Workflow
12 Document Sequence
13 Order Import Sources
14 Units of Measure
15 Item Information
16 Items
17 Configurations
18 Pricing Formulas
19 Price Lists
20 Customer Class
21 Customers
22 Item Cross-Reference
23 Sourcing
24 Agreements
25 Transaction Types
26 Cost of Goods Sold (COGS)
27 Modifier and Freight Charges
28 Processing Constraints
29 Defaulting Rules
30 Credit Checking
31 Holds
32 Attachments
33 Shipping Setup

*If the text appears mis-aligned in the mail sent on the group, please visit http://applearn.blogspot.com

Purchasing Setup Checklist

1 Define set of books
2 Define descriptive flexfields
3 Define organizations
4 Define cross-reference types
5 Define profile options
6 Define financials options
7 Define accounting flexfield combinations
8 Define tax names
9 Define payment terms
10 Open and close General Ledger (GL) accounting periods
11 Open purchasing and inventory accounting periods
12 Define locations
13 Define location associations
14 Define job flexfield
15 Define jobs
16 Define position flexfield
17 Define positions
18 Define position hierarchies
19 Enter employee
20 Define item categories flexfield
21 Define category
22 Define category sets
23 Define default category set
24 Define control rules and groups
25 Define position controls
26 Fill employee hierarchy
27 Define usernames
28 Define purchasing lookup codes
29 Define freight carriers
30 Define inspection codes
31 Define hazard classes
32 Define United Nations (UN) numbers
33 Define standard notes
34 Define unit of measure classes
35 Define units of measure
36 Define unit of measure conversions
37 Define system items flexfield
38 Define item attribute controls
39 Define item templates
40 Define item catalog flexfield
41 Define item catalog groups
42 Define buyers
43 Define item
44 Define item relationships
45 Define line types
46 Define document controls
47 Start autosubmit
48 Define purchasing options
49 Define receiving options
50 Enter vendors
51 Define your transactions reasons
52 Set up Oracle Workflow
53 Request your receiving transaction processor
54 Define your concurrent process resubmission interval