Setup problem Can't see the catalog content

It is not possible to view the category name, nor create it, and we are also unable to extract this information via query.

When trying to create the Category name within this catalog (LACLS_BR_ITEM_TYPE), it returns an error, stating that it has already been created.

The query below is the one I’m using, and it works in my testing environment.

Any idea what could be causing this?

Note: We uploaded this data via FSM.

SELECT CAT_SET.CATALOG_CODE, CAT.CATEGORY_NAME
FROM EGP_ITEM_CATEGORIES ITEM_CAT
,EGP_ITEM_CAT_ASSIGNMENTS CAT_****
,EGP_CATEGORY_SETS_B CAT_SET