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
-
Max Effective Date Record on a Combined Subject Area Report Or Null ValueSummary: We are trying to bring back one row for Performance Task Completion Date, either the Null row or the latest completion date. Using "- Performance Task Status De… -
learning compliance reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Since redwood update in hcm the URL for reports are now not able to be shared as these get 404 errorSummary: Redwood has been updated into our production enviroment. The URL for the BIP reports, now no longer is able to be copied, shared as a link, and opened. Content …
-
Build a BI Publisher Report that tracks incremental changes in Core HRSummary Build a BI Publisher Report that tracks incremental changes in Core HRContent Hi Experts, I have a requirement for a BI Report wherein I need to pull a lot of ch… -
How to do grouping for data visualization in OACwe had a requirement to develop a workbook on Business unit wise Average age of employees. For that i have made a connection with Oracle Analytics and then i have create…
-
User Account Details (Email Address) in Security ConsoleSummary Need table names to be able to pull email address kept in Security ConsoleContent Hi All, I am struggling to find and link tables to pull User Account Email Addr… -
Degraded performance when using secured views in BIP reportsSummary: Using a secured view (e.g., PER_PERSON_SECURED_LIST_V) in a BIP report results in a severe increase in the execution time of the query when ran by a user with a… -
In which table has the information Manage Reporting EstablishmentsSummary: Hi Team, Need a table or sql query to get the information Manage Reporting Establishments as in below marked screenshot Content (please ensure you mask any conf…
-
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…
-
Where to find Currency Conversion Rates used in a Compensation Plan?Summary: Hi all, I have a compensation plan (CMP_PLANS_B) with a specific PLAN_ID. I want to retrieve the currency conversion rates used for this plan, which were upload… -
Maximum report data size for offline (scheduled) reports value changeSummary: Maximum report data size for offline (scheduled) reports value change Content (please ensure you mask any confidential information): Hi Team, Greetings! How do … -
Department Set Name/CodeSummary: We have a requirement to include the Department name, Department Set name/code to a project details BIP report we are able to find what table holds the departme…
-
Is it possible to report on Interview Requests?Summary: Is it possible to report on Interview Requests? I've seen the post linked below, which I thought was asking the same question, but the answer appears to be dire… -
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an…
-
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…
-
I need to create an analytic in OTBI To identify what work schedule is assigned to employeesI am trying to create a simple analytic in OTBI to show all employee names, their assignment numbers and the names of the assigned Work Schedule for each assignment. It …
-
Embedded Reports not loading 1st time opening the screensSummary: Embedded Reports not loading 1st time opening the screens Content (required): Hello We have 2 embedded reports in the absence screens which are not loading on t…
-
Employee/Person Addresses not visible in per_addresses_f tableSummary: We have loaded Employee/Person Home Addresses data using HCM HDL file and the load was successful. I can see the data in the table per_person_addr_usages_f but …
-
SQL query to retrieve employee location country nameSummary: Content (please ensure you mask any confidential information): Hello experts, we need a query to retrieve the employee location country name but below it extrac… -
organization seniority date on multiple contractsSummary: How can I report on the Org Seniority Date when person has more than 1 contract Content (please ensure you mask any confidential information): Hello Has anyone … -
Unable to bring max effective date record in a report while using an EIT flex fieldSummary: In a report with 2 subject areas, columns are not working properly. Subject Areas used: Worker Assignment Real time and Person Real time Created a report with s… -
Missing HcmTopModelAnalyticsGlobalAM.OrgAttributesDFFBIAM.FLEX_BI_OrgAttributesDFF_VIWe don't see HcmTopModelAnalyticsGlobalAM.OrgAttributesDFFBIAM.FLEX_BI_OrgAttributesDFF_VI in BICC offering though it is available HCM PVO mapping document. How do we ge…
-
XML-22002: (Fatal Error) Error while processing include XSL fileSummary: We are getting the error XML-22002: (Fatal Error) Error while processing include XSL file (xdoxsl:///Custom/Human Capital Management/HR/SUBTEMP.xsb?loc= en-GB) …
-
In which table has the name format components storedSummary: Hi Team, We need a table where the name format components stored, Tasks: Manage Person Name Formats - HR_NAME_FORMATS I need the table for name format component…
-
Can i get a list of reports from Catalog in OTBI?Summary A client has requested a report showing names and location of all reports available in OTBI (including custom reports). How can i get such a report? Content (ple…
-
Number field not displaying correctly on RTFSummary: I have a RTF created with the BI Publisher Add-in and is sent as a PDF email notification through a bursted BIP report. There is a number field on the RTF, that…
-
How to Encrypt and Send BIP report output from oracle HCM cloudSummary: There is a need to Encrypt a BIP report output to 3rd party through SFTP. Please let us know the possibility and how to accomplish it ? Does BIP provide any def…
-
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…
-
BIP report to extract all JR approval flow stepsSummary: BIP report to extract all JR approval flow steps Content (please ensure you mask any confidential information): Hello experts, my customer requirement is to ext…
-
Extract future task assignment in transaction approval flowHello experts, I know that we have the ability to query current and past approvers for an approval transaction (hrc_txn_data / fa_fusion_soainfra.WFTASK), but is there a…