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
-
Report Vacant PositionsSummary: How to report Vacant Positions. Content (required): How to identify "empty seats" on a Pooled Position and report Single Positions without incumbents Version (i… -
Historical Position Change Report All In OneSummary: Our Benefits team wishes to have a report to view historical employment data in one snapshot, to aid in our retirement eligibility process. Does a report like t…User_2025-02-11-20-55-10-551 31 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro -
Query the email sent in the BIP ReportHello All, We have checked that there is an available record to check the scheduled process that trigger the report that does the email bursting. What we wanted to check…
-
Need OTBI Subject Area and columns for incomplete tasks under Allocated Checklist.Summary: We have a requirement report incomplete tasks under Onboarding Checklist, I used Workforce Management - Checklist Realtime subject area. I am able to get the ch… -
Report for a Salary basis of the type "Salary amount is determined by simple components"Summary: We have a Salary Basis defined of the type "Salary amount is determined by simple components" and we have hired an employee with this salary basis. There are 5 … -
Min, Mid and Max Salary Ranges missing for some associates in OTBI Report. How can we fix this?Summary: Unable to pull Salary Range Min, Mid and Max for some associates in OTBI report. Content (required): Hello, While pulling a report created in OTBI the Salary Ra…
-
BIP report includes a parameter as the first column in the CSV formatSummary: BIP report includes a parameter as the first column in the CSV format Content (required): Hi experts, BIP report includes a parameter as the first column in the… -
How to link locations with geographySummary: Content (required): Hello Guys, We would load the city present in the locations inside the Geography of the recruiting. How could we perform it? Where could we … -
How do I turn an OTBI Dashboard into an Infolet?Summary: Looking to convert some of the delivered dashboard into infolets Content (required): Version (include the version you are using, if applicable): Code Snippet (a… -
How to report on position changes?Summary: I work for Charlotte-Mecklenburg Schools and we are in the process of modernizing to Oracle HCM Cloud. We have asked our ERP vendor to create a report to captur…
-
ORC fields mapping with HCM TablesSummary: We're looking for mapping documents to associate each ORC field to the correspondent item in the HCM tables (e.g. ATTRIBUTE_CHAR1 etc) Content (required): Hello… -
Display Extended Absences by day from Absence ModuleSummary: We have a requirement to show absences by day if they are booked over a period of time. Content (required): The example we have is if someone books a week long …User_2025-01-31-00-25-12-234 22 views 2 comments 1 point Most recent by User_2025-01-31-00-25-12-234
-
Error uninstall Oracle BI Publisher Desktop 1670:Unable to Load module with error code:1114Summary: We are trying to uninstall Oracle BI publisher Desktop , but we are getting below error 1670: Unable to load module c:\Users\Admin... Error Code: 1114 Could you…
-
OTBI - Not returning Most Current Assignment RowSummary: OTBI - returning more than just the Most Current Assignment Row. This began happening after our 21C update. Content (required): Hi, I'm creating an OTBI report … -
Query to get account numberSummary: Query to get account number present in below screenshot Content (required):Navigation - Payroll>Statement of earnings>Costing Results>Account number. Can anyone…
-
BIP report job status - difference between 'failed' and 'skipped'Summary: BIP job status - skipped and failed - what do these mean Content (required): We have a number of BIP report jobs running to send out letters / notifications to …
-
workforce structure change reporttrying to build a report that captures changes on the department table. We maintain history on our departments, but would like to be able to report on it. If we do the r…
-
Subject Area - Department Hierarchy(Department Levels) coming up as blank columnsSummary: Subject Area - Department Hierarchy(Department Levels) coming up as blank columns Content (required): Hi! I'm trying to create a subject area analysis that disp…User_2025-02-11-21-40-21-159 144 views 5 comments 1 point Most recent by User_2025-02-11-21-40-21-159
-
How to use one or the other parameter in a SQL querySummary: I have a query that I built that is supposed to either pull in the list of terminated employees based on the date range entered OR a list of terminated employee…User_2025-02-04-08-51-08-912 53 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro
-
View Formatted CLOB Text in BI Report Excel TemplateSummary: We are trying to fetch a formatted CLOB Data in an Excel template. However, the report is fetching HTML tags in the Excel cell . We tried the solution given in …
-
View Formatted HTML Text in BI Report Excel TemplateSummary: We are trying to fetch a formatted CLOB Data in an Excel template. However, the report is fetching HTML tags in the Excel cell . We tried the solution given in …
-
Can we Hide Exporting options from user while running BI Publisher Reports ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Position FTE Over Under - hr_all_positions_f_VL linked to position_fte_sum via position_idSummary: Content (required): We have a data model that was created by a third party and they are linking to HR_ALL_POSITIONS_F to get details on overunder FTE counts. It… -
Report With the FileURL (Download Link) of an Employee DocumentSummary: We need a BIP report with a download link to an employee's document (DocumentRecords) Content (required): Hi, Is it possible to generate a BIP report with the d…
-
SQL for Environmental health and safetySummary: Team, Does anyone have the sample environmental health and safety BI report (SQL). Please share Content (required): SQL for Environmental health and safety SQL …
-
Report on all the comments that the enrolled users have done in Enrollee Self-service conversationSummary: Content (required): Hi there I want to run a report on all the comments that the enrolled users have done in Enrollee Self-service conversation in a course. Is … -
For how long the Job Run History of a BIP report is maintained in Oracle Fusion?Summary: Content (required): Hi Team, For how long, the report job history for a BIP report is available in Oracle Fusion? How often the history is purged? Is it configu… -
Accessing OTBI analysis using a linkSummary: Just like we can access the BI report using the link to the report where we can use _xmode to hide all the BI page buttons. Can we also access OTBI analysis usi… -
Employee historical rowsSummary: Looking to get a report of all employees in the system and all of their historical records. If we run the Worker Assignment Real time subject, it can pull histo…
-
Is there any way to create bulk users and assign them bulk roles. Also any limitations involved?Summary: Is there any way to create bulk users and assign them bulk roles. Also any limitations involved? Content (required): Is there any way to create bulk users and a…