Reports
Discussion List
-
OTBI showing home department instead of worked/cost department for reported hoursWe’ve noticed a reporting discrepancy between HCM and OTBI when it comes to department allocation for hours worked. In HCM, an employee’s hours are correctly charged to …Trupti Khodke 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How can I pull an open requisition report that lists each Req's AOR representative?Summary: We would like to pull a report of open requisitions that includes a column listing the req's AOR Representative of a particular type. Content (please ensure you…Cheryl Burwell 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Entering Narrative Reporting Notes in ExcelSummary: Unless I'm mistaken, I believe the only way to enter commentary in a Narrative Reporting note is while viewing the report in HTML while logged into Narrative Re…
-
How to invoke a REST OIC integration from BIP by a data source where OIC is in Fusion domainSummary: We are invoking a REST integration from BIP by a data source using Basic auth which is working fine in our Dev environment. But In our Test environment oic is c…Pasad Elugoyi-Oracle 42 views 0 comments 0 points Started by Pasad Elugoyi-Oracle Identity and Access Management
-
Hiding columns based on conditions in BI report excel outputRequirement: Based on the employee who is viewing his/her compensation, we need to do hide few columns depending upon the employee's LDG and his eligibility. Can anyone …Rini_Varghese-Oracle 12 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Are there any roles to provide read-only access to a data model in oracle fusion?Summary: Hi, I want to provide read-only access to one data model to one of our users. Is there any roles or configurations that will help in providing read-only access …NagarajuKunchala 21 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
Query to fetch all the workflow transaction in HCMSummary: Team, can someone please share me the query to fetch all the transactions recorded in HCM Cloud(Transaction Console), I tried to query from fa_fusion_soainfra.w…Satyanarayana M-Oracle 4.7K views 7 comments 0 points Most recent by AnnaMorelli Reporting and Analytics for HCM
-
Hiding columns based on conditions in BI report excel outputRequirement: Based on the employee who is viewing his/her compensation, we need to do hide few columns depending upon the employee's LDG and his eligibility. Can anyone …Rini_Varghese-Oracle 22 views 3 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
Payslip is not sending to FTP through Payslip ExtractHello Team, Greetings of the day!! In seeded Payslip Extract, we have an additional delivery option which will send the Payslip XML data to FTP and it is working fine ea…
-
Can we create a dashboard using cards?Summary: Is it possible to create a visual dashboard within Oracle HCM to display key HR metrics such as headcount, billable vs. non-billable employees, attrition trends…Smruti Samruddha 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Are there available audit reports to track master data changes?Summary: Client wants a report to track master data changes - customer, supplier, system configurations. Are there available seeded reports to cater to this requirement?…len.baetiong-Oracle 21 views 1 comment 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
Cash Flow Statement Generation - FRS or Other Reporting ToolsSummary: Cash Flow Statement Generation - FRS or Other Reporting Tools Content (please ensure you mask any confidential information): Hi Experts, Please advise as to whe…Nicole Deleon 21 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
I'm unable to upload rtf template in report or it is showing uploading since long timeSummary: I'm unable to upload rtf template in report or it is showing uploading since long time. Content (please ensure you mask any confidential information): Version (…Anup Karmankar 65 views 4 comments 0 points Most recent by Ashish_Sahoo_Trinet26624 Reporting and Analytics for HCM
-
How to pass multiple values for a parameter in BIP report URLWe are trying to access a BIP report via URL. It is working fine when single values are selected. However when multiple values need to be passed for a parameter in URL, …
-
User entity or data base item of learn moduleSummary: Hi all, I have a requirement to fetch course and it's assignee/learner data but unable to find any learn module user entity or database item. Can someone please…
-
Issue with getting a cloud HCM custom Cheque report to run using its custom templateI have created a custom Cheque report, data model and template to process employee pay checks. The problem I am having is finding a way to have the custom report point t…
-
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…Anil Kola-Oracle 2.3K views 5 comments 9 points Most recent by User_FCP05 Reporting and Analytics for HCM
-
Purge task is missingSummary: We are creating a report to fetch archived and purged tasks details , after purging the checklist , task name are missing . Content (please ensure you mask any …
-
Output of 'Import Project Billing Events: Generate Report' in OICSummary: How to get report 'Import Project Billing Events: Generate Report' output in OIC and send it through email/ftp/UCM? I am submitting the Import Project Billing E…
-
ANC_PER_ABS_ENTRY_DTLS table is emptySummary Absence entry Detail table not getting populatedContent Hi All When absence entry is created from the UI with basic mode, data is not getting stored in table ANC…Amol Patil HCM-Oracle 844 views 18 comments 0 points Most recent by Mr H Reporting and Analytics for HCM
-
Course Completion ReportSummary: Looking for something similar to what we see in the Learners section of a course/transcript. I'm able to build off of completed activities, but when an offering…
-
A bip query is running very long timeBelow query is running for a long time in production and eventually timing out when with the filters but without the filter is running and fetching some data. It was wor…
-
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an…Sricharan Monigari 252 views 7 comments 0 points Most recent by Bisweswar Goud-Oracle Reporting and Analytics for HCM -
Custom Bi report run ess job, i want to export external system. Any size limit.Hi, Currently we are using custom BI report register ESS Job. we want to export data into external system. we are using below Rest api to trigger ESS job and extract dat…
-
Capture in BI Report the "Proposed Increase and Decrease in Budget" valueWe have a report requirement to extract in BIP report the "Proposed Increase or Decrease in Budget" value from Project budget version. Upon initial investigation, we hav…
-
Is there any table which stores interface error details for PPM Billing Events?PJB_Billing_Events_INT doesn't store any details. Or is there any way to delay the purge of data in this table post Import job runs? I am using it in OIC and need to get…
-
Missing users from ASE_USER_LOGIN_INFO tableSummary: Missing users from ASE_USER_LOGIN_INFO table Content (please ensure you mask any confidential information): As far as I know this table stores login information…Stefano_Mazzocca 210 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM