My Oracle Support Banner

Automatic Clearing Of Receipts Job Is Failing With GL Date Error (Doc ID 2676173.1)

Last updated on JUNE 08, 2020

Applies to:

Oracle Receivables - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Automatic clearing of receipts job is failing with GL Date error on last day of period even though the period is open.



Arguments
------------
P_CLR_REMITTED_RECEIPTS='Y'
P_CLR_DISC_RECEIPTS='Y'
P_ELIMINATE_BANK_RISK='Y'
P_CLEAR_DATE='2019/12/27 06:00:00'
P_GL_DATE='2019/12/27 06:00:00'
p_br_report='N'
p_total_workers='1'
------------


Step To Reproduce:


Make sure that XXX period is not open
1. Create a receipt with GL Date as the last day of XXX period in Remitted status
2. Schedule the Automatic Clearing for Receipts (ARZACS) program to run every 2 hours, starting one day before the last day of XXX period.
3. The program fails when it runs the with parameter GL Date with last day of the month with time higher than 00:00



 

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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