Depending upon the EDI standard, user requirements, and the application data, a single Oracle Application internal data element may require one to five external data elements for the interface data file to satisfy the data requirements for the EDI standard or the trading partner.
Define code conversion categories. See: Defining Code Conversion Categories.
Assign Code Conversion Categories. See: Assigning Categories.
Navigate to the Code Conversion Values folder window
Enter the category code.
Select a direction from the List of Values.
This can be BOTH, IN, or OUT depending whether you want to convert different external values to the same internal values for inbound transactions. Or, if you want to convert different internal values to the same external value for outbound transactions.
The following validation is performed on your entries:
External values must be unique among IN and BOTH directions for the same search keys.
Internal values must be unique within OUT and BOTH directions for the same search keys.
The internal value and external values must be unique for all directions for the same search keys.
Enter search key values (1 - 5) for the set of internal / external values.
If you set a document standard when you defined the trading partner and want to perform code conversion based on document standard, enter that document standard in Search Key 1.
Use this only if search keys are enabled in the Code Conversion Categories window and columns are identified in the Assign Categories window.
Enter the internal and external codes (1 to 5) for one to many conversions.
The internal codes are the values defined in the base Oracle application. The external codes are the values defined in the trading partner application or the industry standard being used.
Additional Information: For additional information, see:
Code Conversion, Oracle e-Commerce Gateway Implementation Manual