Category 81
Discussion List
-
How to freeze dashboard filter prompt in OTBIHi Experts, We have a requirement to freeze dashboard prompt in OTBI report like we did in Excel header if we are scrolling the dashboard we are unable to see the prompt…Anilkumar12 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Add Learning Incident Comment into ReportSummary: I had created a Learning Incident report so that we can see who had reported the incident. Learning Admins receive notifications when incidents are reported but…
-
hwm_timecard_report.timecard_totals - Specification (Oracle Fusion)An Oracle Fusion seeded report for displaying bulk timecard approvals is executing the TimecardApprovalNotificationBulkReport which displays a PDF on screen. The data mo…
-
Sample report (preferably OTBI) of candidates that have applied using multiple emailsSummary: Does anyone have a report (preferably OTBI) of candidates that have applied using that one email. In essence, same candidate name and address applying with mult… -
Looking for Employee Salary and STIP report either OTBI or BIP report sql.Summary: I am looking for a report that would capture every salary and STIP eligibility percentage an employee had during the course of a year. For some employees, that …
-
Unable to enable the ORA_OARS_VB_NAVIGATION_ENABLED profile option.Summary: We had previously raised an SR with Oracle regarding a REST action error on the My Team Activity Center (Redwood) page. The solution provided was to set the ORA…Hamsa Lekha E B-Oracle 14 views 2 comments 0 points Most recent by Hamsa Lekha E B-Oracle Reporting and Analytics for HCM
-
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…
-
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 14 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 352 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there any way to get back the archived transactions related workflow transactionsSummary: I want to get the information on archived transactions details. Content (please ensure you mask any confidential information): Recently we have click on archive…VishnuVardhan Raju 7 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Table for proposed Projected end dateSummary: Hi All, We have a requirement to create a report in which we want to capture Current Projected End Date and Proposed Projected End Date. We are unable to find i…VishalDhane_HCM 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
Report on Messages sent to Candidates using a message templateSummary: Content (required): I'm looking to report on Email messages sent to candidates who've submitted a job application. Any thoughts on which subject area/dimension …Susan Anderson 74 views 5 comments 2 points Most recent by User_JI4P7 Reporting and Analytics for HCM -
Incorrect values are appearing in OTBI report for leave durationSummary: We have created OTBI report where we are fetching absence details based on year and month (monthly absence report). If employee has taken leave for single month…Vaishnavi Joshi 17 views 0 comments 0 points Started by Vaishnavi Joshi Reporting and Analytics for HCM
-
Unable to send bcc in bursting.In the bursting query i have added parameter 8 for BCC mails. However, 'to' mails are going and the employees are receiving the mails. BCC is not being received. Can any…Reshma Eldho 14 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
where to add parameter effective date conditions to OTBIHi All, Requirement: Added Effective date as a parameter in prompt and report should fetch all active employees as of that date which is given in the effective date para… -
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.7K 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 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Date between effective start date and effective end dateI am trying to create an otbi report on element entries historical subject area. I have to create a date filter condition in such a way so that it will ask a date from t…Neelotpal01 28 views 1 comment 0 points Most recent by Bhaskar Konar 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 100 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 26 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
How can Canadian French characters be displayed correctly when using ANSI encoding?We have a requirement to send a demographic file to a Canadian RRSP vendor using ANSI encoding that supports ASCII characters. However, when we use encodings such as ASC…
-
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 -
Job requisition report not pulling all job requisitionsSummary: I created a job requisition report to show all open requisitions in a month. I need it to show any that are currently open plus those that were open and filled …Emily Wilde 224 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Bip publisher output doesn't clear cache as old message isnt clearedSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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 1 view 0 comments 0 points Started by Michael_Burgett Reporting and Analytics for HCM -
How to identify edited DOR in BI reportsHow to identify edited DOR in BI reports?Nivya Mathire 23 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
OTBI Report with future hires and terminationsHello, We are attempting to build a report to help our partners keep track of I-9 completions. We are using the subject areas Worker Assignment Event Real Time and Work …joshvanlaan 279 views 9 comments 0 points Most recent by Subbu Santra Reporting and Analytics for HCM
-
How can I find the system source ID/owner for payroll timecard from BI Report querySummary: We're attempting to update some timecard overtime rate entries using the HCM Data Load using USER KEY method, but system seems to still require SOURCE SYSTEM ID…