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:

Symptoms

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

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

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

Changes

Cause

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