Objectel Metadata Editor is generating wrong table name in Cache script after adding new type
Last updated on JULY 03, 2017
Applies to:Oracle Communications Objectel - Version 2.10.2 and later
Information in this document applies to any platform.
Customer created a Equipment on table OBJ_FE. Now Customer is extending by using new table named Data_Power to store some of new attributes which are not present in OBJ_FE Table. In the metadata Customer have DB mapped accordingly to Table Data_Power.When creating the CacheWOTS script, the following hierarchy insert statement is created:
As you can see, the insert for the special equipment select elements from Data_power and not from OBJ_FE.
Customer is expecting, as OBJ_FE is base table always values need to select from OBJ_FE to Insert into Hierarchy Table.
But in the MetaData Editor If you generate the cache script It will take the Top DB Map Element table name i.e Data_Power, Not OBJ_FE.
So Customer don't have a option to select the table name(Base table or extended table) for cache script.
Customer is extending by using new table named Data_Power to store some of new attributes which are not present in OBJ_FE Table.
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 hundreds of Community platforms