Steps to Load Data from American Express

Access the Load External Data page.

Loading American Express Transaction Data

To load transaction data from American Express:

  1. Access the Load External Data page.

  2. Select American Express KR 1025 or GL 1025 in the Data Source field.

  3. Enter the path and name of the American Express data file in the File Name field.

  4. Entering a file name and path is optional if you reprocess credit card data.

  5. Select Load External Data.

American Express delivers multiple transaction types in a record called KR-1025 GL1025, but PeopleSoft Expenses uses only transaction type 1.

The Process Scheduler runs the Load External Data Application Engine process that drives the staging process (EX_PUB_AMEX for KR1025 or EX_PUB_AMXGT for GL1025) and the loading process (EX_LOAD_AMEX). The staging process populates the staging table (EX_AM_K10_TA1 for KR1025 or EX_AM_G10_TA1 for GL1025). The loading process then:

  1. Checks for invalid values and loads errors into the EX_AMEX_STG_ERR table.

  2. Completes the load process by loading data into the EX_TRANS table.

Loading American Express Maintenance Data

To load maintenance data from American Express:

  1. Select American Express - KR1205 or GL1205 in the Data Source field.

  2. In the File Name field, enter the path and name of the American Express data file.

    Entering a file name and path is optional if you reprocess credit card data.

  3. Select Load External Data.

Note:

The file for American Express (KR1205 or GL 1205) is sent one time per week. Therefore, you should select and run American Express - KR1205 or GL 1205 in the Data Source field prior to running the Load External Data process for the American Express data source. This ensures that all maintenance and file updates occur prior to processing transactions.

The Process Scheduler runs the Load External Data process that drives the publishing process (EX_PUB_AMEX2 for KR1205 or EX_PUB_AMXA for GL1205) and the loading process (EX_LOAD_AMX2 for KR1205 or EX_LOAD_AMX2 for GL1205).

See the Load External Data process flow for account maintenance diagram:

See Understanding the Load External Data Process.