Create Mass Additions Does Not Transfer Invoices To Fusion Assets (Doc ID 2526463.1)

Last updated on AUGUST 09, 2024

Applies to:

Symptoms

On : 11.13.19.01.0 version, Manage Invoices-Record Accounting for Invoices

ACTUAL BEHAVIOR
---------------
Customer reports that Payables invoices cannot be transferred to Fixed Assets, despite the fact that the setup is correct.
Example of such an invoice and the corresponding setup (please input the actual values for the parameters beginning as '&......')

1.Checked the AP_INVOICE DISTRIBUTIONS_ALL, the ITEM LINE have distribution with:

-ASSETS_TRACKING_FLAG=Y;
-CCID (Code combination ID of the Account Combination) enabled
-ASSET_CATEGORY_ID populated


2.Checked FA_MASS_ADDITIONS, invoice is not found:

select * from fa_mass_additions where invoice_id='&invoice_id';

--no data available

3.Verified the CCID from the AP_INVOICE_DISTRIBUTIONS_ALL, to be the same as the one from XLA_AE_LINES:
-ACCOUNT_TYPE=A
-ENABLED_FLAG=Y
-CODE_COMBINATION_ID is of type Asset, Enabled and Allows Posting.

4.Checked the FA_BOOK used for Create Mass Addition
select BOOK_CONTROL_ID ,BOOK_TYPE_CODE ,BOOK_TYPE_NAME ,SET_OF_BOOKS_ID ,INITIAL_DATE ,AMORTIZE_FLAG ,FULLY_RESERVED_FLAG ,DEPRN_CALENDAR ,BOOK_CLASS from fa_book_controls;
-->it has the same the name as the one which user provides when runing the "Create Mass Addition" program.


5.Checked that the Asset Book is associated to the same ledger as the ledger on which the AP invoice is created:
FA_BOOKS table

6.Checked the BU on which the invoice is issued is associated to the same ledger as the FA_BOOK
FUN_ALL_BUSINESS_UNITS_V
BU_ID BU_NAME and PRIMARY_LEDGER_ID


7. Checked that in xla_ae_lines, distribution combinations is the same as per AP_INVOICE_DISTRIBUTIONS_ALL table

8.Checked the FA_CATEGORY used on the AP invoice distribution:

select * from FA_CATEGORY_BOOKS where CATEGORY_ID='&category_id' and BOOK_TYPE_CODE='&FA_book_name';

9.Checked the CCID associated as Clearing Account to FA CATEGORY_ID:

select * from gl_code_combinations where code_combination_id in ('&CCID1','&CCID2');


EXPECTED BEHAVIOR
-----------------------
User expects the AP invoice to be transferred to FA after running the "Create Mass Addition" program.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Created Ap Invoice, validated and accounted it.
2.Ran Create Mass Addition for the asset book.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot transfer the AP invoice to FA.

Cause

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