Oracle A75089-02 - Manual (Page 44)

Code Conversion
4-2 Oracle e-Commerce Gateway User’s Guide
Code Conversion
The Oracle e-Commerce Gateway Code Conversion Module is a flexible and
extremely powerful feature used to reconcile (convert) values from your trading
partner’s application or industry standard to values stored within Oracle
Applications.
Code conversion is a common problem in any integration scenario where coded
values such as Unit of Measure Code or Currency Code are represented differently
in each of the applications being integrated. Many times, rules for performing these
conversions can become quite complicated.
If you are integrating with trading partners using multiple applications and/or
standards, a simple lookup table with “to” and “from” columns will not be
sufficient. Advanced code conversion rules based on trading partner, industry
standard, or transaction direction are required to support these complex application
integration relationships. Code conversion rules in Oracle e-Commerce Gateway
are defined as a set of ”to” and ”from” values plus additional attributes to
determine specific code conversion processing behavior.
Key features of the Oracle e-Commerce Gateway Code Conversion Module include:
■
User defined code conversion categories (e.g. UOM, Currency Code).
■
User defined activation/assignment of code conversion for specific data
elements.
■
Code conversion based on a user defined multi-level hierarchy.
■
Code conversion based on trading partner standard (e.g. ASC X12, EDIFACT).
■
Code conversion based on direction of transaction (inbound, outbound, or
both).
■
One-to-Many, Many-to-One conversions.
To enable code conversion for specific data elements within a transactions, there are
three easy setup steps:
■
Define Code Conversion Category
■
Define Code Conversion Values
■
Assign Code Conversion Category
Define Code Conversion Category allows you to enter all of the categories
applicable to your business processing environment. A category is defined as a
group of code conversion rules applicable to a single data element. Many