Reports
Discussion List
-
Calculate revenue % distribution for each project with in Business unitSummary: We have the below requirement Project1 Revenue amount-20 project2 Revenue amount-30 project3 revenue amount-16 Total BU revenue amount 66 (this is achieved by e… -
List of All Tables for Oracle Fusion ERP in PDF FormSummary: We need to have a List of All Tables for Oracle Fusion ERP in PDF Form along with its corresponding descriptions Content (required): We need to have a List of A…Gene Garcia 2.3K views 13 comments 0 points Most recent by Agnes.Ramos Reporting and Analytics for ERP
-
Unable to create a new Application Page Entry for a BI ReportSummary: Unable to create a new Application Page Entry for a BI Report Content (required): We are trying to create a page entry to open a BI Report. Used the Application…Bhargava Varma G 51 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Table name which stores start date and end date in individual compensation planSummary: Hi Everyone! I am looking for the table name which stores start date and end date in the individual compensation plan. I tried - cmp_plans_vl, cmp_components_vl…
-
Seeing Data Across Different EnvironmentsSummary: Viewing data across different environments inconsistent. Content (required): When I run a report, we created in Dev11, there some data that I don't see in our U… -
Seeded line manager dashboards for executive leadershipSummary Dashboards for executive leadershipContent We have made a copy the of seeded line manager dashboard and modified it to work with our system configuration and req…User_2025-02-10-08-27-16-805 102 views 12 comments 0 points Most recent by Deborah A Reporting and Analytics for HCM -
Can we extract import project errors using custom BIP report?Hi, We are using FBDI to import projects in Oracle PPM Cloud. As per our observation, projects interface table PJF_PROJECTS_ALL_XFACE is getting purged automatically onc… -
How can we limit access to reports residing in delivered (out of the box) folders?Summary: How can we limit access to reports residing in delivered folders? Most of the users have access to BI roles (Consumer/Author/Admin) inherited through other role…
-
How should I calculate the employee's seniority?Hi, I have a query where I calculate the seniority of the employee and I want to sort by the highest seniority. The query works like this if the 'Seniority Reference Dat…Cansel Karasoy 41 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Lease Accounting ERD diagramSummary: We want to create custom BIP reports based on Cloud Lease Accounting tables found here (https://docs.oracle.com/en/cloud/saas/financials/23b/oedmf/index.html). …
-
Audit Log for ReportsSummary: If there an audit log for all changes made to reports in Reports? Content (required): In FRS, although there was not an audit log, we could leverage the last up…Casey Kempel 71 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Does OTBI report follow Data Security enabled for usersSummary: Does OTBI subject areas enforce the Data Security Context values that have been assigned to users. For example, a user has been assigned one BU and One ledger, …
-
Hide data on charts from "Reports"Is there a way to hide data on charts from a Report. The below yellow highlighted box has numbers but it's overlapping and looks bad. is there a way to get rid of all da…User_2025-03-10-22-57-31-218 41 views 2 comments 0 points Most recent by User_2025-03-10-22-57-31-218 Planning
-
how do I define datesSummary: I am trying to fun an agent weekly and want to have it select a date range Content (required): the job will run every Friday morning and needs to include employ…
-
Open/filled position management reportingSummary Delivered Position Incumbents report returns terminated employeesContent Hello - There's a requirement to create a report of all current filled/open positions wi…
-
Any Suggestions of how to improve Web Clock Custom Dashboard data reflection earlier.Summary: We are facing a time-lapse on Custom Dashboard which has reflected the data in delay some time especially in web clock in and out table records. we need a worka…
-
Need to know Progress Summary Reason Table/Subject area nameSummary: Need to know Progress Summary Reason Table/Subject area name Content (required): We are unable to find Progress Summary Reason field either in the Recruiting - …Visu 41 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Need help - Need a payroll report for Element vs BalancesSummary: We need to create a report to include Element names which are feeding a particular Payroll Balance. We tried to do it using Payroll Subject Areas but it did not… -
how to change columns as rows in below requireimentSummary: Hi Team, In OTBI how change annual accrual and carry over coulmn into row we need . Any one help me on ? Content (required): Version (include the version you ar…AjayKumar Maddipati 81 views 20 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
We need Work Schedule Name, Work schedule start date, Work schedule End date on OTBISummary: Hi Team, we looking below columns in OTBI subject areas May i know which subject area available? Thanks, Ajay Content (required): UI: Version (include the versi…AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Phase Sequence Number doesn't match CSPSummary: Phase Sequence Number doesn't align with the CSP we've defined. Content (required): We have defined candidate selection phases for our job application progressi…Rob F 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Consolidation - which ledger need to upload Historical RatesSummary: Consolidation - which ledger need to upload Historical Rates Content (required): Business case: Ledger 1: GBP Ledger - Transactions in GBP. Ledger 2: Created Re…Kumar 57 31 views 1 comment 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close -
Report template issueSummary: We have created Welcome mailer template in XSL format and when tested in TEST and DEV2 environment, it is working absolutely fine. But when deployed in PROD - t…
-
Agent not sending report to application roleSummary: We have selected Application roles as the recipients for the scheduled agent, but the emails are not sending to anyone in these roles. However, If I list an ind…THawkins_LGI 21 views 2 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
In BI Report we getting dupilcate records as per ui but we need only one recordSummary: HI Team, We have exist interview survey status report but we getting dupliacte reocrds nearly 700plus. due to report takes as per ui but in ui some of employees…AjayKumar Maddipati 31 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Tax Witholding ReportSummary: I need help creating a report showing which employees are claiming exemption from the tax witholdings. More specifically, which employees are claiming exempt. I…Greg Rank 41 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to compare Salary Minimum to Grade Rate MinimumSummary: I have an Analyses that uses Compensation - Salary Details Real Time and Workforce Management - Grade Rate Real Time subject areas. The requirement is to compar…JHaden3 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to migrate BPM workflow notification customization to another instance?Summary: How to migrate BPM workflow notification customization to another instance? Content (required): Hi All, I have customized the BPM termination approval email not…Venkatesan 51 views 5 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for HCM
-
OTBI folder and column name Contract InfoSummary: Content (required): Hello, do you know in which folder or the column name in OTBI for the highlighted columns (Contract Info)? Kind Regards, Valerio Version (in…Valerio Curzi 51 views 8 comments 0 points Most recent by teresa.marciano Reporting and Analytics for HCM