My Oracle Support Banner

AXXPSMAN - Events Not Translated Due To Error ORA-1403 In MTL_ITEM_CATEGORIES (Doc ID 100984.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Global Accounting Engine - Version 10.7 and later
Information in this document applies to any platform.

Symptoms

In release 10.7. in the AX Event Translation Report indicates:


Events generated a recoverable failure

Event ID Event Type       Transaction                       
-------- ------------     -----------               
XXX INV_EVENT_27       XXX                     
An error occured when fetching the base query from MTL_ITEM_CATEGORIES  
(CMTITCA):                                                              
ORA-01403: no data found                                                
ORGANIZATION_ID = 162                                                   
AND INVENTORY_ITEM_ID = 5915                                            
AND CATEGORY_SET_ID = 23

 

Steps to reproduce:

Responsibility: AX-Inventory (Global Accounting Engine)
Navigation: Transactions > Posting Manager

The AX event translation Report indicates:
Events generated a recoverable failure

Event ID Event Type       Transaction                       
-------- ------------     -----------               
XXX INV_EVENT_27       XXX                     
An error occured when fetching the base query from MTL_ITEM_CATEGORIES  
(Example):                                                              
ORA-01403: no data found                                                
ORGANIZATION_ID = 162                                                   
AND INVENTORY_ITEM_ID = 5915                                            
AND CATEGORY_SET_ID = 23          

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!


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