Reports
Discussion List
-
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 42 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 22 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 32 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 -
Extend SQL Query Timeout Interval for BIP Data ModelsSummary: Extend SQL Query Timeout Interval for BIP Data Models Content (required): We would like to understand if the "Server Value" for "SQL Query Timeout" parameter ma…ks1075 1.2K views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Unable to join Invoice and Procurement Subject Area in OTBI AnalysisSummary I have a requirement to fetch the Purchase order details with corresponding invoice details. Therefore i need to connect two subject areas to fetch the required …Santosh V-228136 659 views 8 comments 0 points Most recent by Khassham Khan Reporting and Analytics for ERP
-
Copying personal custom Dashboard to Shared Folder > Custom > Dashboards throws Error Codes: QM3V3HSummary: Moving a personal dashboard to shared folder throws error Content (required): User has a custom Dashboard created in My Folder >Dashboards They want other users…Service Desk Claremont 43 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Setting Access Role to DashboardSummary: I am needing to add access to a Dashboard to a certain role, but the role I want isn't an option in the dropdown. Content (required): I have created a dashboard…Aaron Reynolds 101 views 2 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
How to show and hide BIP parameters dynamically based on the login UserSummary: How to show and hide BIP parameters dynamically based on the login User Content (required): We have different parameters and few parameters need to display base…Visu 626 views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
How to take Department head and Business Leader information from AOR?Summary: How to take Department head and Business Leader information from AOR? Content (required): Hi All, From which tables we can get Dept head and Business leader inf…