Mass Addition FBDI Load Fail In Error When Supplier Name Is Populated (Doc ID 2266362.1)

Last updated on AUGUST 07, 2017

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Set Up Asset Lifecycle Management-Define Fixed Assets

When loading lines in FA mass addition using FBDI file, process fail in error 'Rejected - Error on table FA_MASS_ADDITIONS, column INVOICE_PAYMENT_NUMBER. ORA-01722: invalid number' if 'supplier name' field is populated. When the field is not populated the process end well.

ERROR
-----------------------
ORA-01722


STEPS
-----------------------
Steps to reproduce :
1 Download FAMassAdditionTemplate for R12 on Oracle Repository,
2 Populate tabs 'FA_MASS_ADDITIONS' and 'FA_MASSADD_DISTRIBUTIONS', use macro in first tab to generate zip file (including 2 csv files)
3 Launch process 'Load interface file for import' in parameters : Post Mass Additions and zip name
Find attached file loaded and log file of the process

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms