This chapter covers the following topics:
This section briefly describes Oracle e-Commerce Gateway setup steps. For the complete discussion, refer to Setting Up, Oracle e-Commerce Gateway Implementation Guide.
Note: Oracle e-Commerce Gateway relies on several base Oracle E-Business Suite. Please refer to the setup and open interfaces documentation for those products. See: Setting Up, Oracle e-Commerce Gateway Implementation Guide.
Profile options must be set up for basic e-Commerce Gateway functions. See: Oracle e-Commerce Gateway Profile Options.
To use e-Commerce Gateway, you must first define database directories for PL/SQL file I/O to store both inbound and outbound transactions. You must then specify these directories in the appropriate e-Commerce Gateway profile options.
See: Define Database Directories, Oracle e-Commerce Gateway Implementation Guide.
First, define a trading partner group and associate the group with an operating unit that is linked to your responsibility as well as associate all trading partner location (address) entities to this group. Assign the trading partner to an address entity in Oracle E-Business Suite such as a customer, supplier, or bank branch address. The trading partner assignment and entry of the trading partner detail data establishes the link between the trading partner as defined in Oracle E-Business Suite and its identification in your trading partner's application or EDI translator application. See: Overview of Trading Partners, Oracle e-Commerce Gateway Implementation Guide, and Defining Trading Partner Data.
The Oracle e-Commerce Gateway code conversion function provides a method by which trading partner and standard codes can be converted to Oracle E-Business Suite application codes and vice versa. See: Overview of Code Conversion, Oracle e-Commerce Gateway Implementation Guide.
Define code conversion categories to specify a subset of codes within the code conversion table. See: Defining Code Conversion Categories.
For each data element in a transaction that requires code conversion by e-Commerce Gateway, assign one code conversion category. See: Assigning Categories.
Enter the actual code conversion values from the internal codes to external codes into the code conversion table. The internal codes are defined in the Oracle E-Business Suite. The external codes are the associated values required by the trading partner or chosen EDI standard.
Oracle delivers a standard predefined data file format containing all the data that may be required to support a particular EDI transaction. You may customize this data file to meet specific business needs. See: Overview of Data File Structure, Oracle e-Commerce Gateway Implementation Guide and Changing the Interface Data File Record Layout.
Once data file directories, trading partner information, code conversions, and optional customizations of interface data file formats have been performed, use Oracle E-Business Suite Standard Request Submission to run extract programs for outbound transactions and import programs for inbound transactions.
Additional Information: For more information, see:
Setting Up, Oracle e-Commerce Gateway Implementation Guide
Profile Options, Oracle e-Commerce Gateway Implementation Guide
You must set the following system level profile options. They affect all e-Commerce Gateway transactions:
Outbound directory
Inbound directory
File location
Allow Split Words in Attachment
There are other transaction level profile options.
Enable / disable each transaction
Address derivation precedence
Attachment segment size
Enabling header-level attachments
Enabling line-level attachments
Enabling inventory line attachments
Enabling master item attachments
Note: There may be more profile options in other Oracle E-Business Suite products that affect e-Commerce Gateway. These products include: Purchasing, Inventory, Order Entry / Shipping, Payables, Receivables, Supplier Scheduling, and Planning.
This section lists system level profile options used in Oracle e-Commerce Gateway. Please note that each profile option is classified with a profile category. For more profile category information, see Oracle E-Business Suite Setup Guide.
Indicate the directory where inbound interface data files are expected. This value must match a database directory defined for PL/SQL file I/O.
Indicate the directory where outbound interface data files are written. This value must match a database directory defined for PL/SQL file I/O.
Note: For Oracle e-Commerce Gateway, you must define database directories for PL/SQL file I/O and then specify those directories in the "ECE: Inbound File Path" and "ECE: Outbound File Path" profile options. See: Define Database Directories, Oracle e-Commerce Gateway Implementation Guide.
If your Oracle E-Business Suite environment is Release 12.2.12 or if you have applied Patch 33736406:R12.EC.C or the Consolidated Physical File System Access Restriction Patch 33649463:12.2.0, then this profile option is available.
You can set this profile option to either of the following values:
Database File System (default)
By default, this profile option is set to "Database File System".
In this case, as in the existing system, the database file system will be used for reading the inbound transaction files, or writing the outbound transaction files.
Application File System
If you manually change the profile option value from the default "Database File System" to "Application File System", then ensure that you execute the script $EC_TOP/patch/115/sql/ec_adb_profiles_update.sql
.
This script will set the ECE_IN_FILE_PATH and ECE_OUT_FILE_PATH profile values to $APPLCSF/EBS_DBXFER/<APPL_SHORT_NAME>
and make these two profiles as non-updatable.
Note: Before submitting any Oracle e-Commerce Gateway inbound processing, you need to ensure that you manually move any unprocessed inbound files from the database file system to your application file system location. The file location for inbound and outbound transaction files is fixed as $APPLCSF/EBS_DBXFER/<APPL_SHORT_NAME>
where <APPL_SHORT_NAME>
is the application short name owning the EDI transaction. You may have to create the mentioned directory path in the application file system if it does not exist already.
Once you change the value from the default "Database File System" to "Application File System", it is not recommended that you change or revert its value back to "Database File System".
An attachment is usually plain text used as a note.
If you allow words to be split in an attachment, a new line begins within a word. If you do not allow words to be split, the new line is created after a space or a punctuation mark, not within a word. Thus, if you do not allow words to be split, some segment sizes fall below the attachment segment size, and vice versa.
New lines are created once the current line reaches the attachment segment size. For further information, refer to attachment segment size profile options for individual transactions.
Each transaction has a common set of profile options. For purposes of brevity, each type is documented below. For complete documentation, see: Oracle e-Commerce Gateway Profile Options, Oracle e-Commerce Gateway Implementation Guide.
Each of the profile options below lists the variable <transaction_code>. For a listing of the transaction codes used below, see: EDI Transaction Support.
Indicates whether the transaction is enabled at the site level. The default is Yes.
Applies to inbound transactions only. Determines the precedence by which trading partner addresses are derived.
When inbound EDI transactions are imported into Oracle E-Business Suite, the unique business site address must be established before the transaction can be processed. Each trading partner must have a unique address.
A trading partner is a site, such as a plant, a warehouse, a bank branch, or some other business unit. A trading partner is not necessarily a company; one company can have several sites.
The correct address can be obtained from three categories of components. They have unique address ids, location code/translator codes, location names, and physical addresses. These addresses are verified and validated as transactions are processed.
When you set this profile option using the Transaction Profiles window, you must select from the following values:
LOC (Default)- Address components and/or location code combination
The address is derived from the combination of location code and address components. If there is only one value provided, either location code or address components, the address will be derived based on the provided value. If both location code and address components are provided, then it will be based on the combination of both.
Note: If no address is found for both location code and address components or if the populated address components and location code do not match, then a message "Unable to derive ship to address" will appear.
If both location code and physical address are provided, then it will derive address through location code and compare it with that derived through physical address.
LTC - Location code/translator code combination
A trading partner must be set up first so that the address can be derived.
LPA - Location code/physical address/party details combination
The correct address is derived through the combination of location code, customer name, customer number, and address components. If there is only a partial set of values provided, the address will be derived based on the provided values.
Note: This feature is available only for address type "CUSTOMER".
You must set up each inbound transaction to derive the correct address.
The following profile options apply only to the Purchase Order Outbound (POO) and Purchase Order Change Request Outbound (POCO) transactions:
Enables the header attachment for the transaction. The default is No.
Enables the line attachment for the transaction. The default is No.
Enables the master item attachment for the transaction. The default is No.
Enables the inventory item attachment for the transaction. The default is No.
Enables the shipment attachment for the transaction. The default is No.
Sets the attachment segment size for the transaction. Attachments can be split into segments to accommodate their insertion into the interface data file. The segment size is expressed in bytes. The default is 400.
Additional Information: For more information, see:
Profile Options, Oracle e-Commerce Gateway Implementation Guide
Navigate to the Transaction Profiles window.
Transaction Profiles Window
Enter the outbound directory where your outbound interface data files will be stored. For example, /sqlcom/outbound.
Enter the inbound directory where your inbound interface data files will be stored. For example, /sqlcom/inbound.
Indicate whether to allow words to be split when the segment size is reached.
Navigate to the Transaction Profiles window.
Transaction Profiles Window
Select the transaction for which you want to set profile options.
See: EDI Transaction Support, Oracle e-Commerce Gateway Implementation Guide.
Indicate whether the transaction should be enabled or disabled.
For inbound transactions only, select the address precedence code. Refer to the profile option description for the meaning of each address precedence codes. See Oracle e-Commerce Gateway Profile Options.
For the Purchase Order Outbound (POO) and Purchase Order Change Request Outbound (POCO) transactions only, enter the attachment segment size, the number (in bytes) of each line in your attachments. The default it 400; the valid range is from 1 to 400. Once an attachment line reaches the segment size, it is split to create a new line.
For the POO and POCO transactions only, set up the following profile options:
Enable or disable the header attachment.
Enable or disable the line attachment.
Enable or disable the Inventory item attachment.
Enable or disable the master item attachment.
Enable or disable the shipment attachment.
Repeat these steps above for each transaction you use.
Additional Information: For additional information, see:
Oracle e-Commerce Gateway Profile Options
Setting Your Personal User Profile, Oracle E-Business Suite User's Guide
Common User Profile Options, Oracle E-Business Suite User's Guide
Profile Options in Oracle Application Object Library, Oracle E-Business Suite Setup Guide