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: 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… -
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 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…
-
Technical Specialization BI Pub ReportHello everyone, We need to create a BI Publisher report to retrieve the Technical Specialization for each employee. For this, we need to extract all technical specializa… -
Is an Organization DFF visible in OTBISummary: I'm trying to build an OTBI Report that will show our Organizations and a DFF that is tied to Organizations. This DFF shows under the Department folder in the W… -
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E… -
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…
-
We need a query to get Payroll Balance group usages mapped to Balance dimensionSummary: Hi. We need a query to get Payroll Balance group usages mapped to Balance dimension. When dimension changes(Quarter, Run, Month… ) then the Balance group usages…
-
Need query to compare roles for personSummary: I want to compare roles for person based on role mapping. For example , role mapping has 5 roles and person has currently 2 roles only in that role map. I want …
-
is there a way to download the each OTBI report output from Dashboard in different formats?unable to find the option to download the report output from Dashboard
-
ASE_USER_ROLE_MBR table usage restriction and alternate table suggestionSummary: Is ASE_USER_ROLE_MBR not supposed to be used for BI reporting? If yes, what is the reason, and what could be the alternate way to get the role revocation detail…
-
OTBI Report on Performance Goal Tasks within a Goal PlanWe need an OTBI report for Employee Performance Goals and Goal Tasks. It must include the Goal Plan Name so we can tell which Goal Plan the goal was created in (we assig…
-
Data Model option does not show up in BIPSummary: Data Model option does not show up in BIP Content (please ensure you mask any confidential information): Hi All, Greetings! We have added the needful BI related… -
How to Create Dynamic Parameters in a Data Model?We have a Data Model that uses Parameters and List of Values SQL to automatically determine beginning and ending dates for a report that runs once a day. Well, we though…
-
French Social Report - Required Parameters and Payroll Action IDHello, I am working with the French Social Report BI Publisher report. To run the report, several parameters need to be provided, such as: ArchiveActionId DeliveryOption…
-
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…
-
How to combine multiple OTBI Analysis into one OTBI Analysis to generate graphs?Summary: We have requirement to create a Turnover dashboard based on the count of unique person numbers at a point in time using OTBI analysis. As the fact columns in wo…
-
How to use Hyperlink in RTF templates?Summary: Hello Experts, Is it possible to use Hyperlink in RTF templates? Like, in the report output, the Person Number attribute will have a hyperlink, once the user cl…
-
Dynamic Hyperlink in BIP RTF templateContent Hi Team, I am looking for a dynamic hyperlink for my rtf template. The requirement is such that for recruiting we need to send email to employees with a link for… -
BI Publisher Scheduled Report Not Reflecting Updated Recipient List in Oracle FusionSummary: We are facing an issue with an existing scheduled BI Publisher report in Oracle Fusion. After updating the recipient email list in the schedule, the changes are…
-
BI Catalog Folder ManagementI am looking for best practices on managing Custom Folder in BI Catalog: We have 2 folders for custom reports: Custom Folder and CompanyName Business User Reports (mostl…
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticesContent This white paper provides the best practices for working with BI catalog folders, and … -
OTBI Archiving/Unarchiving dashboards across environmentsSummary: OTBI Archiving/Unarchiving across environments – Dashboard Migration successful but Action Link Drill‑Through Not Working Content (please ensure you mask any co… -
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…
-
How to remove Home / Catalogue line from dashboard?Summary: I need to hide the line from a custom dashboard (not a BIP report) Content (please ensure you mask any confidential information): Version (include the version y… -
DO noT useSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 26B Code Snippet (add any code snippe… -
How to get referral candidates details using BIP reportHi Team, Could anyone give me the sql query for referral candidates details. The report must contain Candidate Number Candidate Name Candidate added into the system date…
-
BIP report or data model for fetching the data of all the employees with their Hire date, terminatioSummary Can anyone help me with BIP report or data model for fetching the data of all the employees with their Hire date, termination date, rehire date along with depart… -
SQL not fetching pending worker created in last 1 hourSummary: SQL not fetching pending worker created in last 1 hour Content (please ensure you mask any confidential information): Hi All, There is a BIP report with burstin…
-
From email address for the scheduled reports not stored in the tableSummary: While trying to extract the From Email address for the scheduled reports then "bipublisher-report@oracle.com" is getting fetched instead of the actual Email add…
-
exceeds the maximum limit error even after using filterSummary: exceeds the maximum limit error even after using filter Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below …
-
How to add Analytics section to homepageWe've been trying to embed some infolets on our Oracle Cloud homepage, however it appears that most users (at least it seems that way based on Cloud Connect posts, YouTu… -
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…