Reports
Discussion List
-
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… -
HCM Position HierarchySummary: Hi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name … -
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 -
Report image only visible in pdf not in wordSummary: Hi all, We noticed that when downloading a custom report in word we cannot see the image/enterprise logo attached. Whereas, when downloading the same report in …Silvia Stangarone CAI 1 view 0 comments 0 points Started by Silvia Stangarone CAI Reporting and Analytics for ERP -
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 36 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 18 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… -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,… -
BIP Tables for Calendar/Calendar Events linkage with EmployeeSummary: BIP Tables for Calendar/Calendar Events linkage with Employee Content (please ensure you mask any confidential information): Hello, from My Client Groups > Orga…Dario_DiFranceschi 5 views 0 comments 0 points Started by Dario_DiFranceschi Reporting and Analytics for HCM -
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 32 views 5 comments 0 points Most recent by Lasantha Ranjana Bandara Reporting and Analytics for ERP -
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 3.1K views 79 comments 9 points Most recent by Pratiksha Sawandkar 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 3 views 0 comments 0 points Started 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 -
Permission for standard folderSummary: Hello, I'd like to know if we can set permission for Human Capital Management under shared folder(the standard folder) to specific users. I managed to do that i… -
narrative reporting custom header new lineSummary: Narrative reporting / custom header in a column - anyway to force new line in text? Content (please ensure you mask any confidential information): Narrative rep… -
Copy/paste multiple membersSummary: Hello, Several years ago, I posted this question: Is it possible to copy/paste multiple members? — Cloud Customer Connect Has something changed since then? Than… -
How to force repeat on rows in pivot tableSummary Trying to build a pivot table using the report editor with repeating valuesContent Has anyone been able to force a repeat on a row value in a pivot table? The ex… -
Narrative Reporting Two Questions - Heading Number by Report AND Bursting versus Report PackageSummary: Dynamic report header numbering in a 'container' AND best way to run various combinations of a list of reports by entity - where some entities do not run all en… -
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve… -
ANC_PER_ABS_DAILY_DTLS - Issues with Overnight Shifts / Absence BreakdownSummary: We want to report on absences related to a shift, however the table seems to store the hourly breakdown per day rather than per shift start date. Example; 25/06…