My Oracle Support Banner

User Data Category Created as Category Type of Table Problems: Custom Table Not Listed. Available Tables Not Sorted. (Doc ID 3059029.1)

Last updated on NOVEMBER 13, 2024

Applies to:

Oracle Communications MetaSolv Solution - Version 6.3.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a new User Data Category using a Category Type of Table using a custom table created in the ASAP schema, the custom table name does not appear in the Table drop-down list of the User Data Category window (w_category_maint) nor are the ones available sorted in any type of order. Creating a custom table in the JOB schema does appear in the Table drop-down list.



Recreation Steps

1. Create table to be used for the new User Data Category (sample DDL below).

 

 

Changes

Installed or upgraded to MetaSolv Solution version 6.3.1.333 - Patch 32834810: MSS_6_3_1_B333(6.3.1.4.0) and running with Oracle Database 19c.

 

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.