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
-
Different vision in OTBI than in UISummary: Hello We have moved to a Redwood theme in our UI but then our OTBI report look at change. It now looks very old school. Also please note that when we open it in… -
Retrieve User ListSummary: I would like to create a BIP report to retrieve a list of user information. Content (please ensure you mask any confidential information): Please let me know wh… -
Query to fetch Cost Center Details which are not mapped at Department LevelSummary: i need a query to fetch all cost center which are not mapped to the department. If anyone have SQL query please help me. Version (include the version you are us… -
Missing Overall Feedback and Max Questionnaire Score in OTBIwe have a business requirement to report the Overall Feedback Score for each feedback provided in Oracle Recruiting Cloud using OTBI. We explored the available subject a… -
PerformanceGoalRespApprovalNotificationReport not returning data after passing the transaction_idHi Team, Experiencing issues with the seeded notification (PerformanceGoalRespApprovalNotificationReport) triggered for manager approval when a worker adds, updates, or … -
Error while copying the Payment HCM extract.Summary: We have a requirement to add some additional information under standard Paycheque report.For this purpose,I am trying to customize the "Payment" HCM extract def… -
Not able to view entire employees details in Subject area only able to view own recordSummary: i was able to extract employee details using Assignment subject area but now when I am using the subject area it is only displaying my data. I have all the role… -
Need to display employee records transferred from Payroll to GLContent Hi All, We transferred the data from Payroll to GL. Now we need to display those records either in OTBI/BIP. Can you suggest do we have any subject area/BIP tabl… -
Report to track payroll entries transferred to SLAContent Hi, Is there a way to track the payroll costing entries which are transferred to SLA. We have a situation here where finance has confirmed that the totals in the… -
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.… -
Requirement to Add Print / Approval Printout Action in BPM Worklist Approval PageSummary: Hello Oracle Team, We have a business requirement to provide a Print / Approval Printout functionality directly from the BPM Worklist approval page in Oracle Fu… -
Does BIP reports support docuSign?Summary: Content (please ensure you mask any confidential information): In this discussion it seems docuSign is not supported for BIP reports. Can someone from Oracle co… -
Getting error while uploading PGP key in BI AdminstrationSummary: Getting below error while trying to upload the PGP key. Importing public key file xxxx_public.asc failed: reason = Key file could not be imported: exit value=2 … -
Need to get referrer Job Title and Referrer assignment status in OTBISummary: We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker p… -
Date changes by1 day while formattingSummary: Hi, I am using Oracle template builder for one of my reports which has date column, when I apply date formatting date changes by one day (example: 4712-12-31 ch… -
Anytime Feedback Report template - need helpSummary: Need help on this: When I use the Subject Are: Work Profiles - Feedback Notes by Recipient Real Time, the report is fetching all data from feedback and meeting … -
Report on Anytime FeedbackContent Hi All, Is there a delivered report for anytime feedback that we can leverage? If not, has anyone built one and how? Please share any information you might have.… -
Are there User Entity for Individual Compensation Plan In HCM ExtractSummary: Are there User Entity for Individual Compensation Plan In HCM Extract Content (please ensure you mask any confidential information): Version (include the versio… -
How to report on the due date for Journey tasks in OTBI?Summary: We are looking to create an analysis in OTBI to pull a list of individuals who have overdue tasks from their onboarding journey. We are using the Workforce Mana… -
Element Entries Real Time - Retroactive Payement DateSummary Within Element Entries Real Time - I have Retroactive payements made to employees however in OTBI i cannot locate 'Orginal Date Earned'Content Overview: For Empl… -
Sending of analysis to managers via agentsSummary Sending of analysis to managers via agentsContent Hi - We have set up a number of Analysis which are currently being sent to different business units / locations… -
BIP report to get the approval status with history and attachments for Leave encashment, salary trasSummary: Hi Experts Could you please help me with the BIP report sql query on how to get the approval status for DOR requests like Leave encashment, salary transfer lett… -
Query to fetch "Issue Description" and "Resolution" for failed transactions.We had a requirement to display issue description and resolution for failed transaction. When we use table hrc_console_fault_details_vl hcfdv(for description and resolut… -
Need table information to get below fields from journey template pageSummary: we need table information to get below fields. Restrict assigning journey if its in progress Use assignment identifier associated with assigned journey Navigati… -
Enterable Calculation Values on Calculation Cards 'value' Field DBI for Fast Formula or TablesSummary: Hi There, looking for Enterable Calculation Values on Calculation Cards 'value' Field DBI for Fast Formula or Tables Content (please ensure you mask any confide… -
OTBI report is generating single row output when language preference is changedSummary: OTBI report is generating single row output when language preference is changed and when language preference is set to English, then output looks good and otbi … -
OTBI – Workforce Profiles: Person Profile Real Time pulling deleted competenciesSummary: I have a reporting requirement to identify the competencies workers have entered on their Person Profile, including workers who have not entered any competencie… -
How can I pull all reports and their permissions available /shared folder/custom/ pathSummary: How can I pull all the reports available in "/Shared folder/Custom/" path with their permissions through backend(sql) or any other alternate, with environment h… -
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a… -
missing national identifierSummary: Technical user cannot extract National Identifier (Codice Fiscale) from PER_NATIONAL_IDENTIFIERS despite ORA_FND_INTEGRATION_SPECIALIST_JOB + custom role duties…