Oracle_ebs_MFG_Interface.ppt

Manufacturing Distribution Open Interface Open Interface Architecture Three different methods for import and export data(inbound and outbound) Interface Tables(In) Interface Views(Out) Function Calls or Programmatic Interfaces(In/Out) Interface Tables Requires some validation through a concurrent program You can write directly to the tables if you are familiar with them Interface Views Views simplify the data relationships for easier processing Ex: mtl_item_quantities_view Defined in Technical Reference Manual Dynamic Views for Oracle Quality Function Calls Tight integration without adding a batch process to move data Ex: ECO API Ex: PO API Inbound Interface Model Open Interface Components Source Application Destination Application Interface Table Identifier Columns Control Columns Data Columns Required Columns Derived Columns Optional Columns Errors Table Database View Load Function sql loader to temp table temp to interface Validate Function Process Function Maintain Function Ex: open interface window Open Interfaces Oracle Inventory Item Import Transaction Interface Replenishment Cross-Reference Cycle Count Kanban Lot Reservation Move Order Oracle Purchasing Requisition Interface Purchase Interface Receiving Interface Oracle Bill of Material BOM Import Routing Import Substitution Import Designator Import Open Interfaces Oracle Work in Process Job Import Move Transaction Resoruce Transaction Oracle Master Scheduling Forecast Import MPS/MDS Import Oracle Engineering ECO Interface Order Management Order Import Sales Order API Oracle Quality Result Import Item Import Interface Table mtl_system_items_interface Updated table mtl_system_items Concurrent Program Import Items Errors Table mtl_interface_errors Required data item_number organization_code description process_flag(1, Pending) transaction_type(CREATE) Item Table Relationship Transaction Interface Interface table mtl_transactions_interface Updated table mtl_material_transactions Concurrent Program Process t