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
-
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti… -
Common Question: How to Create a Table Style PromptSummary: The attached video shows how you can create a table style prompt. This is useful when you can't have a dashboard, but table prompts don't offer multi-select. Co…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
Common Question: How to Edit an Analysis in a DashboardSummary: Explains how to edit an existing analysis in a delivered dashboard. Content: In the relevant section on the xyz properties button, select Edit Analysis. Use Sav…
-
Common Question: In what particular subject area can I find these columns?https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet Typical Symptoms: you see columns on an appl…
-
OTBI Logical SQL complex query assembler - NOW 10 subject Areashttps://us.v-cdn.net/6034893/uploads/IRBUUHV044EZ/logical-sql-assembler-v5.xlsx Summary Now updated - Combine analyses from up to 10 different subject areas (V4) Content… -
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports … -
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…
-
Report Query to Determine Subject Area UsageSummary: With the 26A release, the Workforce Management - Vacancy Real Time subject area is being discontinued. Is there a query that can be run in OTBI that will provid… -
Clicked metric is not available for reporting or data extraction in ORC CampaignsSummary of the Issue In Oracle Recruiting Cloud, the “Clicked” metric is visible and functions correctly at the campaign level in the user interface. However, this metri… -
Query to make audit on Document of RecordsSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to track who loaded document of record type and attachments, when t… -
How to find the Report path with the report nameSummary: I have the report received to one of the recipient. The recipient request to add another person name to the report scheduling. I do not have the information whe… -
How can we track which users have executed an Oracle Fusion BI Publisher report from the catalogSummary: We want see the Report details who ran from catalog. is there any tables which stores that info to extract. Content (please ensure you mask any confidential inf…
-
OTBI issue issue,Workforce Management – Absence Real Time subject area.Summary: Hi , OTBI issue issue, calculated absence duration when using the Workforce Management – Absence Real Time subject area. Example: Employee submitted three conse…
-
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_id?Hi Team, Experiencing issues customizing the seeded notification (PerformanceGoalRespApprovalNotificationReport) triggered for manager approval when a worker adds, updat…
-
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…
-
While loading worker dat file, getting error the error for PersonLegislativeDataSummary: While loading the worker dat file getting the below error for PersonLegislativeData component You can't update this record because the SourceSystemId {SRC_SYSTE…
-
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.… -
Redirection link to a report using environment variableSummary: #{header["host"]} variable in page entry Static URL no longer valid Content (please ensure you mask any confidential information): Hello, I used to use #{header…
-
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…