Monday, January 23, 2017

Oracle EDI Application Transaction Code


EDI module provide standard interface for transactions with your trading partner.
Purchase Order:- 

Transaction Code
Transaction Name
Direction
EDIFACT
832
Price/Sales Catalogue
Inbound
PRICAT
843
Response to Request for Quotation
Inbound
QUOTES
856
Ship Notice/Manifest
Inbound
DESADV
857
Shipment and Billing Notice
Inbound
-
824
Application Advice
Outbound
APERAK
850
Purchase Order
Outbound
ORDERS
860
Purchase Order Change
Outbound
ORDCHG

Order Management:-

Transaction Code
Transaction Name
Direction
EDIFACT
850
Purchase Oder
Inbound
ORDERS
860
Purchase Oder Change
Inbound
ORDCHG
855
Purchase Oder Acknowledgment
Outbound
ORDRSP
865
PO Change Acknowledgment
Outbound
ORDRSP

Oracle Payables:-

Transaction Code
Transaction Name
Direction
EDIFACT
810
Invoice
Inbound
INVOIC
857
Shipment and Billing Notice
Inbound
-
824
Application Advice
Outbound
APERAK
820
Payment Order/Remittance Advice
Outbound
PAYORD-REMADV
PAYEXT-REMADV

Oracle Receivables:-

Transaction Code
Transaction Name
Direction
EDIFACT
810
Invoice
Outbound
INVOIC
812
Credit Memo/Debit Memo
Outbound
CREADV/DEBADV
Process Manufacturing:-

Transaction Code
Transaction Name
Direction
EDIFACT
850
OPM: Purchase Order
Inbound
ORDERS
855
OPM: Purchase Order Acknowledgment
Outbound
ORDRSP
856
OPM: Ship Notice/Manifest
Outbound
DESADV


EDI Transaction Support:-

The following transactions are supported:
ASC X12EDIFACTDocument IDDescription
Inbound Transactions
810INVOICINIInbound Invoice
832PRICATCATIInbound Price / Sales Catalog
843QUOTESRRQIInbound Response to Request for Quote
850ORDERSPOIInbound Purchase Order
856DESADVASNIInbound Ship Notice / Manifest
857No equivalentSBNIInbound Shipping and Billing Notice
Outbound Transactions
824APERAKADVOOutbound Application Advice
810INVOICINOOutbound Invoice
820PAYORD / REMADVPYOOutbound Payment Order / Remittance Advice
830DELFORSPSOOutbound Planning Schedule
862DELJITSSSOOutbound Shipping Schedule
850ORDERSPOOOutbound Purchase Order
860
865
ORDCHG
ORDCHGACK
POCO
POCOACK
Outbound Purchase Order Change Request
Outbound Order Change Acknowledgment 
856DESADVDNSOOutbound Ship Notice / Manifest

No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...