Thought I would update this post:
Problem:
Table does not appear in Tables & Columns.
Table choices not showing up in a record producer when trying to add a select box variable.
Or table does not appear in selector when trying to create an event, notification, or business rule.
Solution:
Check if there is a “collection” record associated with the table.
To add a collection record back onto a table, if you have a copy with a working collection record, which I did.
Go to the dictionary, filter on that specific table so the collection record shows up.
Open the “collection” record for the table (Right click the tablename )
Right click the gray banner and select Export -> XML (This Record)
Do NOT rename the exported .xml file !
There is a string in the file that needs to match the filename.
To load the record on to a table in a different instance…
Go back to the Dictionary and list the table records.
Right click the three lines next to the Table column label and select Import XML.
Do NOT select “Import” !
Once the record is loaded validate and you should be good to go.
