On the same matter.
Has anyone tried to analyze orphan records on table cmn_caption_nls ?
On a version 15.5.0.225, I count nearly 25% of the captions which are useless : pk_id does not exist anymore on target table.
Specific Tables names :
- BPM_DEF_STEP_CONDITION_NOTES : Shouldn't exist ? Feature to add notes on Process Step Conditions ?
- ODF_CLASS : Shouldn't exist anymore (since 13.2 or 13.3, don't remember).
- CMN_BROWSE_SINGLE_SELECT : Source table is cmn_lov_objects (Lookup pop-up select unitary)
- CMN_BROWSE_MULTI_SELECT : Source table is cmn_lov_objects (Lookup pop-up select multi)
- ODF_VIEW_ATTRIBUTES_DESC, %_INSTR, %_TIP : Source table is odf_view_attributes (View attribute properties)
The other table names exist on schema.
Find attached the query that I'm using, for any contribution.
I will test to delete them and see if there is any side effect.
--Update--
Side effect on CMN_PARTITIONS, System Partition NIKU.ROOT is not recorded in table cmn_partitions. ID -1 is hard-coded in SQL queries There is also CMN_PORTLETS with pk_id -1 whose description is "Resource Capacity Demand by Role - view the capacity and demand by role of resources, and analyze impact on capacity and demand if fte's or hours were increased or decreased." But so far, no side effect if I delete it.
--End Update--
Regards,
David