Identify the SALARY Amount chanages based on AUDIT_CHANGE_BIT_MAP_ value in CMP_SALARY_ table
Summary:
Hi Team,
We have a requirment to create a repoert with only whenever user salary amount changes we need to include those rows in Report using CMP_SALARY_ Audit table data. We can not able to use Salary amount column value because some of the salary rows are not present in CMP Audit report(When we upload to spreadsheet loader thos rows are not present in Salary Audit table)
1. Could you suggest how can we identify only Salary Amount changes related rows.
2. How can we read AUDIT_CHANGE_BIT_MAP_ value in Audit table to identify the Salary change rows.
0