Reports
Discussion List
-
How can I pull all reports and their permissions available /shared folder/custom/ pathSummary: How can I pull all the reports available in "/Shared folder/Custom/" path with their permissions through backend(sql) or any other alternate, with environment h… -
Need help with Cost Accounting Distributions CodeSummary: Hy Experts. I am developing a Purchase Register Report where I have to fetch a column named Inventory Charge Account in which this value of Inventory Valuation … -
missing national identifierSummary: Technical user cannot extract National Identifier (Codice Fiscale) from PER_NATIONAL_IDENTIFIERS despite ORA_FND_INTEGRATION_SPECIALIST_JOB + custom role duties…Claudio De Castiglioni 12 views 0 comments 0 points Most recent by Claudio De Castiglioni Reporting and Analytics for HCM
-
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…GauravGupta39 624 views 5 comments 0 points Most recent by Viswanadh Reporting and Analytics for HCM
-
Regarding - Alerts Failure during Bulk LoadSummary: We have implemented multiple custom BI Publisher–based alerts that are triggered on specific business scenarios and scoped to particular Business Units. During …Abdul Raqueeb 2 views 0 comments 0 points Most recent by Abdul Raqueeb Reporting and Analytics for HCM
-
ORA-01427: single-row subquery returns more than one row ERRORSummary: Have a Payroll Config workbook and returning error. We can't seem to identify the issue. it exists in one of the 3 attached data sets. https://us.v-cdn.net/6034…
-
disregard question thanksdisregard question thanks
-
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 433 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 91 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 201 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…
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.2K views 7 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM
-
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 2 views 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 458 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 72 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 2 views 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 12 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 32 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 31 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…