Reports
Discussion List
-
OTBI analysis about Learning CommunitiesSummary: OTBI analysis about Learning Communities Content (please ensure you mask any confidential information): Hello experts, we need to create reports about the learn… -
How to perform drill-down directly within an Oracle PBCS report?Hi, I’m working on Oracle PBCS in the Reports section and I was wondering if it’s possible — and if so, how — to enable drill-down functionality directly within a report… -
OTBI Prompt returning wrong DataWe are creating a report in OTBI using subject area "Maintenance Management-Work order performance Real Time". Select Work Order Priority in Data as well as Prompt. In D…
-
Is there a PVO (or combination of PVOs) that returns the accounting status of a Payables invoice?I need to return the accounting status (Accounted, Partially Accounted, Selected, Unaccounted) for a specific AP invoice but using PVOs. The column "ApInvoicesPostingSta…
-
Add a Column with a Static Value in OTBISummary Trying to add the same value to all records, i.e. add a dummy column that holds a static fieldContent In OTBI, I need to add a column to a report that doesn't ne…Lisa G. 751 views 6 comments 0 points Most recent by Alex Pagliarini - Ninecon Reporting and Analytics for HCM -
What Lease Accounting table stores lease term?Hi, Lease Accounting UI has Lease Term in addition to Lease Start Date and Lease End Date. I am not finding Lease Term, which table is this in? Screenshots below:jess-izumi-234 31 views 5 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Lease Accounting
-
Need to Fetch Last Updated Records in ess_request_history tableI’m building a report using the ess_request_history table, where I need to fetch incremental records based on a timestamp filter. However, I couldn’t find a 'last update…
-
FCCS Report - Rest API - How to trigger?Summary: I have the reports under Library in FCCS. Is it possible to execute this report using REST API or EPMAutomate? I tried to use rest API URL "https://mikcons-test…
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 579 views 8 comments 0 points Most recent by User_K7YG4 Reporting and Analytics for ERP -
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 147 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 32 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 Most recent 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.3K 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 266 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): I have the attached query. Everything works just fine without the fina…Stefano_Mazzocca 11 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM