Sample Reports
Discussion List
-
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 443 views 10 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM -
Which table stores the "Assign as" information for initiativeSummary: Hello All, I am trying to build a report to fetch learning initiative details but i am not finding any information regarding the assign as column in the UI.Plea…minati_behera-Oracle 51 views 3 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
Need function condition to exclude any character other than numbers and alphabets for address in BISummary: Need function condition to exclude any character other than numbers and alphabets for address in BI Content (required): Address should not have any characters o…
-
Audit report For Tax Withholding Calculation cards and table for Association, Federal & RegionalSummary: Need to develop a report that captures any changes made to the employee’s Tax Withholding cards such as Association,Federal, Regional. This report will be run u…User_2025-02-12-00-53-03-661 192 views 2 comments 0 points Most recent by Monika_Dubey Reporting and Analytics for HCM -
Table which stores User password expiration dateSummary: Table which stores User password expiration date Content (required): Hi All, Which table stores the user password expiration date? The user wants to create a re…
-
i have this two rows in the result column from union of two subject area i need to divide those rowsSummary: i need to divide the result from subject area 1 (defect as in the screenshot ) above the result of subject area two (total as in screenshot ) Content (required)…Ab_AM 31 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Reporting & Analytics for Fusion Service
-
Function to replace accent characters with respective characterSummary: Function to replace accent characters with respective character ex: O'Brian to O Brian, Noël to be Noel I need something like ascii using which it will directly…
-
Link to the offer in the personalized notificationSummary: Content (required): Good morning everyone, we are developing a package of custom notifications on rtf templates and excel attachments to be provided to a custom…
-
As an HR how do we administer and check the transcript/course for a particular employee.Summary: As an HR how we want to administer and review the transcript/course for the questions to see whether the employee is answering correctly or not, and also need t… -
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
I am working on one of the change only extract but I am not getting OLD values for few recordsSummary: I am working on one of the change only extract but I am not getting OLD values for few records Content (required): I am working on one of the change only with p…
-
Can we have any job process to run HDL(.dat) file which output of BI reportSummary: Can we have any job process to run HDL(.dat) file which is output of BI report Content (required): Can we have any job process to run HDL(.dat) file which is ou…
-
Report to Audit Approval Rules ChangesSummary: Just trimmed back access to Transaction Console, but would like to see who made the most recent Approval Rules changes to workflows, and when the changes were m…Jessica D 542 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Exception: The job attached to employee must have an EEO job category.Summary: Hi All, I am getting this in the EEO1 exception report . Any idea why its throwing this error? I have made sure that all the jobs that are used have the EEO cat…Gaurav Rath- PGC 51 views 3 comments 0 points Most recent by Shashank Priyadarshi - Oracle-Oracle Reporting and Analytics for HCM -
How to set up automatic assignments based on time frame in OBTISummary: We have learning that needs to be completed every 6months, 12months(1yr) and 24 months(2yrs). Is there a way to either: Set up a OBTI to let us know when someon…
-
Criteria for OBTI for Course TestsSummary URGENT! we need to report on a breakdown of pass/fail and how many attempts it took to pass a test. Possibly even a break down of answers for the test. Does anyo…
-
How can I show the number of rows returned from the report?I created a dashboard from the analysis report and there are parameters for this report. How can I show how many data is returned in the report depending on the paramete…Barış Ergün 81 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Grants standard reports don't show up in FRCSummary: I am able to see the Awards reports in Reports and Analytics but not in Financial Reporting Center Content (required): Grants Management sample reports that can… -
Need a query to get negotiation approver list in oracle fusionSummary: Content (required): Hello everyone, I need a query to get negotiation approver list in oracle fusion.Please advise! BR, Sushan Peiris Version (include the versi…Sushan Peiris 302 views 1 comment 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
How to SUM 1st, 2nd, 3rd and 4th occurrence of values in trailer summary record for ETEXT template?Summary: I have a requirement to build a trailer record that includes 4 separate SUM totals based on the occurrence of these totals in the employees record. I can't chan…
-
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 292 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP
-
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…Sushan Peiris 151 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Period Rolling Turnover by Employment CategorySummary: I am trying to get a rolling turnover by employment category. This analysis doesn't change any value even if I provide the assignment category filter. The resul…Anita 31 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
We develop new custom report but we getting some of employes have two recordsSummary: Hi Team, We develop new custom report but we getting some of employes have two records due to terminattion date actuallyin ui no termination date but some have …AjayKumar Maddipati 31 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
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 172 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 51 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Custom notification with HTMLSummary: Content (required): Hello everybody, we are customizing a custom notification containing an attachment inside it. In particular, we have inserted and created ev…
-
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 to add an image in customize on email custom with datamodelSummary: Content (required): Hello, We are creating custom notifications for the learning module for a client. In particular, we have created both reports, bursting and …