My Oracle Support Banner

Invalid Input Values For Package Cse_asset_client_stub_ext Package Procedure Get_asset_category (Doc ID 1401467.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Asset Tracking - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Support Codes

After transferring an item r in Inventory which is associated with an asset, the program 'Interface Move Transactions to Oracle Assets' is run which transfers the asset in FA. This program calls package CSE_ASSET_CLIENT_EXT_STUB. The input values for procedure GET_ASSET_CATEGORY in the package are all invalid. This is causing a problem because the values are invalid, the procedure always ends with a 'No Data Found'' error.
the following error occurs.

ERROR
-----------------------
Error in xxfb_fa_oat.get_asset_category: ORA-01403: no data found

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Transfer an item associated with an asset in Inventory using inter-Organization transfer.
2. Run 'Interface Move Transactions to Oracle Assets'

Changes

 

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
Changes
Cause
Solution
References


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