R12/ CE: How to Default Other GL Date Scheduling for the Bank Statement Import Program (Doc ID 2168997.1)

Last updated on AUGUST 11, 2022

Applies to:

Goal

When scheduling the Bank Statement Import Program to run daily the GL date parameter increments each day and uses sysdate by default. This works throughout the month.   However, this behaviour causes issues during month end.

See the following scenario:

On August 1, 2016 the program runs and imports bank statements from prior business day July 29, 2016. However the gl date parameter is defaulted to August 1.

Therefore accounting from auto-reconciliation is happening in the August period instead of the July period which is the business requirement.

NOTE: The user needs the program to always use the bank statement header gl date for autoreconciliation.
The best possible outcome is that the system will use the bank statement header date as the gl date and the users do not need to populate anything.

Is there a SQL or another workaround to default the gl date parameter correctly?

Is there a way to automate the date to be populated correctly in this parameter if the users are going to schedule the program to run daily?
 

Solution

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