Reports
Discussion List
-
Print User Name ( person running report) in BIP reportContent All I have a requirement to print the username in the BIP report. User name of the person running the report. In the report, something like , report generated by…Naveen Jayaraman-48236 444 views 8 comments 0 points Most recent by SomiC ZF Reporting and Analytics for HCM -
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…Jaswant Prajapati 94 views 2 comments 0 points Most recent by User_DXHDL Reporting and Analytics for HCM -
Audit team need a clarification from Oracle official to prove Intercomapany report is standardHi team, This is a request to have Oracle official answer for EPM FCCS intercompany report. Audit team is analyzing one report in EPM called "Total Company IC Matching" …Marcy Gao 21 views 9 comments 0 points Most recent by Einar Hagen Klungreseth Financial Consolidation and Close
-
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 204 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Dynamic Numbering in ReportsHi all, I want to build a P&L Report in PCM for which I want to supress rows with missing values or 0 as a value. I also want to adjust the numbering of the rows, so the…Vincent__ 11 views 2 comments 0 points Most recent by MonishAmbawat-Oracle Profitability and Cost Management
-
POV to include and exclude intercompany accountSummary: I am new to FRS. I would like to ask if I can define a dimension and user can choose whether they want to include or exclude a list of intercompany account. Con…Yeung Shing Keith 1 view 0 comments 0 points Most recent by Yeung Shing Keith Reporting and Analytics for ERP
-
Expend All in Financial Reporting StudioSummary: I would like to ask if there any way to expand all the node at one go instead of expand it one by one. Content (please ensure you mask any confidential informat…Yeung Shing Keith 1 view 2 comments 0 points Most recent by Yeung Shing Keith Reporting and Analytics for ERP
-
How to change the week start daySummary: Hello Experts, I created an Analysis and i see the Calendar Week Start Date is Sunday, but the customer need set to Monday. And this impact on the number of wee…
-
How to bring the value from Previous schedule in HCM ExtractTeam, We have scheduled an extract where the Union Name parameter has a default constant value of CUPE. During the first scheduled run, we manually selected NBUPPE. Howe…
-
Enable Comments at Parent Level accounts in FCCSWe have a client requirement to enable comments at the FS/parent level in BS and IS reports, so that users can add comments directly on those parent accounts in FCCS. In…B.Bhandari 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
OTBI analysis opens directly without showing prompt when opened from the reports and analytics pageHi team, Facing an issue where an OTBI analysis opens without showing any prompt from the reports and analytics page ( it's added to favourites ) but when opened by navi…Raghavendar 464 views 2 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
Number of picks as a visualization in a dash board in LogfireSummary: I need to Create a visualization in Logfire showing the number of picks for each user. The cycle as following : 1- Order created. 2- Run wave to allocate the qu…
-
Does Audit logs record data changes from Data managementSummary: Does Audit logs record data changes from Data Management? Content (please ensure you mask any confidential information): Hi team, We have exported Audit logs an…DISHIL SHAH 71 views 17 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Bursting Report for Line Managers - Future Hire Notifications (No Data Returned)Summary: Hi Community, I'm developing a bursting report in BI Publisher that will notify line managers about employees starting on their hire date. The report should run…Vishal Purohit 1 view 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
I am getting this error in bursting code ORA-01489: result of string concatenation is too long".Summary: I am getting this error in bursting code ORA-01489: result of string concatenation is too long". Content (please ensure you mask any confidential information): …Shiv Garg 11 views 2 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Report to obtain the user's transactionsSummary: Report to obtain the user's transactions Content (please ensure you mask any confidential information): Is there a query, process or report to obtain the transa…Jazmin Saldierna 31 views 6 comments 1 point Most recent by Rich Merkel Reporting and Analytics for ERP -
Audit - On Folder Permissions ChangesWe have a requirement on Auditing folder Permissions Changes details on "Reports and Analytics --> Catalog --> Shared folder --> Changes on any of the custom folder perm…Ramachandran Mani 32 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
We have a requirement to audit changes to folder permissions for custom folders in Reports and AnalySummary: We have a requirement to audit changes to folder permissions for custom folders in Reports and Analytics. Is there a way to get these details? Content (please e…Akash M Mahalle 2 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
GL_FRC_REPORTS_B and Custom Folder and Report ListSummary GL_FRC_REPORTS_B is not listing all the reports that are created or modified; Should we run a process to populate the table or does the data in the table gets po…
-
Tables that store the errors in FAH when the import Accounting transaction process failsSummary: What are the tables that store the errors in Accounting Hub when the import Accounting transaction process fails ? Version (include the version you are using, i…
-
What's wrong in this bursting?Summary: Content (please ensure you mask any confidential information): I have this template and this bursting query: Report works fine: Why do I get an empty output whe…Stefano_Mazzocca 21 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Transaction comments reporting - Termination ReportContent With the release of the new UI, the per_periods_of_service table no longer contains the comments for the termination transaction, instead the comments are placed… -
Management reporting ad hoc download.Summary: In Oracle FCCS Management reporting, while running any report in html format, when try to download excel ad hoc from settings, it only exports one grid, not the…
-
XML-23029: (Error) FORG0001: invalid value for cast/constructor ERROR IN BIP REPORTHi All, We are getting below error while running BIP report, while it runs successfully for some orders and gives error for 2-3 orders Can you suggest nay possible solut…
-
Browser is getting automatically refreshing when scheduling ESS job set in Oracle cloud ERPSummary: Hi All, I hope everyone is going well!. I need some help in resolving the ESS job set related problem. I have created the ESS job set with 10 Ess jobs inside of…VasanthaFusion90 36 views 5 comments 0 points Most recent by Lasantha Ranjana Bandara Reporting and Analytics for ERP
-
sql to fetch payroll process having ui_task_status = 'COR_FLOWS'Summary: Parameter having p_start_date , p_end_date, p_payroll_name based on this parameter will identify period name and start_date and end_date from pay_period table. …Ankush Jadhav -Oracle 1 view 0 comments 0 points Most recent by Ankush Jadhav -Oracle Reporting and Analytics for HCM -
Can Parent & ICP Partners relationship be brought directly in FCCS Forms/Reports?Summary: We have Entity & Intercompany dimensions and we are doing a comparison between Investment Vs Equity where we we have different Ownership Percentages and Consoli…Shilpa_S3 11 views 2 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close