Skip to main content

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.
 

Custom Projection

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

Hi,

After further investigation, it was found that creating the custom projection alone is sufficient — there's no need to assign it to any permission set. The corresponding entry in the FND_PROJ_ENTITY_GRANT_TAB is only removed when the projection itself is deleted.

This clears up my doubt regarding the permissions.

Best Regards,
Nisansala

Reply


Terms & ConditionsCookie settings