Importing Opening Inventory Balances through FBDI results in error code: FND_CMN_INVALID_ATTRB_API_SERV (Doc ID 2616073.1)

Last updated on APRIL 20, 2023

Applies to:

Symptoms

On : 11.13.19.10.0 version, Inventory

Using Inventory Transaction Import to upload On-Hand Inventory Opening Balances through FBDI results in error.

ERROR
-----------------------
FND_CMN_INVALID_ATTRB_API_SERV: The value of the attribute ORGANIZATION_NAME is not valid.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Download Inventory Transactions Import Template from: https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/19d/oefsc/inventory-management.html#inventorytransactionimport-3005

2. Fill in all applicable data for the Opening Balance transaction

3. Run ESS job 'Load Interface File for Import' --->Import Process 'Create Inventory Transactions' ---> Data File (CSV created from template) ---> Submit

4. Run ESS job 'Manage Inventory Transactions'

5. No error is found on either logs, therefore you will need to query the INV_TRANSACTIONS_INTERFACE table to view the error or view the error in the Manage Pending Transactions UI.

SQL QUERY:

select *
from INV_TRANSACTIONS_INTERFACE
where ORGANIZATION_NAME = 'ORGANIZATION NAME ON TEMPLATE'
order by TRANSACTION_DATE desc

Cause

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