INVISCOR (Copy Inventory Organization) Failed With Error INV_SETUP_NO_DATA_FOUND (Doc ID 2465899.1)

Last updated on APRIL 18, 2023

Applies to:

Symptoms

Copy Inventory Organization failed with Error

Tue Sep 06 13:47:52 PDT 2016[ERROR]Copy of InventoryParameters failed.
Tue Sep 06 13:47:53 PDT 2016[BELOG Contents]An exception occurred in API 'ParametersAM'.
JBO-25050: Batch mode post operation failed. See Exception details for a list of failures.

Tue Sep 06 13:47:53 PDT 2016[STACKTRACE]oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: oracle.apps.fnd.framework.OAException: Application: INV, Message Name: INV_SETUP_NO_DATA_FOUND. Tokens: ATTR_VALUE = OrganizationCode = [ORGANIZATION CODE]; ;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.inv.setup.utilities.MGKeyManager.getAlias(MGKeyManager.java:238)
at oracle.apps.inv.setup.utilities.MGKeyManager.getAliasShort(MGKeyManager.java:178)
at oracle.apps.inv.setup.cp.CopyLoader.copyInventoryParameters(CopyLoader.java:2649)
at oracle.apps.inv.setup.cp.CopyLoader.copyEntities(CopyLoader.java:2009)
at oracle.apps.inv.setup.cp.CopyLoader.executeRestart(CopyLoader.java:540)
at oracle.apps.inv.setup.cp.CopyLoader.startCopy(CopyLoader.java:594)
at oracle.apps.inv.setup.cp.CopyLoader.runProgram(CopyLoader.java:1798)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)
## Detail 0 ##
oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: oracle.apps.fnd.framework.OAException: Application: INV, Message Name: INV_SETUP_NO_DATA_FOUND. Tokens: ATTR_VALUE = OrganizationCode = [ORGANIZATION CODE];
at oracle.apps.jtf.cache.IASCacheProvider.get(IASCacheProvider.java:833)
at oracle.apps.jtf.cache.CacheManager.getInternal(CacheManager.java:4802)
at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:4627)
at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:3147)
at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:3121)
at oracle.apps.inv.setup.utilities.MGKeyManager.getAlias(MGKeyManager.java:226)
at oracle.apps.inv.setup.utilities.MGKeyManager.getAliasShort(MGKeyManager.java:179)
at oracle.apps.inv.setup.cp.CopyLoader.copyInventoryParameters(CopyLoader.java:2649)
at oracle.apps.inv.setup.cp.CopyLoader.copyEntities(CopyLoader.java:2009)
at oracle.apps.inv.setup.cp.CopyLoader.executeRestart(CopyLoader.java:540)
at oracle.apps.inv.setup.cp.CopyLoader.startCopy(CopyLoader.java:594)
at oracle.apps.inv.setup.cp.CopyLoader.runProgram(CopyLoader.java:1798)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)
Caused by: oracle.apps.jtf.base.resources.FrameworkException:
J2EE JOC-044 An exception is occurring in the method. CacheAccess.get
null
J2EE JOC-043 base exception:
Application: INV, Message Name: INV_SETUP_NO_DATA_FOUND. Tokens: ATTR_VALUE = OrganizationCode = [ORGANIZATION CODE]';
at oracle.apps.jtf.base.resources.FrameworkException.convertException(Unknown Source)

Changes

The following action plan found problematic data:

1) For debug mode and SQL trace:
Enable FND logging by setting the following profiles at user level
FND: Debug Log Enabled - Yes
FND: Debug Log Level - Statement
FND: Debug Log Module - %
INV: Debug Trace: Yes
INV: Debug Level: 10
INV: Debug file: /usr/tmp/invdebug.log (Please note this directory should
get from v$parameter list)

If you are tracking the debug messages for a concurrent request, take note of
the Concurrent Request id

Launch the Copy Inventory Organization as below:
Go to Inventory : Setup : Organizations : Organization Copy : Launch
Organization Copy
Select your Model Organization
Enter the other parameters
Click Debug Options
In Create Debug Rule : Debug Option page:
Check "SQL Trace" and select "SQL Trace with binds"
Click OK to confirm
Click Yes to close the page
You are back in ORGANIZATION COPY window
Click Submit

Provide the INV debug log and FND log messages for a concurrent request ID

SELECT log.module, log.message_text message
FROM fnd_log_messages log,
fnd_log_transaction_context con
WHERE con.transaction_id = &request_id
AND con.transaction_type = 'REQUEST'
AND con.transaction_context_id = log.transaction_context_id
ORDER BY log.log_sequence;

Also, provide DB trace for further review. Please note that INV and FND log
and DB trace is mandatory to narrow down this issue. With out these details
it is very difficult to analyze the issue.

Cause

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