Reports
Discussion List
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3.7K views 21 comments 1 point Most recent by SangeethaSekar-Oracle Reporting and Analytics for HCM -
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.7K views 13 comments 0 points Most recent by JimCC 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 21 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 1 view 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 1 view 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…
-
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 332 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 12 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 21 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… -
Legend in Charts not appearing properly in Report PackageSummary: Legend in Charts not appearing properly in Report Package but if we open the chart from reports section it is looking fine. All screenshots attached. Legend nam… -
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 241 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Budget Planning Report: Row[1] Formula Affecting Text ColumnsHi, I've created a Budget Planning Form report and added a formula row for the "Grand Total" using the formula Row[1]. While the calculation is working correctly for the…
-
Is there a function to retrieve prompt value in report header?Summary: We have a requirement to show the prompt value in the report header. And the prompts are multi select so the users expect to see all the selected value, is ther…
-
Restrict sending attachment in email burstingSummary: We have a requirement that client does not want email attachment to go to the end user and should not be part of the mail body as well. We created a deeplink fo…Abhilash K - Deloitte USI 21 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
SQL query to get the result of Recalculate Payroll for Retroactive ChangesSummary: SQL query to get the result of Recalculate Payroll for Retroactive Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Ca…Parag Hiremath 11 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Suppress Outputs from showing under Output & Delivery after burstingSummary: We have a BI report that needs to be scheduled to run. The report will send multiple emails, and it also generates one output which contains summarized detail o…SarthakRohilla 13 views 0 comments 0 points Started by SarthakRohilla Reporting and Analytics for ERP
-
Audit Reports usage in FCCSIs there an easy way to audit FCCS (or Planning) reports usage to identify when and which users executed the reports in a specified interval of time (say last 3 - 6 mont…SH01 31 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Hi Team,Summary: I have a requirement- Rehire scenario — Inactivate journeys for the previous terminated employment via inbound integration (HDL). What I did is I have created A…
-
Need table for Provider setting values for the task Configure Candidate Experience CAPTCHA ProviderSummary: Hi Could you please help me out to find the table where the information for Provider setting values in the task Configure Candidate Experience CAPTCHA Provider …Opkey PA 11 views 2 comments 0 points Most recent by Keerthana-Support-Oracle Recruiting, Opportunity Marketplace
-
oracle.xdo.template.online.dms.common.XDODmsException: IO Exception was thrown! nullSummary: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODm…Malak 101 views 7 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
OTBI Custom Prompt for Company Fiscal Period, Quarter, and YearSummary: We have a need to report out on our fiscal calendar dates vs. the standard out of box calendar month dates. I was hoping there was a way to set-up our own fisca…CGardner01 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to concatenate manager person numbers from hierarchy in HCM Extract?Summary: Content (please ensure you mask any confidential information): urrently my extract structure is like this: PER_EXT_PERSON_MANAGERS_HIERARCHY_UE In this UE, I wa…
-
Which tables are used to link the Goal Plan Assignment ID with archived transactions?Summary: Could you please specify which database tables store the Goal Plan Assignment ID? Additionally, which tables are used to establish the relationship between the …Nalsoft Pvt Ltd 21 views 1 comment 0 points Most recent by Lucas B Maciel Reporting and Analytics for HCM