Change of environments lead to fields not working

Question

Hello,

I have designed a report on an environment and everything was working completely fine.

When this report was moved to production, some of the fields appear completely empty (in my case referral first and last name for example), this being not the originally behaviour. I have all the roles and permissions needed to see the information.

I attach the .xml code that gives form to the report.

Any suggestion or approach to solve this issue will be welcomed.

Kind regards and thank you in advance.

051124_CommunityPost.txt

Nathan CCC · Answer

Hi Jaime,

Looks like you built an analysis in OTBI not a report in OTBI.

To debug, get the logical SQL from the advanced tab of this analysis, in both envs issue the SQL /analytics/saw.dll?issuerawsql, get the physical SQL from the logs, use your favourite text compare tool to review differences.

Run the physical sql in an ad-hoc data model with the where clauses / joins commented out to check the same data exists in both env in your tables and views?

Was your dev env a clone of production from some point in time? Why do you expect the same results?

Perhaps your users has different security setup in each env? Did the system append different where clauses at runtime to your query? Or perhaps you have different data in each env? Does the data exist in the tables.

You query looks like multiple subject areas

"Workforce Management - Worker Assignment Real Time"

https://docs.oracle.com/en/cloud/saas/human-resources/24d/faohb/Workforce-Management--Worker-Assignment-Real-Time-SA-3.html

"Recruiting - Recruiting Real Time"

https://docs.oracle.com/en/cloud/saas/human-resources/24d/faohb/Recruiting--Recruiting-Real-Time-SA-77.html

I notice you have some additional information fields configure like "Recruiter Name".

And for some reason you are using presentation variables in the where clause p_candi_name

Also what happens if you query only each of the subject areas one at a time on their own? What about if you remove the DFF? What of you replace presentation variables with hard coded values? What is the simplest SQL you can get to with the least number of columns that has the issue?

MandeepGupta · Answer

Hi @Jaime Castillo ,

If I understand correctly, you can see the data in application UI for these two mentioned fields but not in the report? Can you ask any one of your colleagues also to verify if the behavior is same or it is only with your user?

The fields should be populated in analysis if you are able to see them in UI.

Thanks.