R12: OIE: Support For American Express Global Card Program – Credit Card Format GL1025 (Doc ID 1119813.1)

Last updated on JUNE 09, 2023

Applies to:

Details

Oracle Internet Expenses now enables companies that use American Express corporate cards to receive corporate card transaction files in the global format GL1025. Changes are made to the existing corporate card programs setup to support the global format GL1025. A new concurrent program is introduced to upload and process GL1025 format files.

New and Changed Features

1. Changes to Card Programs form

A new region named ‘Global Card Program Details’ is added to capture the details of the global card program. The new details captured to represent global card program are as follows:

• Global Program Name

Stores the name for the global program. This is a name defined by the company to represent their relationship with the corporate card provider in the application. The global name should be the same for all card programs for which the transactions come in the same GL1025 file.  

• Market Code

Stores the American Express Market Code. Market code is the code assigned by American Express to represent a region or a section of a region in which they operate. American Express will provide the list of market codes applicable to your company. You can also identify the market codes applicable to your company from the GL1025 file. The locations for market code in the transaction file are as follows.

Field Name	Description	Length	Start	End	Record Type
Market Code	American Express Market Code (used in Global Remittance)	3	37	39	8- Market Header
Market Code	Amex Market Code (used in Global Remittance)	3	2	4	1- Transaction Detail

• Company Account Number

Stores the Global Client Origin Identifier which is a number defined in the American Express’s database to represent the company or a portion of the company. American Express will provide a list of all global client origin identifiers applicable to your company. You can also identify the global client origin identifier from the GL1025 file. The location for the global client origin identifier in the transaction file are as follows:

Field Name	Description	Length	Start	End	Record Type
Global Client Origin Identifier	A number used to represent a corporate client	15	5	19	1 – Transaction Detail

2. Changes to Data File Transfer page

To support automatic download of global format GL1025, a new row called ‘GLOBAL’ is added to the Data File Transfer page. The parameters defined for the row ‘GLOBAL’ is independent of operating units. All global card programs for American Express will use the setup defined for ‘GLOBAL’ to automatically download files from the American Express’ server. The parameters that need to be set up are the same as the parameters for KR1025 automatic download. Refer to the document 1111385.1 for setup details.

3. New concurrent program to receive and process global format GL1025

A new concurrent program called American Express Global Feed Transaction Loader and Validation Program is available for processing GL1025 format.

Upgrade Impact

There is no upgrade impact to customers who do not implement GL1025. Customers who want to receive and process global format GL1025 must perform the following steps:

1. Set up global card programs

• Customers with existing card programs can convert these card programs to company accounts under a global card program by updating the card programs with the following details:
• Enter the global card program name. The global card program name is the same for all card programs that need to be under a single global card program.
• Enter the market code. This is the market code associated with the existing card program.
• Enter the company account number. This is the global client origin identifier that represents the existing card program.
  
  
• Customers with existing card programs can convert these card programs to company accounts under a global card program as follows: 
• Identify a name to be used as the global card program name.
• Create each global client origin identifier as a corporate card program in the application.
• Enter global client origin identifier as the company account number.
• Enter market code.
• Assign the global card program name to all global client origin identifier under the same program.

2. Set up automatic download parameters

Set up the connection parameters for automatic download for the row ‘GLOBAL’ in the Data File Transfers page. Detail of the setup is described in note 1111385.1. This step is required only for customers who wish to use the automatic download capability for American Express files provided within Internet Expenses. If you are using a third party software for download, you will download the file before invoking the new concurrent program.

3. Schedule American Express Global Feed Transaction Loader and Validation Program

Schedule the concurrent program American Express Global Feed Transaction Loader and Validation Program at appropriate intervals to download and process GL1025 files.

Actions

Customers on 12.1.1 and 12.1.2 and 12.1.3:

Apply Patch 9669749:R12.OIE.B: Changes to enable the Expenses to download the datafile from new Amex server.  Contact Oracle Support if prompted for a password for the patch.


This feature is only for 12.1.1 forward.

 *****************************************************************************

Change Record:
Date: March 10, 2011
Description of Change:
For Customers on 12.1.1 and 12.1.2,
Patch 9374743: R12.OIE.B removed from note and replaced by Patch 9669749:R12.OIE.B

 *****************************************************************************

Change Record:
Date: March 27, 2013
Description of Change:
Patch 9374743: R12.OIE.B is also needed for customers on 12.1.3

 *****************************************************************************

Contacts

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.