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
-
PER_PERSON_SECURED_LIST_V showing own recordsSummary: Hi, We have some reports created with PER_PERSON_SECURED_LIST_V one employee is from a country A with AoR from country B, on person management the employee cant… -
Error changing ReportsWhen trying to change the report from the custom folder, the following error appears: -
Add custom font to OTBI reportsSummary Can we add custom fonts to OTBI reports?Content I did upload a ttf file and created font mapping in Administration page but the font is not reflected in the OTBI… -
Employee Connection - Colour bar represents assignment typeSummary: My Organization chart page displays yellow bar for contingent workers and blue bar for employee assignments type. I do not see this colour bar feature on connec…
-
How can I display user chosen from and to dates in OTBI?Is there way to show the dates a user has selected in the output of the report? Date run can be shown in the title, but I want the user to enter a from and to date and t…
-
In which table has the information of Mail Stop in Legal Reporting Unit AddressesSummary: Hi, In which table has the information of "Mail Stop" in Legal Reporting Unit Addresses under the setup Manage Legal Reporting Unit. We checked in below tables …
-
Pivot table is not working in OTBI report with 2 subject areas, columns are not working properlySummary: Pivot table is not working in OTBI report with 2 subject areas, columns are not working properly as per the pivot table layout. Created a report with subject ar… -
Overdue Task Report in Journey ChecklistsSummary: Overdue Task Report in Journey Checklists Content (required): Hi All, Greetings! we are trying to check the exact data for the terminated employees with checkli… -
What is the OTBI Subject Area to get data from PER_LOCATION_LEG_F tableSummary: Which Subject Areas should i use to get the details from PER_LOCATION_LEG_F table. Should we need to any process to add those fields to the Subject Areas ? Cont… -
V3 seniority date multiple seniority date in OTBI IssueSummary: We just upgraded from V1 to V3 seniority dates and tried to update existing OTBI reports with the new dates. Have no issue replacing if the report is pulling ju…
-
BIP report, for identifying the missing Time EntriesSummary This will be useful If we are expecting to see missing time entries in report or infolets. This SQL query logic is based on the Working hours of the User.Content…
-
Foreign key relationship between HRC_SEM_EDUCATIONS and PER_ALL_PEOPLE_FSummary: Foreign key relationship between HRC_SEM_EDUCATIONS and PER_ALL_PEOPLE_F Content (please ensure you mask any confidential information): I am extracting data fro…
-
My Team Activity Center Org HierarchySummary: Redwood. 25A. Test Pod. When logged in as a Line Manager and accessing My Team Activity Center, the manager will click on the Org Hierarchy. When moving up the …
-
Calculation Card Component - Provincial Tax CardSummary: Column / Table where the Location held on the Provincial Tax Card is stored. Content (required): Hello experts, We've been trying to report on the Calculation C…
-
Missing folder in BI Catalog under Custom/Human Capital Management - Reports and AnalyticsHi Team, One of the folder "Talent Management" is missing under /Shared/Custom/Human Capital Management/ and we could not replicate what happened to the folder and when?…
-
Standard VS Custom ReportsSummary: Hi Everyone, Content (please ensure you mask any confidential information): How to check if reports are standard reports vs custom report? I need a table that s… -
How many days event object table will store the data - hrc_evt_source_objects , hrc_evt_obj_changesHi All, Can anyone help me to understand how many days these below event tables will have the Deleted rows?, I could see our event tables data was waived off from Jan. I…
-
Report on Auto-Provisioned RolesSummary: We are looking for a way to report on which of our security roles are auto-provisioned vs. manually provisioned. Does anyone know of a subject area that has thi…
-
OTBI Report shows wrong annualized salary and annualized full-time salarySummary: OTBI Report shows wrong annualized salary and annualized full-time salary Navigation Tools Reports and Analytics Catalog Created OTBI report based on "Compensat…
-
Custom bursting report failing sporadicallySummary: We have a scheduled process named Job Offer Notification that runs every 30 minutes to notify Compensation. While most runs complete successfully, we are notici… -
How to get all attribute in one nodeSummary: Hi Experts, I need your assistance. I'm currently working on XSL files to get values in the XML files. I want to show all the attributes separately in one node.…
-
Candidate Marital status and extra information reportSummary: Candidate Marital status and extra information report Content (required): Candidate Marital status and extra information report Version (include the version you… -
How to Generate a Dynamic template based on the assigned Business UnitSummary: Hi Experts, I am seeking assistance regarding a specific requirement from our client. The client has expressed a need to create a document that is customized ac…
-
SQL query to get the candidate's education detailsSummary: Hi All, I am facing an issue to get the candidate's education data using the SQL query: SELECT U.* FROM IRC_CAND_PROFILE_USAGES_M R, IRC_PROFILE_EDUCATION_ITEMS… -
Capturing the Learning outcome from the Learning Record Real Time subject area- OTBISummary: Content (required): hi there, we have as learning outcome a custom certificate. The certificate has a name, issued by field and issued date. I wonder if this ca… -
Goal library extractionHi to all, do you know if there is a possibility to extract all the goals entered by the HR on the Goal Library? Is there an OTBI area? Thanks in advance, Best Regards, …
-
Request for Guidance on Managing DEI Attributes in OTBI Analysis Following Executive Order 14151In response to the Executive Order 14151, "Ending Radical and Wasteful Government DEI Programs and Preferencing," signed on January 20, 2025, our Compliance team is work…
-
Report showing Employee Hierarchy in an OrganizationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
was trying to fetch the date format as 01-Jan-2025 in bip getting an errorHey i have a requirement in the bip where the date format is 01-Jan-2025 and in the SQL of bip i have used the format like TO_CHAR(ele.EFFECTIVE_END_DATE,'DD-Mon-YYYY') …
-
Terminated employee still visible as incumbents in position, how to free the vacant positionSummary: Terminated employee still visible as incumbents in position, how to free the vacant position Content (please ensure you mask any confidential information): Vers…