My Oracle Support Banner

AXXPSMAN AX Inventory Generic Translation Errors ORA-01403 (Doc ID 445087.1)

Last updated on JULY 02, 2021

Applies to:

Oracle Global Accounting Engine - Version 11.5.1 to 11.5.10.2 [Release 11.5.0 to 11.5.10]
Information in this document applies to any platform.
This problem can occur on any platform.
EXECUTABLE:AXXPSMAN - Posting Manager
EXECUTABLE:AXXPSETR - Event Translation Report

Symptoms

AX Posting Manager (AXXPSMAN) for AX Inventory fails with error ORA-01403 when accessing the following views:
AX_MTL_CATEGORY_ACCOUNTS_V1, AX_MTL_CATEGORY_ACCOUNTS_V2, AX_MTL_SECONDARY_INV_V1, AX_MTL_SECONDARY_INV_V2

The problem occurs for events related to Inventory material transactions.

One of the following errors is raised in the Event Translation Report (AXXPSETR).

ERROR #1
-----------------------------
"Program error occurred while retrieving information from the base
query table.
Please contact your system administrator.
Additional information :
Table name : AX_MTL_CATEGORY_ACCOUNTS_V1
Table alias : CAXMTCAACV1
Where clause : ORGANIZATION_ID = XXX
AND INVENTORY_ITEM_ID = YYYY
AND SUBINVENTORY_CODE = ZZZZZ
OR ORGANIZATION_ID = XXX
AND INVENTORY_ITEM_ID = YYYY
AND COST_GROUP_ID = ZZZZZ
Send_message returned ORA-01403: no data found"

ERROR #2
-----------------------------
"Program error occurred while retrieving information from the base
query table.
Please contact your system administrator.
Additional information :
Table name : AX_MTL_CATEGORY_ACCOUNTS_V2
Table alias : CAXMTCAACV2
Where clause : ORGANIZATION_ID = XXX
AND INVENTORY_ITEM_ID = YYYY
AND SUBINVENTORY_CODE = ZZZZZ
OR ORGANIZATION_ID = XXX
AND INVENTORY_ITEM_ID = YYYY
AND COST_GROUP_ID = ZZZZZ
Send_message returned ORA-01403: no data found"

ERROR #3
-----------------------------
"Program error occurred while retrieving information from the base query table.
Please contact your system administrator.
Additional information :
Table name : AX_MTL_SECONDARY_INV_V1
Table alias : CAXMTSEINV1
Where clause : ORGANIZATION_ID = XXX
AND SECONDARY_INVENTORY_NAME = ZZZZZ
OR ORGANIZATION_ID = XXX
AND COST_GROUP_ID = ZZZZZ
Send_message returned ORA-01403: no data found"

ERROR #4
-----------------------------
"Program error occurred while retrieving information from the base query table.
Please contact your system administrator.
Additional information :
Table name : AX_MTL_SECONDARY_INV_V2
Table alias : CAXMTSEINV2
Where clause : ORGANIZATION_ID = XXX
AND SECONDARY_INVENTORY_NAME = ZZZZZ
OR ORGANIZATION_ID = XXX
AND COST_GROUP_ID = ZZZZZ
Send_message returned ORA-01403: no data found"

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
 Solution #1 - Complete the setup for accounting categories
 
Solution #2 - Run procedure AX_INVENTORY_PKG.INITIALIZE
References

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