Reports
Discussion List
-
Need to calculate Age in BI AnalysisSummary What is the formula needed to calculate age within a BI Analysis?Content I am trying to complete a report to calculate the age levels of employees. I pulled in h…User_2025-01-28-20-43-56-568 206 views 6 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju.Naga raju Ibba 365 views 4 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Export entire dashboard from a custom pageContent Hi Guys, I see that is possible export the entire dashboard from the OTBI by clicking on the Option export to excel. But, my question is: Is it possible export t…Giuseppe Iacono 219 views 18 comments 3 points Most recent by User_VLBBP Reporting and Analytics for HCM -
BI Publisher Bursting Email from Company Domain IDSummary: Hello Experts, We have a requirement to trigger emails from our company domain ID (@companyname.com) while triggering emails from BI Bursting. We don't want the…Gourabh Choudhary 172 views 3 comments 0 points Most recent by Gourabh Choudhary Reporting and Analytics for HCM
-
Reporting the Career Development screenHi, I want to generate the data sql report on the My Team>>>Career Development screen. But I can't find the table where this information is kept. Can you help and share?…Cansel Karasoy 62 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Consolidate information or Reports for LeasesSummary: Lease Accounting Consolidate Report Content (required): Hello Team We have multiple business units which are using lease accounting module. We are looking for b…
-
Passing parameters from a UI page to html opening BIP Report doesn't work anymoreSummary: Passing parameters from a UI page to html opening BIP Report doesn't work anymore Content (required): Hello Experts, I'm facing an issue when passing a paramete…Dario_DiFranceschi 52 views 4 comments 0 points Most recent by Dario_DiFranceschi Reporting and Analytics for HCM
-
PCMCS Query - Exporting data using epmautomate with "," as delimiterSummary: Exporting Data from PCMCS using epmautomate exportQueryResults Content (required): Hi, I am trying to export data from PCMCS using a query using epmautomate exp…Amit Agarwal-158816 62 views 7 comments 0 points Most recent by Amit Agarwal-158816 Profitability and Cost Management -
Ledger Currency are null on some payments in Analysis Payables Payments - Disbursement Real TimeSummary: Ledger Currency are null on some payments in Analysis report using the Payables Payments - Disbursement Real Time subject area. Content (required): Is there a w…
-
Parameters used to run the BIP report is not reflected in the HistorySummary: We have other reports where in the parameters are shown on the history. We don't know what's the difference with this specific report why it doesn't show the pa…
-
Where to find employee W2 Box 1 and Box 5 Data?Summary: I have a report request for employee's W2 box 1 and box 5 values. Content (required): W2 Data in Oracle Fusion HCM Version (include the version you are using, i…
-
Is there a User Activity Report?Summary Is there a User Activity Report?Content Looking for a report or way to see how often user(s) login to Core HR system. Any reporting or functionality capable of t…
-
Need table name to fetch 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen.Summary: Dear Experts, Which table stores the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached Screenshot for your reference. Than…
-
Suppression in Reports vs Financial Reporting StudioComparing "Suppression" between On-prem Hyperion Planning Financial Reporting Studio and Oracle Planning cloud, New generation "Reports". Can someone confirm me if "If M…
-
Can we build a single report for BIP or OTBI and then restrict columns for different users.Summary: We have a requirement to build one report and then send it to multiple users with different combination of columns. Content (required): Hi Team, We have a requi…Vikas V. Kamat 52 views 9 comments 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM
-
Duplicate Departments when using Goal Status Overview Real Time Subject AreaSummary Duplicate Departments when using Goal Status Overview Real Time Subject AreaContent Hi Experts! Good day! We are having issues with duplicate departments. Is the…Raymund Jerome 43 views 5 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM
-
Need the know table and field name for enterprise contract page to prepare BI reportSummary: I need to prepare BI report on Enterprise Sell contract as per client requirement. Please let me know the how to identify the behind table name on Billing and F…Manivannan V-Oracle 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
What can we do so that OIC applications do not use license limits?Hi, What should be done to prevent the versions created for the live and test environment from using license limits in the applications we develop in the OIC environment…Cansel Karasoy 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Formula for sum up in specific conditionSummary: Hi, I want to create a formula that will sum up the values in other rows if those values are less than 3000. I've created the formula in Excel, please check thi…
-
Position hierarchy report prepared from Oracle AnalysisHi, I am preparing a position hierarchy report using an analysis report. How can I find the person in the next position of a position? RegardsCansel Karasoy 51 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Agent - would like to see why it failed to runSummary: Is there a way to see the reason for an Agent's failure? Content (required): When an Agent fails to run and deliver an Analysis, we can see that it Failed (unde… -
Question on Approval Groups ReportSummary: - How is a delegation visible in the system – will it show on that approval group report? Will it be indicated whether a member of the group was delegated vs co…Abhilash K - Deloitte USI 41 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Is there an option or XDO function to print country name using Country code?Summary: Currently, Client is using a DFF to capture country code for Invoices when the payment is made for a foreign professional. These are of type Payment requests an…Abhilash K - Deloitte USI 21 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
List of BIP Reports FTP/ESS JobsSummary: List of BIP Reports with FTP/ESS Jobs Is there any query or report that provides a list of all BI Reports which include FTP/Bursting enabled or registered as an…
-
How do I configure report to get accumulative data of PnL account?Summary: I have a problem while I configue FCCS report to get accumulative data My fiscal year from Jul-Jun, I want to see accumulative PnL data in monthly, quaterly, ha… -
How to Automate the reports using Task Scheduler?Summary: We created a report bursting through EPM and executed the report using EPM Automate on the client server. How do I schedule the reports in the Task Scheduler? W…
-
Limiting access to folders in custom folderSummary: We want to provide access to only expense folders to expense auditors/expense managers within Custom/Financials and to AP Managers to AP folder and so on. AP Ma…Dibyanshu_Shekhar 32 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
Valid Grade Report-Multiple Grades on jobs auditSummary: We are trying to run a report on all the active valid grades associated with a job, to audit and clean up any that may have multiple grades associated with the …Tammy Hemmingson 41 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
PPM Contracts - How to setup new roles on the Parties LOV tab ?Summary: PPM Contracts - How to setup new roles on the Parties LOV tab ? Content (required): Hello We have the contracts module and on the parties tab , there are only t…
-
Query to fetch project actual cost accounting statusSummary: In my BIP report I'm trying to fetch the accounting status of the project actual cost. Content (required): Version (include the version you are using, if applic…