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… -
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 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 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 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 1 view 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 ,… -
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 31 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 12 views 2 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
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… -
Industry field for otbi subject aresSummary: Please help in getting industry field for otbi having subject ares: 1.order management-fulfillment lines real time 2.order management-order headers real time 3.… -
Why is per_person_secured_list_v secure view not working on AORs in custom BI Report?Summary: Why is per_person_secured_list_v secure view not working on AORs in custom BI Report? I am running my custom report (containing the per_person_secured_list_v) b…Consultant Ian 26 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
FCCS: Is it possible to NOT display Forms under the library in Reports or limit accessSummary: Content (please ensure you mask any confidential information): Hi all As per attached, we are seeing Forms displaying under the library part of the new REPORTS.… -
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr…usr_a.nv 172 views 19 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
25D - Text Object "Contains HTML/Javascript/CSS Markup" Option remvoedHello, We've recently upgraded our DEV environment to 25D. We're now finding that the option to include text that contains HTML has been removed. Was this documented any…Rob F 41 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM