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 X12	EDIFACT	Document ID	Description
Inbound Transactions
810	INVOIC	INI	Inbound Invoice
832	PRICAT	CATI	Inbound Price / Sales Catalog
843	QUOTES	RRQI	Inbound Response to Request for Quote
850	ORDERS	POI	Inbound Purchase Order
856	DESADV	ASNI	Inbound Ship Notice / Manifest
857	No equivalent	SBNI	Inbound Shipping and Billing Notice
Outbound Transactions
824	APERAK	ADVO	Outbound Application Advice
810	INVOIC	INO	Outbound Invoice
820	PAYORD / REMADV	PYO	Outbound Payment Order / Remittance Advice
830	DELFOR	SPSO	Outbound Planning Schedule
862	DELJIT	SSSO	Outbound Shipping Schedule
850	ORDERS	POO	Outbound Purchase Order
860 865	ORDCHG ORDCHGACK	POCO POCOACK	Outbound Purchase Order Change Request Outbound Order Change Acknowledgment
856	DESADV	DNSO	Outbound Ship Notice / Manifest

Oracle - E- Business – E-Commerce - EDI

EDI Stands for Electronic Data Interchange.

EDI is the electronic data exchange the information between trading partners. Data files are exchanged in a standard format to minimize manual efforts, speed data processing and ensure accuracy.

EDI, electronic funds transfer (EFF), electronic mail and fax as increasingly being used to schedule operations, streamline order fulfillment and optimize cash flow

 Simple EDI Business Flow:-

1.       Customer creates the Purchase Order (PO) for purchase the items.

2.       Then customer send the PO through mail or fax  to supplier

3.       The supplier receive the PO and valid the PO requirement information

4.       Next supplier Enter/Create the Sales Order  on this System

5.       The supplier send the Sales order acknowledge to customer through fax or mail.

6.       The Supplier shipped the items to the customer .when the items shipped, the supplier arise Invoices to the customer.

7.       The customer makes the payment based on invoice.

Let us imagine, how much information needs to transfer the data and tracked run the business, cost, process times and data errors etc., using Intermediate communication link - EDI performing effective way of business

Organizations that send or receive documents between each other are referred to as "trading partners" in EDI terminology. Trading partners are free to use any method for the transmission of documents. Few of the transmission mediums used are Value Added Network (VAN), Internet/AS and Web EDI.

EDI translation software, popularly known as Translator, validates the partner and checks if the data received meets the standard formats defined before converting it to a desired file format which can be read and imported by the receiver's computer systems (for e.g. ERP).

EDIFACT & X12 are most widely followed EDI standards. The standards prescribe the formats, character sets, and data elements used in the exchange of business documents and forms.

EDI Standard Exchange format:

X12 - The American National Standards Institute (ANSI) chartered the Accredited Standards Committee (ASC) X12 to develop uniform standards for industry electronic exchange of business transactions-electronic data interchange (EDI)

UN/EDIFACT - United Nation Electronic Data Interchange for Administration, Commerce and Transport. UN/EDIFACT is an international EDI standard designed to meet the needs of both government and private industry.

The UN/EDIFACT Working Group (EWG), a permanent working group of the United Nations Centre for Trade Facilitation and Electronic Business (UN/CEFACT), develops and maintains UN/EDIFACT.

Hints: X12 is used in the USA but most of the rest of the world uses the EDIFACT transaction sets.

Components:

There are five process involved in EDI

ü  Sender

ü  Receiver

ü  Language

ü  Content

ü  Medium

In EDI, Sender and Receiver are called as trading partner (like customer and vendors). X12 or EDIFACT standards supply a common language for formatting the information content of common message

Terminology used in EDI:

Ø  Transaction Set - Business document transmitted between companies (e.g. Purchase Order).

Ø  Data Segment - Units of data used to communicate specific information within a message (e.g. the header).

Ø  Data Element - Specific unit of data within a data segment.

Ø  Trading Partner - Entity such as a customer, supplier, or organization with whom electronic commerce is executed.

Ø  EDI Standards - Agreed to formats for exchanging electronic data (typically developed by representatives of industry verticals).

