Reports
Discussion List
-
SQL Query for Supervisor/Employee Hierarchy with Both Direct and Indirect ReportsContent I have a task to create a BI Publisher report and attach additional data from different tables based on the bottom level employees. I am wondering if anyone has …Brian Todd-Oracle 1K views 2 comments 0 points Most recent by Suhitha K-Oracle Reporting and Analytics for HCM -
Need to Restrict Employees of a Tax Reporting Unit(TRU) in ExtractSummary: We need to copy a seeded report, Run Third-Party Periodic Tax Filing Extract, and add an object group that will allow us to run the report for specific TRUs (we… -
How to get location for position in OTBISummary: How to get location for position in OTBI Content (required): I tried using location name column under Position folder from position real time subject area but i…Swati U 175 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
we have head count nearly 9000 employees and coming to this report only showing 5700 plus employeesSummary: Hi team, we have head count nearly 9000 employees and coming to this report only showing 5700 plus employees may i know how to check the issue. person real time…AjayKumar Maddipati 52 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
GL Value set DFF's are not available in SmartView/ FRSSummary: GL Value set DFF's are not available in SmartView/ FRS. Please let me know is this standard functionality. My client want to track this. Let me know we have ano…User_2025-02-12-18-40-30-943 91 views 2 comments 0 points Most recent by User_GRG5N Reporting and Analytics for ERP -
Need to capture the details under Mobility in "Skills & Qualifications " pageSummary Need to capture the details under Mobility in "Skills & Qualifications " pageContent Hi Experts, Need a help. Need to retrieve the following data for a person. N…Aloka Bhattacharya 55 views 6 comments 0 points Most recent by Shampi Reporting and Analytics for HCM -
Secured List View - How it works in a BIP ReportSummary: Hello, Is there any documentation or white paper on how secured list view works in a BIP report? Content (required) We used secured list view in our BIP query t…Hazel De Castro 771 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
which subject area we get father/husband names in OTBISummary: Hi Team, we need data employees of father and husband names so could please assitance on. Content (required): Version (include the version you are using, if app…AjayKumar Maddipati 42 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Not able to find column as Pending changes in Position subject areaSummary: Not able to find column as Pending changes in Position subject area Content (required): In manage position, we have "Pending Changes" column. see attached. Does…Swati U 41 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I calculate Absence Sickness for Employees for 4 absences of 3 days or more?Summary: I need to produce a report for employees that have had more than 4 sickness absences of 3 days or more within a rolling 12 month period. I have managed to creat… -
How do I run a report on average age of employees?Summary: I need to run a quick report on the average age of employees in the whole organisation and per Legal Employer. Content (required): I have the report with employ…User_2025-03-10-21-26-28-299 31 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
Future Dated HiresSummary I need a report from the OBI that will give me a list of employees that have been boarded in Fusion, but haven't started yet.Content I've attempted to load the t…User_2025-01-23-22-36-14-742 156 views 11 comments 0 points Most recent by Matty S Reporting and Analytics for HCM
-
Is there a way to extract the Manage Privileges details?Every oracle maintenance we are manually checking the Manage Privileges (OBIEE > Administration > Security) if still intact. Are there any way to extract all the details…
-
Is there onboarding form edited by Acrobat Pro? required timestamp from pdf editor?Summary: HI all, we are trying to get time date and timezone format in onboarding forms in pdf editor. the example of time zone format is 2022.08.03 09:55:19 -04'00' . A…
-
Need to move Profit and loss FRS report from one instance to anotherSummary: Content (required): I have created a FRS report of profit and loss statement and I need to move it to another instance. Any suggestions on how to do this Versio…AeeTee 99 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Huge number of Contracts impact on reporting/performanceHello team, We are evaluating options where there will be around half a million contracts created in the system to perform billing from Projects each year. I need pointe…
-
How to create an OTBI Report to display POs by running for GL Parent/Child Department valuesSummary: How to create an OTBI Report to display POs by running for GL Parent/Child Department values Content (required): How to create an OTBI Report to display POs by …Abhilash K - Deloitte USI 21 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 145 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
Created Eff for Extra internal info in candidate application details section in a requisition,Summary: I have created a eff under person extra info it is BI enabled . Content (required): I have run the ESS Job Import Oracle Fusion data extension for transaction B…Rajib_Samanta 201 views 4 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
Project CostingSummary: Project Costing Content (required): We have added our subsidiaries business unit to Project Costing, however, when Create Accounting for Labor Cost is generated…
-
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
OAC vs OTBI best for reporting ?Summary Soliciting comments and feedback as to when OTBI is best for reporting vs. Oracle Analytics CloudContent Hello Forum: I'm looking for feedback when OTBI might be… -
Enter values for lexical referencesSummary: Content (required): Hello everybody, We are having issues using this query to extract information from the learning module. I suppose that the error is given by…Gerardo Peluso 31 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM
-
Unable to Join Multiple Subject AreasSummary: Unable to join "Workforce Management - Absence Real Time" Subject Area with "Workforce Management - Worker Assignment Real Time" Content (required): Our require…Jyothi Gorantla 31 views 4 comments 0 points Most recent by Jyothi Gorantla Reporting and Analytics for HCM
-
'Performance Document Rating Distribution' report not runningSummary: Hi Peers, I'm trying to make use of the seeded report 'Performance Document Rating Distribution'. It is not running whereas other seeded reports (e.g. 'Performa…S Shree 51 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Comparing data between ERP and Planning in a ReportSummary: Hi All, Since you can reference cells in another grid I thought it was possible to use 2 different data sources with different structures like Planning and ERP,…
-
Display sum of questionnaire response scores in banded groupsContent Hello. I'm trying to accomplish the following from a scored survey in a checklist task that we ask our new hires to respond to. Each response within each of the …User_2025-02-05-22-55-58-511 17 views 4 comments 1 point Most recent by Hazel De Castro Reporting and Analytics for HCM