Hi,
When values in the Characteristics tab of the Inventory Part page are changed, records are saved in the history tables for InvPartIndiscreteChar LU, which is based on InventoryPartChar.
A quick report has been created to show this history using the history_log_attribute view. Although data exists in history_log_attribute_tab, it wasn’t visible due to a security check on the InvPartIndiscreteChar LU:
This is the query behind above check.
The reason for the security check failure is that FND_PROJ_ENTITY_GRANT_TAB had no entry for the InvPartIndiscreteChar entity. Normally, this table is updated when permission is granted to a projection using that entity. But in this case, no projection directly referenced it.
To resolve this, we created a custom projection, granted permissions to it, and the report worked.
Interestingly, even after removing those permissions, the report still works — the entry in the table remains.
Questions:
-
Is there any other recommended way of handling such permission issues?
-
Is it expected behavior for the table entry to remain even after removing the permission?
Best Regards,
Nisansala