Ø  Translator - Software application that translates data into or out of a specific format or standard for processing by an ERP system

Oracle EDI e-Commerce Gateway – Functionality

• Define Trading Partner Relationships
• Define Code Conversions
• Customize Flat File Formats (like xml,xls,.csv etc)
• Use Standard Report Submission
• Initiate Extract Process
• Initiate Import Process
• View Extract/Import Process Status

Basic Unix Commands

The UNIX operating systems is a set of programs that act as a link between the computer and user

Command/Syntax	Example	Description
$ users		Check the user name
$ who		Check the user information
$ whoami		Get the user name
$ Finer		Display ,who is on computer in the lap
Directories .[dot]  & ..[dot dot]		Filename .(dot) point out current working directory Filename ..(dot dot) represent one level above the current working directory
$ ls		List out files in current directories
$ ls -l		List all files in the current working directory in long listing format showing permissions, ownership, size, and time and date stamp
$ls -a		List out content folder , including the hidden files Hints: Linux file starting with ‘.’ is hidden
$ pwd		Display the current working directory path
$ ps		Display information about programs that are running currently
$ Date		Display the current day , date time and year
$ uname		Uname – Unix name, displayed details information about OS, kernel and machine name Example : Linux asiat16 2.6.18-308.20.1.el5PAE #1 SMP Tue Nov 6 04:43:35 EST 2012 i686 i68 GNU/Linux Ø  “Linux“: The machine’s kernel name. Ø  “asiat16 “: The machine’s node name. Ø  “2.6.18-308.20.1.el5PAE “: The kernel release. Ø  “#1 SMP “: The kernel version. Ø  “i686“: The architecture of the processor. Ø  “GNU/Linux“: The operating system name.
$history		History command ,use to prints the history of long list executed commands in terminal list
$ cd		Change current directory to another directory
$ sqlplus		Command used to open the sqlplus programming
$ sqldr	$ sqldr control=text.ctl log=text.log	Sqlldr command user to load the data . .ctl – control life , .log – log file
$ ps	$ ps  , $ps –f	List out own running process status (ps). –f flag used to detail information
$ mkdir	$mkdir ver1	Making new directory name
$ rmdir	$rmdir ver2	Remove the directory
$ rm	$rm test1.txt	Delete or remove the file
$ mv	$mv P1.txt  p2.txt	Move or Rename file
$ man	$man grep	Online helping manual about command lists. Return back Cursor press esc, then enter ‘:’ last press q.
$ more	$mode view.html	Look at the file , one page at a time
$ cp	$cp oldfile.txt newfile.txt	Copy command. The copy data from old file and paste into new file
$ lpr	$lpr source.html	Send the file to printer
$ find	$ find .- name test.txt –print $find .-name  “.txt” -print	This command  list out all the files within directory and sub-directories in certain name
$ cal	$ Cal $ cal 8 2014	Display the calendar
$ grep  <string><File>	$ Gred “error”*	Find which files are condition certain word
$ chmod	$chmod o+rx myfile	This command used to assign / permission to access. Read, write and execute is that abbreviated as r,w,x Permission will be assign by value. For Read (r) = 4, write(w)=2, Execute(x)=1
$ Kill	$ kill %2	This command use to destroy or kill  any jobs or programs that you have suspended and are unable to restart
$ Vi	$ vi testfile	This command use to start vi text editor window. Once you start Vi editor you need to switch the program from command mode to insert mode by pressing i. To navigate around the document with the cursor keys, you must switch back to command mode by pressing Esc. To execute any of the following commands, you must switch from command mode to ex mode by pressing: (the colon key): Enter w to save; wq to save and quit; q! to quit without saving.
$ Cat	$ Cat  Header.html	You can see the content of the file
$wc	$ wc  Header.html	Count of the total number of lines ,characters and words contained in the file
$ mail [-s] [-c][-b] to-addr	$ mail –s  “Mail send” admin@gmail.com	Command used to send and receive mail. -s  => specify subject on command line -c => send carbon copies to list of user -b => blind carbon copies to list of user
$ ping hostname or  ip-address	$ ping yahoo.com	The command send the echo request to host available  on the network