When a new attribute is created on any object it instantly creates a column under the object table.
- Attribute created under Project Object with attribute id = 'Test_Attribute".
- This instantly creates a 'Test_Attribute' column under ODF_CA_PROJECT table.
When you immediately try to verify the same by executing a SELECT query through any SQL Tool (Eg. SQL Developer, Toad, etc) the newly created columns are not listed.
Cannot see newly created attributes through SQL Tools?
CA PPM On Demand
On SaaS Database we have a SYNONYMS Job which is scheduled to run every 2 hours this is when the alias is created. Once this Job completes users can successfully query the newly created attributes through SQL tool.
A synonym is an alias for a schema object. It provides a level of security by masking the name and owner of an object and by providing location transparency for remote objects of a distributed database. And makes it convenient to use and reduce the complexity of SQL statements for users.
NOTE: You can insert data on this newly created attributes through PPM UI immediately.