TAB Rule To Derive Depreciation Account When Prepare Assets Is Not Working (Doc ID 2740953.1)

Last updated on MAY 26, 2023

Applies to:

Symptoms

On : 11.13.20.10.0 version, Additions

When attempting to run the Prepare Additions in Assets, after changing the Asset Category on a New Asset, the below error is shown:


ERROR
-----------------------

FA.PLSQL.FA_MASSADD_PREPARE_PKG.prepare_mass_additions: error has the value of ORA-06502: PL/SQL: numeric or value error: NULL index

STEPS
-----------------------

The issue can be reproduced at will with the following steps:

1. Have new TAB rules to derive the segments Operating Unit, Cost Center and Natural Account. The first 2 have the source as Payables Code Combination Identifier and the last one has a fixed value 680001 (for testing)
2. While the asset is in the New status, you assign the correct Asset Category.
3. Save and then run the Prepare Additions from the Actions menu
4. The process first ended in error successfully but the TAB rule to change the depreciation account is not updating the asset, it keep the old expense account you had in the asset.

FA.PLSQL.FA_MASSADD_PREPARE_PKG.prepare_mass_additions: entering tab logic1 has the value of
FA.PLSQL.FA_MASSADD_PREPARE_PKG.prepare_mass_additions: error has the value of ORA-06502: PL/SQL: numeric or value error: NULL index
FA_MASSADD_PREPARE_PKG.prepare_mass_additions
ORA-06502: PL/SQL: numeric or value error: NULL index table key value

The last time time we run it ended successfully and the logs shows:
FA.PLSQL.FA_MASSADD_PREPARE_PKG.prepare_mass_additions: tab status has the value of FALSE
FA.PLSQL.FA_MASSADD_PREPARE_PKG.prepare_mass_additions: tab errormsg has the value of XLA XLA_TAB_CCID_COULD_NOT_CREATE ERROR The Cost Center
FA.PLSQL.FA_MASSADD_PREPARE_PKG.prepare_mass_additions: tab ccid has the value of
FA.PLSQL.FA_MASSADD_PREPARE_PKG.prepare_mass_additions: tab concat segs has the value of ABDC.4545.9999.PEPEPE.00000.100.0000


in the logs the depreciation account is correctly derived but not updated to the asset.

Cause

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