Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Document Type I9 not pulling on OTBI reports
Document Type I9 not pulling on OTBI reports while creating reports from subject area Document of Record Real Time even though we can see it on UI
query we are using
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Workforce Management - Documents of Record Real Time"."Document Type"."Document Category" s_1,
"Workforce Management - Documents of Record Real Time"."Document Type"."Document Name Applicable Code" s_2,
"Workforce Management - Documents of Record Real Time"."Document Type"."Document Type" s_3,
"Workforce Management - Documents of Record Real Time"."Worker"."Person Number" s_4
FROM "Workforce Management - Documents of Record Real Time"
WHERE
(("Worker"."Person Number" = '31492') AND ("Worker"."Person Number" = '31492'))
ORDER BY 4 ASC NULLS LAST, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 5 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY
Answers
-
Hi @Shweta Vohra,
Can you please create an OTBI Report with following columns to see 'Document Type I9' belongs to which category & sub-category?
Once you know that please try to see if you can see those category or sub-category for others. If no then there might be some special security has been implemented and you might need that role to see that data in the report.
Hope this help.
Cheers,
0 -
Can you please confirm the document type and show a screen shot from UI for DOR?
Thanks.
0
