Reports
Discussion List
-
Accruals on Payroll Activity ReportSummary: Payroll Activity Report is pulling PTO Accruals as of Inception to Date for Rehires which is incorrect. Content (please ensure you mask any confidential informa…Ayesha Islam 11 views 2 comments 0 points Most recent by Ayesha Islam Reporting and Analytics for HCM -
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to get the Individual COA Segment Values based on the security rules defined for the Role…Vinay Gharge 146 views 5 comments 2 points Most recent by Abhisek Choudhury Reporting and Analytics for ERP -
Is it possible for BI Publisher to read from external Excel file?Summary: Content (please ensure you mask any confidential information): We'd like to integrate Oracle data with an external Excel file stored in a shared location. Such …Stefano_Mazzocca 31 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Can we create BIP Report on Lease accounting Data from Fusion ERP? Since we do not have OTBI SubjectSummary: BIP Report using Lease accounting data from Oracle Fusion ERP. Content (please ensure you mask any confidential information): Version (include the version you a…
-
To optimize Run Deduction Report, converted to BIP report.Facing issue displaying Ded and Arrear colSummary: Payroll Run Deduction Report which Prior to 24A run times averaged about 30-minutes. Following 24A, run times increased to approximately 90-minutes. Proposed a … -
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont…
-
How to Implement FX Impact ReportSummary: We'd like to implement a report showing the impact of a change in the exchange rates. Content (please ensure you mask any confidential information): In our orga…
-
Why Are TEST and PROD Behaving Differently after Adding Workforce Confidential Reporting Data DutyWe have an urgent issue that we are looking to resolve. A team member informed us that she's unable to view Person Real Time subject areas details like emergency contact…G. Class-Peters 11 views 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM -
promt report oraxle PBCS-how to manage a single prompt on workbook openSummary: how to manage a single prompt on workbook open (oracle pbcs - report - prompt) Content (please ensure you mask any confidential information): Hi, We have create…FTufaro96 21 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
BICC PVO : Unmasked taxpayer id and Bank Account numberSummary: Looking for BICC PVO which return unmasked - Vendor Tax ID and Bank Account number from ERP. Content (please ensure you mask any confidential information): /bia…
-
Counting Questionnaire Responses from Performance DocumentSummary: Trying to count the responses to a question within a performance document. Performance is very slow and it's hard to validate the results. Content (please ensur…Rob F 41 views 3 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM -
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…User_SJJQT 7.1K views 5 comments 0 points Most recent by Tejeswar J E Reporting and Analytics for ERP
-
Need SQL query or table to get Worker details column under configure worksheet page layout.Summary: Hi, Need SQL query or table to get Worker details column under configure worksheet page layout in compensation We need the table where these highlighted(Yellow,…
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 146 views 2 comments 0 points Most recent by Palash Kumar Singh Reporting and Analytics for HCM
-
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …
-
How can I export all comments or notes entered through Note Templates during Inline Grid Entry?I’m able to view the comments in the Notes section of the application, but the interface isn’t user-friendly as I have to click “View” for each combination to see the en… -
When I add filter to query the report goes in timeoutSummary: Slow learning (WARF) query Content (please ensure you mask any confidential information): https://us.v-cdn.net/6034893/uploads/S9IJ8KIYKON0/learning-query.txt I…Stefano_Mazzocca 11 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM
-
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 41 views 7 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
Query to get Oracle GL COA Entity Segment, Oracle Legal EIN/TIN ,Oracle Legal Entity NameSummary: Hi Everyone, I need query to create a BIP report which fetches the Oracle GL COA Entity Segment, Oracle Legal EIN/TIN , Oracle Legal Entity Name. Thanks in Adva…
-
Is it possible to Drill through the Journal Data in FCCS?Summary: Hello, We are performing the Oracle Fusion and flat file data loads in FCCS Data Management. I wanted to know if drill through is supported for Journal Data ? H…Sirisha G 71 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
SQL query or Table for Allocation Methods under Configure Modeling in CompensationSummary: I need a table or SQL query to get Allocation Methods under Configure Modeling in Compensation. Table for below fields in highlighted box. Content (please ensur…
-
Parts of report being cut off when using multiple grids and viewing whole reportSummary: We have several reports which use multiple grids. We have found that these are now having parts of them cut off and not visible when viewing the report as a who…
-
Number to name conversion of currency value in RTF templateI have currently developed a BIP report using RTF template for a receipt voucher. It contains values in both Arabic and English. I would like to know whether there is a …Manu Krishna T M 25 views 1 comment 0 points Most recent by Ravi Tilekar BI Publisher Learning Center
-
How is the Threshold calculated in NR Reports to verify the maximum limit?We have a report in Narrative Reporting created with 1800 * 700 cells which is within the limit of 2000000 cells (As per NR Report Limit). Although the cells are within …
-
Virus scanner not reachable error when unarchive reportSummary: Virus scanner not reachable error when unarchive report Content (please ensure you mask any confidential information): My Client Groups > Reports and Analytics …Junade_Shujaat 122 views 2 comments 0 points Most recent by Junade_Shujaat Reporting and Analytics for HCM
-
How to handle null values while Summing in RTF TemplateSummary How to handle null values while Summing in RTF TemplateContent Hi Team, Please advise with syntax for to handle null values while Summing values in RTF Template …User_2025-01-29-00-33-34-534 1.1K views 4 comments 0 points Most recent by User_NPE6A Reporting and Analytics for HCM