R12:OIE: APXEXPER - IS EXPORTING THE EXPENSE REPORT WITH WRONG GL_DATE (Doc ID 1427225.1)

Last updated on JULY 06, 2017

Applies to:

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

Symptoms


On : 12.0.6 version, 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

Cause

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 hundreds of Community platforms