Reports
Discussion List
-
How can we track which users have executed an Oracle Fusion BI Publisher report from the catalogSummary: We want see the Report details who ran from catalog. is there any tables which stores that info to extract. Content (please ensure you mask any confidential inf…Sreekanth Kandula 37 views 7 comments 0 points Most recent by Sreekanth Kandula Reporting and Analytics for HCM -
Lease Accounting - CWB + Test Scripts + Business Process ModelSummary: Lease Accounting - CWB + Test Script + Process Flow Content (required): We are looking at replacing our legacy system for Lease with Oracle Lease Accounting, an… -
Query to fetch Cost Center Details which are not mapped at Department LevelSummary: i need a query to fetch all cost center which are not mapped to the department. If anyone have SQL query please help me. Version (include the version you are us…
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
Hide column/s of an FRS ReportSummary: When FRS Report parameters are entered and report is run, I need column/s which give all blank values to be hidden. How can this be done? Content (please ensure…
-
Intercompany Elimination before the Data load in FCCSHello Everyone Is it possible to use an intercompany matching module in Oracle FCCS where transactions are matched first and then entity loads the ICP partner data in ER…Bhavishya Edula 28 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS – Rounding to Millions Causing Parent-Level DifferencesHi, We have a requirement to report values in millions with rounding. We implemented this by creating a member named as "DS Millions" in the data source dimension and de…JyotiSharma 41 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
BIP report Pivot filter not functioning as expectedSummary: Running an online layout for a pivot date from a data model doesn't properly filter null dates Content (please ensure you mask any confidential information): Fo…Marko Puskac 11 views 2 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
FCCS: Change Signage of Account Types according to Source SystemSummary: We would like to know about the Impacts/Challenges of applying the customize signage for Asset/Liabilities/Equity/Revenue/Expense which aligned with ERP signage…Karan Varshney 212 views 7 comments 0 points Most recent by Joost Mellegers Financial Consolidation and Close
-
PerformanceGoalRespApprovalNotificationReport not returning data after passing the transaction_idHi Team, Experiencing issues with the seeded notification (PerformanceGoalRespApprovalNotificationReport) triggered for manager approval when a worker adds, updates, or …Shivani Nakade 17 views 0 comments 0 points Started by Shivani Nakade Reporting and Analytics for HCM
-
bip report to get the approval history and status and also future approversSummary: Hi Experts bip report to get the approval history and status and also future approvers if the task is in progress. Any sample report sql query can you please sh…MudshaikhMub 18 views 5 comments 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
Request for SOC1 Reports for Oracle Financial Consolidations and CloseE&Y auditors are looking for the SOC1 reports. Can someone please point me in the right direction?Ashley Pfeiffer 20 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Report to track payroll entries transferred to SLAContent Hi, Is there a way to track the payroll costing entries which are transferred to SLA. We have a situation here where finance has confirmed that the totals in the…User_2025-01-31-01-09-06-877 46 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to pass custom BI Publisher parameters (p_start_date, p_end_date) from HCM Extract than and HDLSummary: Hi everyone, We have a requirement to run a parameterized BI Publisher (BIP) report from an HCM Extract and then auto‑load the generated HDL file. The report us… -
Query to fetch Transaction console entries along with multiple Approver detailsSummary: Need a Query to fetch Transaction console entries along with multiple Approver details Content (please ensure you mask any confidential information): Version (i…NagasaiM135 17 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Data Not visible in Financial reports but able to see data in smartview for the same POV in FCCS appThis basically happened when i did a metadata load and refresh database then i suddenly loose data in Financial Report but can see the data in Smartview with the same PO…Shahnawaz 31 views 8 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close
-
How to split EPM Financial Reporting (Reporting) AliaseName using Delimiter featureSummary: Hi, we have specific requirement where MemberAlias Name to be split based on Delimiter in EPM Financial Reports (Reporting). Ex: PRODUCT Alias Name 1233444 1233…
-
Security for OTBI Subject Area "Projects - Labor Distribution Costs Analysis Real Time"Summary: We need to expose OTBI queries written against the subject area "Projects - Labor Distribution Costs Analysis Real Time" to a larger population. Right now, it i…Jonathan Ruth 21 views 2 comments 0 points Most recent by Jonathan Ruth Reporting and Analytics for ERP
-
Does BIP reports support docuSign?Summary: Content (please ensure you mask any confidential information): In this discussion it seems docuSign is not supported for BIP reports. Can someone from Oracle co…Stefano_Mazzocca 1 view 0 comments 0 points Started by Stefano_Mazzocca Reporting and Analytics for HCM -
FCCS Report round off issuesI am facing round off issues with FCCS MR reports. I have given the samples values in the attachment. Please check. The decimal places is not enabled in the report and u…AravindhK02 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Lease amortization to be posted to different GL account from Lease RevenueOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): Currently Lea…
-
Is there log available in FCCS to identify whether any change was done to audit trail configuration?Summary: Is there log available in the FCCS application to identify whether any changes were done to the audit trail configuration, please advise. Content (please ensure…KC-2109 11 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to search for future approvers in an approval process in Oracle HCM Cloud by query?Good morning! How are you? I have a question, exists any VIEW objects or table (Im creating a bi publisher) that I can use to get the information of all the approvers of…
-
ICP Matching Report CustomizationHi everyone. Is there any way to modify the ICP reports in order to create new columns, for example to include comments or notes, as well as additional dimensions? The i…Mayela Vega Duque 14 views 1 comment 0 points Most recent by Anand Thota Financial Consolidation and Close -
Need to get referrer Job Title and Referrer assignment status in OTBISummary: We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker p…Rama123-Oracle 12 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
While loading worker dat file, getting error the error for PersonLegislativeDataSummary: While loading the worker dat file getting the below error for PersonLegislativeData component You can't update this record because the SourceSystemId {SRC_SYSTE…Gali Sujana 112 views 4 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Date changes by1 day while formattingSummary: Hi, I am using Oracle template builder for one of my reports which has date column, when I apply date formatting date changes by one day (example: 4712-12-31 ch…Eshwar Kappala 1 view 1 comment 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
RTF for Supplemental Data reportsHi Experts, Does anyone know if there is a place where the Task Manager .RTF templates can be downloaded or reviewed, so that we can use them as a reference to create te…Mayela Vega Duque 2 views 0 comments 0 points Started by Mayela Vega Duque Financial Consolidation and Close
-
Book Prompt Member AliasSummary: Hello, I created a Book within Planning that is the combination of two reports in Planning. Both reports have a Prompt for a specific Dimension and both are cur…