Reports
Discussion List
-
Report for getting shift overlap or shift with open end dateSummary: Report for getting shift overlap or shift with open end date Content (please ensure you mask any confidential information): Hi Team, Greetings! If anyone has an… -
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull…Sujeeth Chinta 152 views 11 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Requirement to have 7 buckets in Customer Statement reportSummary: Client requires 7 buckets in Customer Statement Report. We have defined a statement aging method to have 7 buckets but only 5 buckets are visible in the report …Anand Kandasamy 7 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP -
Reports text grid into ExcelSummary: Hi Team, When we try to download reports into Excel, the Text Grid is being exported as an image. However, we need it to be exported as text. Does anyone have a…
-
What table stores the system transactions reference number for Bank Statement (CE) reconciled itemsSummary: We are attempting to replicate the Cash Management Bank Statements>Manual Reconciliation page>Reconciled tab in a custom OTBI Report. For system transactions li… -
Lease Amortization Schedules Extract - How to create an IFRS schedule based on ASC842 schedule?Summary: Our client only has ASC842 schedule enabled and would like to have an IFRS schedule. We would like to utilize Lease Amortization Schedules Extract to create the…
-
Display member name instead of alias in causality for exceptionIn the causality for exception use case, currently i am getting the member alias names for the top contributors. I also tried changing the same for the account to point …
-
custom US Cheque Report repositioning when printed to a copierHi, I have built a custom US Cheque Report based upon Oracle's seeded US report. I am having issues after a test payroll is ran and converted to pdf and at that point th…
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha…Clifford Trett 322 views 15 comments 4 points Most recent by Namrata_20 Reporting and Analytics for HCM -
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 702 views 8 comments 0 points Most recent by Surya_TejaS Reporting and Analytics for HCM -
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…Dasari Dileep 352 views 9 comments 0 points Most recent by Converse_with_OraEnthu Reporting and Analytics for HCM
-
Grouping data in Excel TemplateSummary: I am trying to group data in my Excel Template. Every employee has 2 annual leave plans. This is how the data currently display when I group by G_1. I want to g…Consultant Ian 41 views 6 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Balance Feed Usage DetailsWe are conducting a review of all balance feeds and associated elements and element classifications, in a effort to ensure we have all elements mapped to the appropriate…
-
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…Visu 1K views 2 comments 0 points Most recent by Janhavi Kulkarni-Oracle Reporting and Analytics for HCM
-
difference between legal employer hire date and enterprise hire dateSummary difference between legal employer hire date and enterprise hire dateContent Hi, Please find attached screenshot of Manage Work Relationships for a person: 63060.… -
OTBI report has increased massively since 26BHi, A report that was taking 9 seconds to run is now taking 706. This is since 26B came in on Monday. I will attach the report xml, and I have run a Performance check us…
-
Is there an easy way to pull all the notifications enabled in the systemSummary: Is there an easy way to pull all the notifications enabled in the system. Content (please ensure you mask any confidential information): Is there a way we can p…AnushaGarikipati 21 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
how to send the zip files and PDF files as attachments in the email through the bursting bip reporti have requirement to send the zip files and pdf files as attachments in the mail through Bursting report, is there a way to do this? please let me know
-
How to Review Future Scheduled Lease Liability and Amortization AmountsI would like to ask about the Lease Transactions and Balances Report in Oracle Fusion Lease Accounting. Our understanding is that this report outputs only the amounts fo…
-
Fetch the BIP report Scheduled output bursting detailsSummary: I need to fetch the details like , Output name, Template, Format. is there a table to fetch this details of the scheduled output ? Thanks for the help in advanc…Vishal Purohit 32 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
FCCS Reports in Books does not show POV.Summary: Some of the reports are missing in EPM books. debugging more I realize some reports does not show POV in books. Not sure why it is happening to some of them. I …Divya_Masoodi 12 views 1 comment 0 points Most recent by Divya_Masoodi Financial Consolidation and Close
-
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 (…