Reports
Discussion List
-
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 32 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 572 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 13 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 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 22 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 43 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.2K 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 214 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…