Reports
Discussion List
-
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 3 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 334 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 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 246 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 27 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 14 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 12 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 22 views 1 comment 0 points Most recent by Lucas B Maciel Reporting and Analytics for HCM -
SmartView for MacOSSummary: I was able to successfully create the xml file to connect to a Planning EPBCS app in my Mac OS Laptop. Question - do i have to create 1 xml file, for each conne…Emanuele Panichi 3 views 1 comment 0 points Most recent by Anand Thota Financial Consolidation and Close -
Project is available in PJF_PROJECTS_ALL_B table. But cannot view in Project Financial ManagementSummary: Project is available in PJF_PROJECTS_ALL_B table. But when tried to search the project with "All" Project Statuses enabled, it is not searchable. Content (pleas… -
Resolution Issues in PPT Report PackageSummary: Font/Text resolution issue in PPT Package for MR Reports Content (required): We created a PPT Report Package and embedded some MR reports Grids and Charts, Most… -
Where are the User Preferences Alias Settings used in FCCS?Summary: User has both Member Name:Alias selected in User Preferences General tab for Alias Settings. Where is this setting used? We assumed both forms and reports would… -
How to get email notification with company emailHi, We have a custom BI report with a job scheduled to run daily and send email notifications. Currently, the emails are being sent from the address from ****@oracleclou…Madhu Arepalli YH 23 views 3 comments 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP