OBIEE Reports not displaying data after a rollback in Source system

User_A0WPE

Hi Team,

The HR data is not displaying data in the OBIEE reports and later found a change to PS_JOB and then a roll back of the change has messed the data. but nit sure where to find the mess in warehouse.

Source team added a new table to store employees’ STIP value (NSP_EMP_INC_PLN.NSP_STIP) and copied employees’ STIP data from Job Data (JOB.GL_PAY_TYPE) into the new table.

There was also a cleanup script that inserted a new Data Change / Info. Only row to Job Data for any employee whose current Job Data row had a non-blank GL Pay Type value. These new rows caused issues in PeopleSoft because the script didn’t insert rows for all of Job Data’s child tables, so a rollback was done to delete all the rows that had been inserted into the JOB and JOB_JR tables as part of the cleanup script."

The backend query was checked for all BI tables and the delete flag = 'Y 'is restricting the data is the assumption.

How can this be fixed ? please suggest as it is Production issue.

Can you please advise what might be the issue?

Versions of technologies involved:

1. OBIEE Version: 12.2.1.3.0

2. BI Apps version/Patches: OBIA 11.1.10.1 no patch installed

3. BI Apps modules being used (Finance,HR etc.): EBS 12.2 - Finance, SCM and Procurement. PSFT 9.2 - HR

4. Database versions/Patches: Oracle Database 12.1.0.2

5. Database Warehouse: Oracle DB 12.1.0.2

6. ODI Version/Patches: 11.1.1.9.0

7. Source System/version: EBS 12.2 PSFT 9.2

Thanks