Upload a Cash Advance File from a Third-Party System
You can provide cash advance data using a comma-separated plain text .csv file that is uploaded to Oracle Universal Content Management using the File Import and Export page.
After the file is uploaded, the expense auditor runs the Upload Cash Advance process from the Scheduled Processes page.
Valid cash advance records are created or updated directly into the cash advance tables. Rejected records are listed in the output file, along with the reason for rejection.
The following table contains fields in the cash advance file that you create in TextPad and upload.
Each line in TextPad must contain at least 10 elements. If more than 10 elements are used, it's assumed that the Purpose field contains one or more commas and these extra fields are concatenated.
Field |
Required |
Notes |
Maximum Characters |
---|---|---|---|
Cash Advance Number |
Yes |
Not applicable |
60 |
Person Number |
Yes |
|
120 |
|
Yes |
|
960 |
Unapplied Amount |
Yes |
Not applicable |
18 |
Status |
Yes |
|
30 |
Cash Advance Type |
Yes |
Must be one of the existing lookup codes for the EXM_CASH_ADVANCE_TYPE lookup type. The values are OTHER and TRAVEL. |
30 |
Due Date |
No |
MMDDYYYY |
8 |
Trip Start Date |
No |
MMDDYYYY |
8 |
Trip End Date |
No |
MMDDYYYY |
8 |
Purpose |
Yes |
This last field can contain commas. |
240 |
Uploading the Cash Advance File
To upload the cash advance file, follow these steps:
-
Sign in to Expenses as the expense auditor.
-
Navigate to: Navigator > Tools > File Import and Export.
-
On the File Import and Export page, click the Upload (+) icon.
-
In the Upload File dialog box, click Browse to find the file that you want to upload.
-
From the Account choice list, select fin/expenses/import.
-
Click Save and Close .
Running the Upload Cash Advance Process
To run the Upload Cash Advance process, follow these steps:
-
Navigate to: Navigator > Tools > Scheduled Processes.
-
On the Scheduled Processes page, click Schedule New Process.
-
In the Schedule New Process dialog box, select the Job option.
-
From the Name choice list, select Upload Cash Advances and click OK.
-
In the Process Details dialog box in the File Name field, enter the same file name that you uploaded in Step 4 in the previous task.
-
From the Allow update of existing records choice list, select Yes and click Submit.
If you select Yes, you can update existing cash advances. If you select No, you can't update existing cash advances. You can only create new cash advances.
Note:If you select Yes to update an existing record, but the existing cash advance has already been invoiced, the record is rejected.
-
Click the Refresh icon.
The upload cash advance details appear.
-
Review the .log and .txt files by clicking the attachment links.
-
Sign out as the expense auditor.
-
Sign in to Expenses as an employee.
-
From the Expenses work area, review the Cash Advances infotile.