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
-
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,… -
Table to identify password updateSummary: Is there a table that tracks the password updates? We have a scenario where the password of a service account stopped working all of a sudden. I have run the pa… -
BIP Tables for Calendar/Calendar Events linkage with EmployeeSummary: BIP Tables for Calendar/Calendar Events linkage with Employee Content (please ensure you mask any confidential information): Hello, from My Client Groups > Orga… -
What's wrong in this bursting?Summary: Content (please ensure you mask any confidential information): I have this template and this bursting query: Report works fine: Why do I get an empty output whe… -
Report to get the User login and logout time in oracle fusion HCM instance.We are searching for any kind of report that will show the information or details about the users login and logout time to the Oracle fusion HCM instance. Could you plea…
-
Transaction comments reporting - Termination ReportContent With the release of the new UI, the per_periods_of_service table no longer contains the comments for the termination transaction, instead the comments are placed… -
Generate Check Payment statusSummary: We have Gnerate Check Payment Status as "Void" or "Paid and not Reconciled". Need to know in which table/OTBI suject area holds this exact value. Content (requi…
-
Unable to Retrieve Qualified Entitlements Plan Details Using OTBISummary: Unable to Retrieve Qualified Entitlements Plan Details Using OTBI Content (please ensure you mask any confidential information): Hi Experts, We have a requireme… -
Issue Accessing Manage Users in Oracle Fusion Data Intelligence – MFA Redirect to OCI ConsoleSummary: We need to access Manage Users in Oracle Fusion Data Intelligence in order to add users to groups. However, when attempting to access Manage Users, the system r…
-
Migration of Fast Formula, Lookup, UDT in bulk from one instance to another.I am migrating Fast Formula, Lookups, UDTS from one instance to another in bulk, what we need to select under deployment method while creating task, please suggest?
-
sql to fetch payroll process having ui_task_status = 'COR_FLOWS'Summary: Parameter having p_start_date , p_end_date, p_payroll_name based on this parameter will identify period name and start_date and end_date from pay_period table. … -
Table to query access groupSummary: Hi the team, In Oracle learning cloud we can link Global Access Group at Course and Offering level. We would like to run an analysis to see which learning conte…
-
Job Offer Facts in OTBI Not VisibleIn OTBI, Recruiting - Recruiting Real Time subject area, the Number of Job Offers measure in Facts - Job Offer is returning 0, with no other fields or filters selected. …
-
Missing PII Candidate Report (OTBI)Summary: We are trying to create a candidate level report based the current phase, current state, and the DoB and/NID is null. The purpose is for the recruiters to be ab…
-
Oracle BI Cloud Connector (BICC) to Flexfields data from HCMSummary: We are using Oracle BI Cloud Connector (BICC) to extract data from HCM using a third party tool (FIvetran). However, we have a need for a couple columns of data… -
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheethttps://us.v-cdn.net/6034893/uploads/XTAY0TAIX14K/rel13-24-x-bicc-hcm-database-mapping-with-viewobjects-xlsx.zip Summary This posting includes R13 HCM BI Cloud Adapter B…
-
Query to Get Created BIP Jobs and OTBI Agents in Oracle FusionGood Day Experts, I need to have a report listing all of our team's created BIP Jobs and OTBI Agents. Are there any available query to get this information (Job or Agent…
-
How to force repeat on rows in pivot tableSummary Trying to build a pivot table using the report editor with repeating valuesContent Has anyone been able to force a repeat on a row value in a pivot table? The ex… -
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve…
-
ANC_PER_ABS_DAILY_DTLS - Issues with Overnight Shifts / Absence BreakdownSummary: We want to report on absences related to a shift, however the table seems to store the hourly breakdown per day rather than per shift start date. Example; 25/06…
-
OTBI - Minimum Proficiency LevelHello, Please note, in our configuration, each competency in job profile has a minimum proficiency level. In OTBI Analysis, under the "Workforce Profiles - Model Profile…
-
BI Security using Secured View in Fusion HCM Release 9.2Summary BI Security using Secured ViewsContent Regarding BI Security the MOS ID (Doc ID 1533659.1) talks about : PER_POSITION_SECURED_LIST_V PER_PUB_PERS_SECURED_LIST_V … -
Why is per_person_secured_list_v secure view not working on AORs in custom BI Report?Summary: Why is per_person_secured_list_v secure view not working on AORs in custom BI Report? I am running my custom report (containing the per_person_secured_list_v) b… -
What is the Subject area for Career Statement?Summary I want to know which subject area give "Career Statement" in OTBI -
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr…
-
25D - Text Object "Contains HTML/Javascript/CSS Markup" Option remvoedHello, We've recently upgraded our DEV environment to 25D. We're now finding that the option to include text that contains HTML has been removed. Was this documented any… -
How to create BI report for checklist task type "Report" which accepts the parameter as AllocatedCheSummary We have requirement that one of the Task performer (which is last task in checklist) wants to review the report with all other task performers input to DFFs and …
-
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… -
Changes to ManagerDORReport not reflected in notification.I am having an issue customising the ManageDORReport template. I have saved a copy of both the report and data model into the custom folder, removed the fields I don't w…
-
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 …