My Oracle Support Banner

Federal Financials: After running CTA (Classification Transactions & Accountability) Fv_cta_audit Data Is Missing Some Values When AR Transaction Has More Than One Line With Same Code Combination Id (Doc ID 2979958.1)

Last updated on OCTOBER 10, 2023

Applies to:

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


After running CTA (Classification Transactions & Accountability) Table FV_CTA_AUDIT is missing values in the following: three columns:

This happens when there is more than 1 line on the transaction having the same Code Combination Id (GL Account).

Steps to Reproduce:

Responsibility: Receivables Federal Financial

: Transactions > Transactions

Create a Transaction 'X' with these lines:

Line 1 - GL Account A  for $100
Line 2 - GL Account B  for $200
Line 3 - GL Account C  for $300
Line 4 - GL Account C  for $400

Notice line 3 and 4 have the same accounting  bu different amounts.

Navigation: Receipts > Receipts

  1. Create a miscellaneous receipt 'Y 'for $1000
  2. Create an standard receipt 'Z' for $1000 and apply to the invoice 'Y'
  3. Reverse the miscellaneous receipt 'X' and link it to the standard receipt in Reclass Receipt field.

Navigation: Concurrent > Run

  1. Run Create Accounting Program
  2. Run the CTA process for Receipts in final mode

Check FV_CTA_AUDITS table:
There is accounting for line1 and 2 that have the following column values populated:
record_type = Receipt number
process_id = je_batch_id
reclass_flag = Y

But lines for 3 and 4 the amount there is one line for the sum: 700 (300 + 400),  and it is missing values in the three columns above.





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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patch
 4. Solution Steps

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