The integration responsible for importing Resources into Clarity PPM, was using the application's XOG functionality to import records into the application. On further troubleshooting it was noticed that the XOG Writes that were being done were failing with the following error message:
<Description>This record has not been inserted</Description>
<![CDATA[SQL Exception with error code : 1422]]>
Looking into the app-ca.log, the following errors were noticed:
SQL error code: 1422
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422:exact fetch returns more than requested number of rows
ORA-06512: at "NIKU.ODF_AUD_5002724_FCT", line 5
ORA-06512: at "NIKU.T_RESOURCE_OODF_CA_RESOURCE", line 227
ORA-04088: error during execution of trigger 'NIKU.T_RESOURCE_OODF_CA_RESOURCE'
It was discovered that there were dynamic lookup based attributes in the Resource object that were being audited, that were causing duplicates in their corresponding audit functions.
As a result of the XOG Write's failure to properly import Resource records into the system, these records were not available in the Resource List View.