Reports
Discussion List
-
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont…Bhavna-Civeo 8 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Values not populating in 'Recruiting - Recruiting real time' subject areaHi Oracle community, When we create an analysis using the 'Recruiting - Recruiting Real Time' subject area, filter the results to show only the Recruiting Type 'Offshore…Alyssa T. 9 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example:Welsey 86 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Custom Budget Report - Hierarchy LevelHi, We're creating a custom budget report to convert the currency values according to the user preference. But when capturing the Hierarchy Level column with a manager t…
-
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every…
-
Question Mark is appearing after each row in etext outputContent Hi, Question Mark is appearing after each row in etext output. How to remove? Thanks in advance. Regards, NivyaNivya Mathire 111 views 4 comments 2 points Most recent by Eyan Shahrin Reporting and Analytics for HCM -
BIP Scheduled report with date appended to filename.Summary: Hi, We want the BIP scheduled output Excel file to include the date in its filename. In the extract process, we can use %d%m%y in the output name to automatical…
-
Does anyone know what table does the Absence Management Type time attribute belong to?Summary: We currently have Payroll Time Type and Absence Management Type configured for the Time Entry Layout Components in our system. We already found that the HWM_TM_…
-
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …Saurabh_Mharolkar 48 views 8 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM
-
List of users using HCM Mobile app reportSummary: We need a list of users who are using HCM Mobile app as a report with BI or OTBI . where this information is stored in SaaS? Content (please ensure you mask any…
-
BIP attachment Query not accepting the parameterSummary: Hi, When I try to use attachment query with dynamic parameter(:P_DID) , i am not getting the UCM outputs. If I hardcode any UCM(DID) from revisions table then I…
-
We Need a table for the Default Values Configure Worksheet Display -Detail TableSummary: Hi We need a table for the below fields under Configure Worksheet Display -Detail Table in workforce compensation plan Content (please ensure you mask any confi…Opkey PA 10 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP Bursting to Email:Output sent as URL:Ability to Change the Position of the URL in the Email BodySummary: BIP Bursting to Email: Output sent as URL: Ability to Change the Position of the URL within the Email Body Content (please ensure you mask any confidential info…
-
Expected Effort values not populatingHi team, We are experiencing an issue where we receive really inconsistent results for the 'Workforce Learning - Learning Records Real Time' Expected Effort value. Some …
-
Is it possible to display contents of CLOB column in OTBI analysis?Content Is it possible to display contents of CLOB column in OTBI analysis? I am adding a CLOB column to an OTBI analysis but it comes up with blank. When I query the sa…User_2025-02-11-06-57-37-559 156 views 7 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…Malak 13 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…JainSamyak 52 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
We Need a table for the Configure Worksheet Display -Detail Table in Workforce compensation planSummary: Hi, We Need a table for the below highlighted fields under the Configure Worksheet Display -Detail Table in Workforce compensation plan Content (please ensure y…
-
Create infolets with the use of FDI reportsHello, We have been implementing the new reporting tool of FDI and we have been asked if it is possible to create Infolets for the FDI reports in the home page of Oracle…Ioannis Adamou 5 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Adding additional column to get headcount for each month in OTBISummary: How to add additional column or calculated item to get the head count for every month? Content (required): I am using 'Workforce Trend Real time Subject Area' a…Raghavendra M 320 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…Swati U 3.4K views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Multiple pdf outputs to be sent to single emailSummary: Hi We are looking for sending multiple pdf's from a report, to a single email using bursting query or to be zipped and sent to a single email Content (please en…
-
USOnline Payslip Report CustomisationHi Team, We are looking for detailed steps for customising the USOnline Payslip report, with the output format in XML. Report output should be delivered to FTP. Please s…Swapnil Kashid 16 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Start Date change on ORC side - Need to know table where Old start date value is storedSummary: When a candidate is in Post Offer stage and the Start date is changed to a new value, in which table does the old value reside? Context - We are trying to build…Patrick Turcotte 95 views 9 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Can we report on the number of job requisitions raised by "use" type (template, position etc)Summary: We are looking to establish the behaviour of users and which way they raise job requisitions in Oracle Recruiting. Is it possible to report on how many requisit…Craig Hennessy 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Select a particular value from concatenated fieldSummary: To obtain a specific value from concatenated field. The business requirement is to obtain information regarding people reporting to C suite (Senior Leadership) …Pranav Waichal 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP Report - Certification File Attachment - Assemble URL for downloading attachment from reportGreetings, During Auditing, our desire is to be able to quickly download any Certification attachments direct from the BI Report results. I'm trying to create SQL for a …Michael_Burgett 3 views 0 comments 0 points Started by Michael_Burgett Reporting and Analytics for HCM -
Reported Time Card Real Time Performance Very SlowSummary: Reported Time Card Real Time Performance Very Slow Content (please ensure you mask any confidential information): Good Day, Is there a way to improve the perfor…JMLMIII 21 views 10 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
Unable to create OTBI AnalysisHi to all, as an administrator user, when I try to create a OTBI Analysis I'm only able to view my own informations. I can't see the information about other users. The s…