My Oracle Support Banner

ORA-07122: Invalid Number Error in Prepare Spreadsheet Or When Posting Assets Via Post Mass Additions (Doc ID 2776454.1)

Last updated on MAY 15, 2021

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

When clicking Submit or Post in the Prepare All spreadsheet, the following error is encountered:

ORA-01722: invalid number

 

The issue can also occur with Post Mass Additions.  The process log shows:

FA.PLSQL.fa_utils_pkg.get_currency_code: Currency code has the value of USD
The number of records processed is 1.
The number of records that failed is 1.
FA.PLSQL.fa_asset_numbering_pkg.fetch_next_asset_number: at has the value of
beginning
Asset Numbering completed
The module Post Mass Addition ended with an error.

 

However, the AFLOG shows:

[APPS_PRODUCT: FA] [APPS_SOURCE: FA.PLSQL.fa_massadd_pkg.process_lines]
[APPS_JOB_REQUEST_ID: 851060] [APPS_JOB_DEFINITION_NAME: PostMassAdditions]
[APPS_JOB_PACKAGE_NAME: oracle/apps/ess/financials/assets/additions]
[APPS_JOB_DEFINITION_APPLICATION: FA] The mass addition ID 300000016186605
failed.[[
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-01722: invalid number

 

 

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


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