Document Type I9 not pulling on OTBI reports

Question

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

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/24167/document-type-i9-not-pulling-on-otbi-reports

Can you please confirm the document type and show a screen shot from UI for DOR?

Thanks.

Bhaskar Konar · Answer

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,