Reports
Discussion List
-
Check-Ins ReportContent We are considering implementing the Check-Ins feature in our 2021 performance reviews. We will need to be able to track completion rates. Perhaps I am overlookin…Christina Arteaga 71 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Reports under Workforce Compensation planSummary: Hello experts, Please let me know where can I find the details of delivered reports available under Workforce Compensation and related data models. Thanks, Cont…Vaishnavi Agrawal 28 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https…User_MC37Q 1K views 5 comments 1 point Most recent by NIRMAL KUMAR L Reporting and Analytics for HCM -
Access to customize reports in Publisher greyed outHi all, Hoping someone could assist with an issue regarding access to customize reports in Publisher. The user has BI Author and BI Admin. The folder permissions for the…G. Class-Peters 18 views 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM -
HR Action / Termination Action in Manage Work RelationshipSummary HR Action / Termination Action in Manage Work RelationshipContent Hi - We are trying to move all of our BI Publisher reports to Analysis and encountered an issue…Roy Paolo Paunlagui 184 views 13 comments 1 point Most recent by Anjaneyulu Reporting and Analytics for HCM
-
Not able to view seeded template at the seeded path after customising the reportI have customized the seeded template for the US Payslip report and it is present at the custom path:/shared/Custom/Human Capital Management/Payroll/Payment Distribution…Aditya Jadhav 12 views 4 comments 0 points Most recent by Aditya Jadhav Reporting and Analytics for HCM
-
Request for SQL/OTBI to Extract Scheduled Process Parameters (ESS)Details: We are looking for a way to extract Scheduled Process details (ESS), specifically the following information that is visible in the UI for processes such as Calc… -
Individual Compensation plan data not populating on a reportSummary: our Division Admins can see Additional pay amounts for ICP's on the compensation screens but when they run a report no data displays for the ICP for them. We ar…
-
OTBI/BIP catalog/folder last update date differenceHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified … -
query object permissionswe are looking for the physical tables or BI publisher SQL that will allow us to see the permissions for the objects in our catalogs (data models, report templates, prom…
-
OTBI Report (Dashboard) Security Not Mirroring FusionContent My understanding of the OTBI security is that security applied in Fusion will also be applied when running reports. You'll see the same data. However, if additio…Rebecca L Smith 57 views 13 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM
-
Reported Time Card Real Time Performance Very SlowSummary: Reported Time Card Real Time Performance Very Slow Content (please ensure you mask any confidential information): Good Day, Is there a way to improve the perfor…JMLMIII 15 views 5 comments 0 points Most recent by Jessamyn Donovan Reporting and Analytics for HCM
-
How to restrict the data in OTBI report based on AOR (Area of Responsibility)We have created HCM reports from the Absence module, Goals and performance, etc. and we need to restrict the data based on AOR. Is it possible to restrict the data in th…Vikas V. Kamat 153 views 7 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM
-
OTBI Worker Attributes Changed After Redwood EnablementSummary: Our reports stopped working in Production after migrating to Core HR Redwood. We’ve observed changes in OTBI column attributes when comparing Redwood and non-Re…Josel Pleyto 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can you help me add the assignment status (Active/Inactive/Suspended,etc) to this SQL query?Summary: Hello team! I have this code, but I don't know how to add the assignment status (Active/Inactive/Suspended, etc). Could you please help me with that? Thank you …Claudia Linares L 90 views 13 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Absence calendar seeded report does not show any dataSummary: Absence calendar report does not show any data Content (please ensure you mask any confidential information): Could someone advise why does the data does not po…Nancy Dsouza 9 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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…Sankalp Shukla 1.1K views 9 comments 1 point Most recent by Sangeetha17-Oracle Reporting and Analytics for HCM -
Create an alert or mail delivery system for a sequence in OACI have a sequence in OAC. The sequence has multiple data flows present. I need to setup some sort of alert so that I get an alert in case a data flow fails. How to get t…
-
Need Table Storing Bank's "Active" Flag from Personal payment Methods ScreenHello, I'm trying to locate the backend table that stores the "Active" flag status displayed on the Personal Payment Methods > Bank Information screen in Oracle HCM (Sel…Jahnvee Sharma 13 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
In which table does the Candidate Job Application Fields are storedSummary: Hi Everyone I have loaded the Candidate Job Application into the system using HDL. So I'm trying to fetch those loaded fields using SQL for verification. Conten…Sujeeth Chinta 513 views 4 comments 0 points Most recent by Emerson Oliveira Reporting and Analytics for HCM -
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
Absence Balance Report Based on Balance Calculation DateSummary How to get the absence balance to include future dated absencesContent In the existing report, balances are reflected as of today; however, would like it to refl…User_2025-01-28-20-43-56-568 1.6K views 20 comments 3 points Most recent by Gaurav Bhardwaj Reporting and Analytics for HCM -
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 1.8K views 26 comments 1 point Most recent by User_U58AH Reporting and Analytics for HCM -
BI Report access issueSummary: Hi, One of the users is unable to access the BI report. When he tries to access it, he getting the error shown below. But, he is able to access the report from …DHILNA P 3 views 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM
-
OTBI output is different for 2 different usersSummary: Hi, We have a custom OTBI report which is scheduled to send report to the Business Users. This report shows that 100 employees have missing family contact infor…Sailajad 22 views 8 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM -
Issue: Unable to expand Calculation Components Detail folder in Payroll - Calculation Cards Real TimSummary Users building reports on Calculation Cards Subject Area when try to expand Calculation Components Detail folder, the folder doesn't expand. Solution is provided…Tanvi Jain-Oracle 121 views 1 comment 2 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
View Reports and AnalysisSummary: View Reporting and Analysis on the Cloud Help Center Content (please ensure you mask any confidential information): There used to be a link for Reporting and An…AVorster-Oracle 25 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Report to say if employee has any direct reportsContent Hi, have a simple report that says something like PERSON NUMBER | Name | Department. I need to add an additional column that returns yes/no for if that employee …Mike Borghoff 134 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Email Address FormulaHi Everyone, I am building a report for one of our HR partners. She is using the report as a file loader to put employee data in an external employee recognition platfor…
-
Facing " There is no data to process" in BIP reportSummary: Facing the error " [INSTANCE_ID=bip.bi_server2] oracle.xdo.servlet.scheduler.ProcessingException: There is no data to process" in BIP report and there is bursti…