Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
immediate updates of information to a PDF outputSummary: I have a question about how to get immediate updates of information to a PDF output of a BIP report. Content (please ensure you mask any confidential informatio… -
excel file data set - volume/row limitSummary: Is there a volume/row limit when uploading an excel file data set in BIP? -
Help with "Guide me" ReportSummary: Hello, I am building a report that fetches information about Grade Ladder, Grade Name, Step Name, and Value. The query itself is not an issue. However, I need t… -
Element HDL Template Generator ReportSummary OTBI report to generate sample files to create Payroll Elements using HDL Content Introduction: This report provides sample files to create Payroll Elements usin… -
Need to fetch Resignation/Termination withdrawn after last working dateSummary: Hi, There is a requirement to pull all the employees who has withdrawn the resignation/terminations after the last working day need to include pending for appro…
-
Dashboard prompt for effective date reporting possible?Summary: Hi all, I have added SET VARIABLE PARAM_EFFECTIVE_DATE = '@{P_DATE}{@{system.currentTime}[YYYY-MM-DD]}'; into the advanced tab under prefix for a OTBI analysis …
-
Recruiting Real Time: Application Questionnaire reports take several minutes to generateSummary: When trying to run a basic query from RRT Application Questionnaire, it takes several minutes to run the query. Does anyone have ideas on how to improve reporti… -
Need a report with following fields employee name,# of reportees, # of “reporting levels”Summary Need a report with following fields employee name,# of reportees, # of “reporting levels”
-
How to add custom paramter based on other custom parameter in Dashboard PromptHi Team, I need to create custom parameter with formula based on the value from the other custom parameter with formula. Category and Sub cateogry - both are from same f…
-
How i can improve the running time for one report?Summary: Misdated Payroll Relationship timming out I used this formula: CASE WHEN "Payroll Assignment"."First Standard Earning Date" = MIN("Worker Payroll"."Payroll Star…
-
How to Include the Weekends and Public Holidays in the OTBI dashboardSummary: How to Include the Weekends and Public Holidays in the OTBI dashboard to the below code snippet. Content (please ensure you mask any confidential information): …
-
Display Value for Time Entry Layout Component fieldSummary: Display Value for Time Entry Layout Component field Content (please ensure you mask any confidential information): Hello, I have a time entry layout component o…
-
Manage Administrator Profile Values - Is there a Report for this?Summary Get list of all Enabled Profile Values - Manage Administrator Profile ValuesContent Hi All Could any of you have a Report for the Administrator Profile Values? W… -
Extract the UCM content server attachments through BI ReportsSummary Extract the UCM content server attachments through BI ReportsContent Hi, PDC attachments(File formats like PDF,Excel,JPG etc) currently placed in UCM content ser…
-
Issue with Dependent Filters and Multiple Selections in BIP Report for CoursesSummary: Hi Team & @AshishERPCloud, I have created the BIP report for the Courses. Where I have given the filters of Course, Offering, Business Unit, Start and End Dates…
-
Issue with employee's line manager compensation plan approval status SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query by filtering for an employee for testing purposes: se… -
SQL query to retrieve compensation plan status at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, I need to track for all employees the status of their line managers compensation p…
-
How to display the filters in a BI Report, in multiple rowsSummary: How to display the filters in a BI Report, in multiple rows Content (please ensure you mask any confidential information): Hi, we built a BI Report, entering se…
-
How to add Business Title from Worker Assignment Realtime in User System Usage subject area?I have created an analysis under User System Usage subject area. However, upon adding Business Title column from Worker Assignment Realtime subject area, data became emp… -
BIP Report schedule to send data only when it has dataSummary: I want to schedule a BIP Report daily but it only send the report if there is a data in the report. If the report does not have any data, it will skip. Content …
-
How to trigger notifications to the Mobile Numbers instead of Email IdSummary: Hi Team, We know that the notifications will be triggered to Email IDs through bursting and the customer asks to trigger the notifications to the employee's mob…
-
bip query is very slowSummary: I have written a BIP query which runs fast in SQL Connect using one bind variable. When placing the query into a BIP report there are no issues but the query so…
-
Issue on value set retrieving custom field in person profileSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom value set retrieving a custom attribute in person profile. At …
-
Cannot retrieve Manager IDSummary: Content (please ensure you mask any confidential information): Hello experts, I've created the attached value sets retrieving the employee Manager ID. If I laun…
-
Learn Module | SQL query to get specialization details , module name, offering name, enrolled learneContent Hi All, I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current statu…
-
Importing Oracle JET Visualizations in OTBIWe have an ask from the Customer if we can import Oracle JET Visualizations in OTBI We checked the above link to explore Oracle JET Visualizations but not really sure on… -
BIP Query to list 'Data Security Policies' tied to a job roleSummary: Client has a requirement to list ALL the Inherited Roles, Privileges and 'Data Security Policies' tied to a job role. We are able to list the Inherited Roles, P… -
Help on manager hierarchy fast formulaSummary: Content (please ensure you mask any confidential information): Hello experts, I need to replicate the line manager hierarchy in compensation plan. However, we s…
-
Unable to see all privileges in Security - Roles and Privileges Real Time SAWhen I am trying to fetch roles & their respective privileges from subject area(Security - Roles and Privileges Real Time). It is not fetching all the privileges. Can so…
-
Query retrieving manager job nameSummary: Content (please ensure you mask any confidential information): Hello experts, how can I retrieve the line manager job name? I've used the following query but th…