My Oracle Support Banner

R12: -FV_TREASURY_PAYMENTS_PKG.pkb Doesn't Handle Permanently Closed Periods (Doc ID 2006179.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle U.S. Federal Financials - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

FV_TREASURY_PAYMENTS_PKG.pkb does not handle Permanently Closed periods (FVAPPAYS.pls and FVAPPAYB.pls).
We plan to Permanently Close periods in the near future but the Disbursements in Transit Voided Checks standard concurrent request fails with a create accounting error.

The FND Debug log says that the date of the void of the treasury confirmation is in SEP-14, which is Permanently Closed, so it's failing. After looking at the FV_TREASURY_PAYMENTS_PKG.pkb, the code only considers 'C'losed periods.
After updating the gl_period_statuses.closing_status to 'C' from 'P' in a development environment, the process completed successfully.

Patch 18283418 still only considers 'C'losed Periods, not 'P'ermanently Close periods and we have not yet implemented GTAS which is a pre-req for this patch.

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
References


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