Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Oracle BIP Report -> RTF Template page bordersSummary page bordersContent Hello, I am having an issue with achieving page borders in RTF templates. Attached a word document explaining my problem. Can anyone please a… -
Add Custom Text to Workflow NotificationSummary: I would like to be able to add custom text to the workflow notifications that would show up conditionally - only when the approve/reject links are shown on the … -
Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher ReportsSummary: Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher Reports Content (please ensure you mask any confidential information):…
-
Which table holds the value for 'Province of Employment' for Canada Employees ?Summary: Need the Table and column info for the 'Province of Employment' value to troubleshoot and fix card association issue. Content (please ensure you mask any confid…
-
I need help with creating New Hires report with some Requsition & Assignment & Offer detailsHello, Could you please let me know what Subject Area/Tables I should use to build a report that shows basically the info on the offer screen under: My Client Groups > H…
-
getting duplicate seniority dates in OTBI report FusionSummary: Oracle Fusion OTBI report is there giving duplicate records for one of the employee. It showing two seniority date records out of it we need earliest seniority …
-
How does a matrix manager see the indirect reports for the person set up as matrixed to themSummary: I have set an employee up as having a matrix manager. I would expect the matrix manager to see this employee along with his/her direct/indirect reports in a hie…
-
OTBI Report with manager details and Counts of Direct and Indirect ReporteesSummary: OTBI Report with manager details and Counts of Direct and Indirect Reportees Content (please ensure you mask any confidential information): We are able to get c…
-
OTBI Report - Direct and Indirect ReportsSummary: Does anyone know how to fetch direct and indirect reports of manager using OTBI? Content (required): Hello, Does anyone know how to fetch direct and indirect re…
-
Could someone please inform me about the table where I can find information on deleted user roles?Summary: Could someone please inform me about the table where I can find information on deleted user roles? In the per_user_roles table, records are permanently removed …
-
Number of Direct Reports that are ManagersSummary Need to generate a report that shows, for a manager, which one of their direct reports is also a manager.Content * There is a requirement to get, for a manager, …
-
Line Manager Dashboard Direct/Indirect ReportingSummary: Is there a way to filter the line manager dashboard analysis by direct/indirect reports? Let's say a Manager has 10 direct reports and 30 indirect reports, is t…
-
How to query the Effective Start and End dates of job on job profileSummary: How to query the Effective Start Date and Effective End Date of Job Name/Code added to a Job Profile in OTBI. Content (please ensure you mask any confidential i… -
Ability to report on auto provisioning rules?Summary: Is there a way to report on all the auto provision rules we have set up within the Manage HCM Role Provisioning Rules task? Or some way to report on all securit… -
Report Path for Audit Reports PageSummary: Could someone please share the report path for the page below? I intend to generate a BIP report to monitor user role deletions and additions. Content (please e…
-
Query to extract the list of available Locations based on the Legal EntitySummary: Content (required): Hello experts, is it possible to build a SQL query to retrieve the list of applicable locations based on the legal entity? Thanks in advance… -
How to Organize the BI Publisher reports and create Library and definitions inside HCM?We implemented Oracle HCM back in 2019, and since then we created a lot of BI Publisher reports across the modules. Those reports are very useful, however, the report na… -
prescreening report orcSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Automating HDL Worker loading via BIP ReportWhat is the process to Automating HDL Worker loading via BIP Report -
need a payroll element costing reportSummary: Need to write a payroll element costing report that includes highlighted information from picture below Content (required): need a report that shows all the inf…
-
AbcdAbcd -
How to convert bip report out format into JSON format by using e-Text templateDear Experts, I need to convert Bip report out format into JSON format by using e-Text template. Please send me the e-Text template and how to use that template with XML…
-
Etext Report output is not coming correctly.Summary: Hi Everyone. I am trying to create a etext report in the HDL format, EDI(delimited type). When i view the report, instead of getting the output value, i am gett…
-
In which table I can find this column "Department" ?I'm creating a report with BI Publisher and I need the department column but I've searched several tables and can't find it. I've found the business units and legal empl… -
Condtional formating not working for standard fieldsSummary: Adding a conditional formating criteria does not work on standard fields but works fine for flex fields Content (please ensure you mask any confidential informa… -
Where can you find the meaning for the ASSIGNMENT_STATUS_TYPE_ID number?Hi, When running the below query, the table contains ASSIGNMENT_STATUS_TYPE_ID. This is a NUMBER value. Does anyone know where I could find the meaning of the value retu…
-
Pass Parameter to Order By condition in Data Model (BI Publisher)Summary I'm trying to configure a Data Model to use a Parameter. I want a user to be able to choose a column to Order By.Content Hi, I'm trying to configure a Data Model…
-
Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject areaSummary: Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject area Content (required): We have payroll balance data for an employ…
-
AOR Areas of Responsibilities in OTBIContent Hi All, Can someone help, which Subject area I can find Assigned Areas of Responsibility details in OTBI? Thanks, Vijay -
Oracle BI tables to retrieve Talent RatingsSummary: Content (please ensure you mask any confidential information): Hello experts, which tables allows to extract Talent Ratings as that one attached? Thanks in adva…