My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Internet Expenses - Version 12.1.1 and later
Information in this document applies to any platform.
Implementing American Express Global Card Program – Credit card format GL1025

Companies can choose to have a single card provider provide the corporate cards for their employees globally. This is referred to as a global card program.

A global card program consists of a number of company accounts defined under that card program each of which can be uniquely identified through a set of pre-determined fields. The company account normally equals to an operating unit, a regional section of the company, or a cost center. Corporate Cards are issued under each company account.

Each company account may have its own card issuing banks (card issuer) and also payment terms and other agreements specific to that company account.


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:

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.  

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

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

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.

Employee matching using Employee ID, automatic card creation, and itemization behave the same way as in the processing of file format KR1025. 

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

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

Join the Oracle Payables Community to discuss further with other Oracle Payables Experts and learn more from your peers.

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
 
New and Changed Features
 Upgrade Impact
Actions
Contacts
References

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