Reports
Discussion List
-
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 21 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 14 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 12 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 626 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 96 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 32 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 131 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 546 views 3 comments 0 points Most recent by Karim Ahmed Abdallah BI Publisher Learning Center -
Assistance Needed for Extracting Users from Oracle HCMSummary: I need help with extracting user data from Oracle HCM, including active and inactive users, email addresses, start dates, end dates, and associated roles. I’m e…
-
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…Monica Fundak 43 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to fetch Import errors for Project tasksSummary: Where Import errors for Project tasks will get stored .W e dont see them in PJF_OPEN_XFACE_REPORT table and PJF_TASK_ERRORS table after import run. Content (ple…Lakshmi Bandlamudi 192 views 7 comments 0 points Most recent by Venkat Patlola-Oracle Project Management
-
Need different font color for different Bar in Waterfall chartSummary: Need different font color for different Bar in Waterfall chart Content (please ensure you mask any confidential information): As shown in screenshot, starting b… -
FND_FLEX_VALUE_NORM_HIERARCHY is not available in fusion. Please suggest the replica table in FusionSummary: We have DWH implemented and as part of cloud transformation we are migrating from EBS to Fusion Cloud ERP. Hence, from DWH perspective, we are in process of ana…
-
Unable to access the Standard Invoice screen from the OTBI Action Link ReportSummary I am trying to navigate to the Standard Invoice Screen from the custom OTBI Report via Action LinksContent Hi , I had created a custom report with the Payable In…SandeepPaspunuri 181 views 16 comments 1 point Most recent by Joanne Heathcote Reporting and Analytics for ERP -
Rest API for Role Assignment report without Service Admin RoleWe perform Quarterly Access review on our FCCS Application, run the Role Assignment Report and send it to our reviewers. We are attempting to use an application called S…Shravan446 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close