Reports
Discussion List
-
Fusion Data Intelligence - Data inconsistent across delivered workbooksSummary: After converting workers, I tried running the delivered workbooks. I am getting different data in them. The Team composition overview shows a total headcount of…JaspreetKapoor 15 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
SQL query to retrieve earnings and deductionsSummary SQL query to retrieve earnings and deductionsContent Hi Experts, I'm designing a balance extract that needs to fetch pension deductions 403. To create the data g…Aloka Bhattacharya 2.9K views 7 comments 2 points Most recent by Shubham Kadam Reporting and Analytics for HCM -
OTBI HCM Workforce Profiles and Counts (counts returning O's only)I thought this would be simple OTBI report, but am stuck on getting an accurate count (returns only zeroes). It should output active Profiles, their associated Job Codes…
-
Report SQL parameter filter in DataModel dont show in Dashboard PageReport SQL parameter filter in Data Model dont show in Dashboard Page Dont show in Dashboard Page In Report showFERNANDA SANTOS 11 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Requirement for HR users to modify copies of reports for their useSummary: We have a client requirement for HR users with certain roles to be able to copy existing reports and then modify them for their own use cases. Content (please e…Alona Aronov-Oracle 21 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Reference Variable in text column of a reportSummary: So, creating some reference variables in excel variable sheet that do not exist in EPM. Can I reference these in text rows / columns using text formula in a rep… -
Can a ESS job have 2 different BIP report layout which will execute 2 different queriesSummary: We have a requirement wherein client is expecting one ESS job will execute different queries based on parmater and both quries are having different report layou…essdee 17 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
Why would a report not reflect the updated data model?We had an issue wherein the report did not reflect the updated data model. The fix was then to duplicate the report itself without any changes. The duplicated report the…Hazelle 90 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Time out setting in Data ExchangeHi team! We have a situation that it was timed-out in Data Exchange but the report job is still running in Oracle GL. The data load rule runs a out-of-box report in Orac…GaryYip-Asc 11 views 2 comments 0 points Most recent by GaryYip-Asc Profitability and Cost Management
-
Displaying Accounting Period parameter LOV in expandable hierarchical manner when running FRS ReportThe business' FRS report currently has their AccountingPeriod parameter set to only query years, which is causing issues when they're trying to query years with periods …
-
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.User_S5U61 29 views 1 comment 0 points Most recent by Vighnesh Khade Reporting and Analytics for ERP
-
Set last year as default value on BIP parameterSummary: Content (please ensure you mask any confidential information): I have a BIP report with parameters. One of parameters is year. I know that last day of last year…Stefano_Mazzocca 11 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Specific user assigned with Payroll Administrator cannot view the Reports tab in UI Dashboard.Hi Experts, Does anyone have experienced that there is a specific user which was assigned by Payroll Administrator role but cannot view the Reports tab when clicking the…
-
Is there a way to suppress the label from repeating in consolidation journal reports?Summary: In the consolidation journal report, the label repeats for each row. Is there a way to suppress this like you can do in forms or Smart View? Content (please ens…
-
Link to BIP report in Compensation Worksheet Information not passing parametersSummary: We've created a BIP report with additional information for managers and have created a URL so the managers can trigger the report from the worksheet. We've been…Daan Beumer 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Lalit Sinkar 366 views 6 comments 0 points Most recent by Dairy Land Reporting and Analytics for ERP
-
Asset Rollforward Report ExamplesSummary: Looking for any fixed asset rollforward report examples or suggestions. Content (please ensure you mask any confidential information): We were hoping to create … -
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 3.8K views 13 comments 0 points Most recent by oqyjt Reporting and Analytics for ERP
-
BIP Report to Track “Synchronize from Position” UpdatesSummary: Hello, Is there a BI Publisher (BIP) query or report that captures all attributes updated by the “Synchronize from Position” action on a daily basis? Any pointe…Explorer 23 views 2 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Drill down on balances in SA General Ledger - Transactional Balances Real TimeSummary: We have created a an OTBI analysis using SA General Ledger - Transactional Balances Real Time. The purpose of the report is to show balances per natural account…ERP & EPM Cloud 21 views 0 comments 0 points Started by ERP & EPM Cloud Reporting and Analytics for ERP
-
Need to know DB table for BIP report history 'Output and Delivery' sectionHi team, We need table name to build report to extract 'Output and Delivery' (highlighted in orange box)from BIP report history, any help is highly appreciated. Regards,…Kalpesh Salunke-Oracle 21 views 2 comments 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center
-
Receiving error FCCS_YTD is not a store type member of the View dim when running Journal ReportSummary: Receiving error when running Consolidation Journal report 'FCCS_YTD is not a store type member of the View dimension. Only members which are store type and leve…
-
How to give access to Report Job History (scope all Histories) without BI Admin roleSummary: How to give access to Report Job History (scope all Histories) without BI Admin role Content (please ensure you mask any confidential information): Version (inc…Sonali Sethi 24 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
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 353 views 10 comments 0 points Most recent by SudiptaDey-Oracle Reporting and Analytics for HCM
-
Need Approval status report in FCCS like Data Process Control of HFMSummary: Need Approval status report in FCCS like Data Process Control of HFM Content (please ensure you mask any confidential information): Hi All, In HFM application, …DISHIL SHAH 13 views 5 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close
-
Extract the customer credit limit detailsSummary: We have requiremnet to extract the customer credit limit details. Content (please ensure you mask any confidential information): We need a report or query to ex…Mamdouh Ahmed 28 views 1 comment 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for ERP
-
Query to return employees related to a particular Representative type for a given AoR and scope of rSummary Query to return employees related to a particular Representative type for a given AoR and scope of responsibilityContent Hi All, Please share Query to return emp…