My Oracle Support Banner

R12: OIE: Expenses Upload Rates Program Fails to Import Rates with Message "Cannot create Standard Rate for Invalid Location Id" (Doc ID 2934353.1)

Last updated on APRIL 28, 2023

Applies to:

Oracle Internet Expenses - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When trying to add a new location and per diem rate for 'Saint Lucia' to International Per Diem expense policy schedule for US (process is based on the OCONUS file upload), the Expenses Upload Rates log file shows:

Location Status : INVALID
City Locality : Saint Lucia

Cannot create Standard Rate for Invalid Location Id: XXXXX

 

 Steps:

1. A .txt file is prepared based on file with published OCONUS rates (downloaded from US .gov website).
2. File is placed under a certain path
3. Then go to: Internet Expenses Setup and Administration>>Internet Expense Setup, then click on "Request" menu and complete fields as follows:

        Rate type = OCONUS 

        Action = Update Schedule

        Data file = /path from step 2./{File name from steps 1-2}.txt

        Expense Category = Per Diem

        Schedule Name = Name_of_the_schedule

4. Click UPLOAD button

5. Two requests are launched:

     Expenses OCONUS Loader

     Expenses Upload Rates

6. Wait for them to successfully complete

7. The OCONUS rates are uploaded.

Changes

 The issue is not caused by any changes.

Cause

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
Symptoms
Changes
Cause
Solution


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