My Oracle Support Banner

CTA Reclass Process For Manual Journals Does Not Generate Exceptions If The Cash In And Out Do Not Balance - An Exception Should Be Generated (Doc ID 2883365.1)

Last updated on JULY 19, 2022

Applies to:

Oracle U.S. Federal Financials - Version 12.2 and later
Information in this document applies to any platform.
FVCTATXB.pls
CTA Process
CTA Detail Listing
Exception
Reclass
Not Balanced

Symptoms

The CTA Detail listing report should generate an exception where cash in and cash out do not net zero.

User ran the CTA Process for a Manual journals

In the manual journal there is only cash in

Example:
Cr 10100002 for FUND A for 1000.00 --> disbursement cash
Dr 61000001 for FUND A 1000.00 -- Operating expense

The journal is selected and is in both the CTA Detail Transaction Listing report and in the bulk file.

User understanding of the CTA bulk file is to inform Treasury to move cash from one TAS to another.

Example journal where there is cash out of FUND A and collected into FUND B

Cr 10100002 for FUND A for 1000.00 --> disbursement cash
Dr 61000001 for FUND A 1000.00 -- Operating expense
Dr 10100005 for FUND B for 1000.00 --> Collection Cash
Cr 59000002 for FUND B for 1000.00 --> Revenue

CTA bulk file should report DISGF out of TAS A and COLL into TAS B

User is expecting something like this

Cr 10100002 for FUND A for 1000.00 --> disbursement cash
Dr 61000001 for FUND A 1000.00 -- Operating expense
Dr 10100002 for FUND C for 1000.00 --> cash disb adjustment
Cr 61000001 for FUND C for 1000.00 --> reverse expense

CTA bulk file should report DISGF out of TAS A and DISGFAJ into TAS C

The CTA Detail Listing should check that Dr and Cr net to 0 within each journal for cash out and cash in and if not balanced should report an exception.

This is not currently happening

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
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.