Reports
Discussion List
-
Required Tables that stores min-max values for Replenishment planningSummary: As part of report development, we required min-max values for Replenishment planning. Please provide the details of tables that has to be used to derive the val… -
permissions to view only some reports by usersmy user should be able to see only Compensation and not the others. I have already created a role and assigned it but still nothing. I create this role and associate my …CamillaRossi 51 views 5 comments 0 points Most recent by Mohammed.Dawoud Reporting and Analytics for HCM
-
Sql query to get cost code effective start date and effective end dateSummary: Sql query to get cost code effective start date and effective end date Content (please ensure you mask any confidential information): Version (include the versi…Anup Karmankar 71 views 18 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM
-
adding different manager types to analysis reportsHello there, I have prepared a report from the analysis and in this report I would like to see the types of managers that people are affiliated with, such as head and ex…Sinem Kara 21 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Link Lease Accounting to General Ledger Journal Lines TableSummary: Hi, Trying to create a BIP report that pulls the lines from Lease Accounting (can be accessed via Lease Accounting module, Review Journal Entries from Tasks) to…
-
Need a report to pull time change request details for time and laborSummary Need a report to pull time change request details along with manager comments for time and laborUser_2025-02-04-07-00-18-658 44 views 3 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 544 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM -
Need to generate a sequence number in outbound file at BIP. How to achieve thatSummary: Need to generate a sequence number in outbound file at BIP. How to achieve that Content (please ensure you mask any confidential information): Need to generate …Ishtiaque AHmed 22 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Please Help with Audit approval QuerySummary: The auditor has requested the dates of the last updates made to our Audit approval rules for the following areas: Job Offer Job Requisition Approval Termination…Global Support Desk 11 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How can the seeded compensation dashboards below for managers be customized?Can anybody suggest the right way to edit these seeded dashboards and do the customization based on our company needs. The need is to Add/ remove parameters Add/ remove …Sameeksha MN 11 views 3 comments 0 points Most recent by Sameeksha MN Reporting and Analytics for HCM
-
Recommended Approach for Optimizing Reports with Conditional Suppression and Structural VariabilityWe are currently using the same reports for two reporting packages: Annual Report – A two-columnar structure. Half-Year Report – A three-columnar structure with a differ…
-
Burst Reports with Custom Email FromHi All The default email is no.reply@epm.oraclecloud.com for all our epm planning environments. If I'm bursting reports to various users its easy to get confused as to t…
-
How to add a deep link to items ?I have attempted to use the Deep Link SCM document to create a deep link for Items, but unfortunately, it didn’t work as expected. Could you kindly assist me with a step…
-
Can report schedule can trigger notifications based on the notifications triggered in last 24hours.Summary: We have a requirement, where 2 reports are developed. And the first report is triggered manually and for the second report scheduling is required. Is there any …Gowthami Gorantla 21 views 2 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Cost of absence sicknesSummary: Report to show cost($ amount) of employee leave balances Content (please ensure you mask any confidential information): Hi Team, We have developed a report for …Thomas Samuel19 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Display modification in SmartView ad hoc analysisIn SmartView ad hoc analysis, I want to display hierarchies in a way where the parent value appears first, followed by the child value. How can I change this setting?yuyano-Oracle 11 views 2 comments 0 points Most recent by yuyano-Oracle Reporting and Analytics for ERP
-
FDI format date field to MON-YYHello, In FDI I'm trying to format payroll action effective date as a period format 'MON-yy'. TO_CHAR is not a recognized function, I tried a CASE statement for WHEN Pay…
-
Extracts General Ledger Cube Balances - Error out as QUERYRESULTLIMITHi, From EPM application, ESS job "Extracts General Ledger Cube Balances" is called, which error out as below. Kindly let me know how to fix this issue. Error: Execution…Bharath Kumar Madupuru 610 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
PO PDF error printing attachments "Could not get data source connection for: FA_UCM_PROVISIONED"Summary: Getting error in PO PDF customization " "No such data source found in the data source config. Or you do not have access permission. Could not get data source co…Lucky Sharma 90 views 7 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
PDF available for Tables and Views for HCMSummary: Is PDF option available for Table and Views i see there is no option to download. Tables and Views for HCM Content (please ensure you mask any confidential info… -
How do you write a query for standard working hours in BIP?I need to get the standard working hours for employees into my query. I can see the standard working hours work is worked out in the following order : 'Standard Working …
-
Reports Relative Member of CurrentPOV -1 does not render Dec prior year if Jan is selected in POVWe have a Balance Sheet Report with the Period Dimension leveraging CurrentPOV in one column and Relative Member of CurrentPOV -1 in another column and then a variance c…
-
How do I define the dashboard prompt to include date range on the same columnSummary: Need help in defining the dashboard prompt to include date range on the same column, for example: date range on hire date and how to incorporate in BI Publisher…Surabhi Kumari 331 views 9 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 2.1K views 17 comments 22 points Most recent by cdreyer.de Reporting and Analytics for ERP -
Need a report which can provide details if any scheduled job runs and BI report run got missed.Hi Team, We have a requirement in place that if any report schedule and job schedule got skipped due to any reason then we need a BI or OTBI report by which we can track…Sanchit_Jauhari_2211 31 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to customize seeded Payment Register ReportSummary: How to customize seeded Payment Register Report Content (please ensure you mask any confidential information): Hi All, We got a requirement to add new columns i…Venkatesan 121 views 6 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Privileges to view reports in BI Catalog without access to transactionsSummary: Requirement for custom role only to access reports in Business Intelligence Catalog for all Procurement Functional Area folders Content (please ensure you mask …
-
Targeted Distribution File to Send to Some Users on Same EmailSummary: Content (please ensure you mask any confidential information): I have a Targeted Distribution File that sends different department reports to multiple users. Cu… -
OTBI to show future effective datesSummary: Hi Community, Please refresh my mind: how to make the OTBI to show future dates from EFF table? Thank you, Alvaro Couto Content (please ensure you mask any conf…Alvaro Couto 31 views 1 comment 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Sql query to get payroll process name Under a batch Name /Instance nameHi , I am looking for SQL table to get payroll process name currently i can get batchname/Instance name via below query : SELECT pfi.instance_name FROM pay_flows pf,pay_…Surbhigupta_88-Oracle 545 views 3 comments 0 points Most recent by Karim Ahmed Abdallah BI Publisher Learning Center