My Oracle Support Banner

R12:OIE: Expense Report Export program Is Exporting the Expense Reports with Wrong GL_DATE (Doc ID 1427225.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Internet Expenses - Version 12.0.6 and later
Information in this document applies to any platform.
APXEXPER Expense Report Export


When running the Expense Report Export program with current date eg ( 09-Feb-12) , with 2 open GL periods, JAN-12 and FEB-12,

The GL_DATE of Invoices and Distributions is taking as the first day of the first open period - 01-JAN-12

Expect the GL_DATE of Invoices and Distributions to take the date of ( 09-Feb-12)

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. The two periods of AP and GL are open (JAN-12 and FEB-12).
2. Today is 07-FEB-2012.
3. Create an expense report, submit and approve the report.
4. Run the program - Expense Report Export
5. Verify that the GL DATE has value 01-JAN-2012


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

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

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