Reports
Discussion List
-
How to print prompted value as a header text in FRS report?In a custom FRS Balance Sheet report I have a requirement to print the prompted values as a selected parameter in the header section as a text value. Also I want to show… -
How can we change the sequence of the parameters while copying job from seeded job.we are trying to duplicate the ESS job ( Transfer Assets to Oracle Fusion Assets ) but we have a doubt regarding parameter sequence. In the standard ESS job definition B… -
HCM iby_ext_bank_accounts_SELECT * FROM fusion.iby_ext_bank_accounts_ WHERE audit_action_type_ = 'DELETE' this is not giving me deleted records in the report. audit is enabled. insert is showing …
-
Users with experience of using SQLConnect by BI SplashSummary: Users with experience of using SQLConnect by BI Splash Content (please ensure you mask any confidential information): We are reviewing the feasibility of granti…
-
Level 0 Descendants of Multi-Selection Prompts in REPORTSHi - I have been researching / testing things for a bit and figured I would ask the question as I assume this has been a requirement before. This functionality was in Fi… -
How to attach custom layout in BPM Task for Workflow Notification for Document of RecordsSummary: We have created a Document of Record to submit Time Anomalies. When user submits Time anomaly request, it goes to the line manager. User is submitting the time …Priya J N Singh 22 views 2 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM
-
Is it possible for rich text format stored in a Data Field to display as Plain text in a report?Summary: Hello team, Is it possible for rich text format stored in a Data Field to display as Plain text in a report? This is the application data rich text format. My Q…challa praveen 52 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to Export FCCS HFR reports in PDF format via automated way?Summary: We want to export the HFR report (Financial Report) created in FCCS in PDF format. We are expecting that it needs to exported in inbox/outbox directory. How can…NishantF 91 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Excel output from RTF template is having one blank line in the topContent Hi All, I am using the RTF template to get the output in Excel format. I have used the page break to get the output in different sheets in excel. When the output… -
Oracle HCM Inquiry Personal Payment Method and Bank AccountHi Oracle SME's, Here is our inquiry, since moving to redwood we noticed that the bank account and personal payment method has been separated. We just need a query to he…pmarquez 32 views 0 comments 0 points Started by pmarquez Payroll and Global Payroll Interface (GPI)
-
In FCCS, API that can trigger reports automaticallySummary: Hello All, In FCCS, want to know If there is any existing API that can trigger the below reports automatically ? 1. “Consolidation Journal Report” 2. “Data Load…
-
My rtf template has "È" but report shows "Č" insteadSummary: Encoding issue Content (please ensure you mask any confidential information): Rtf template is: Final result is: Why? Version (include the version you are using,…Stefano_Mazzocca 11 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
transaction administration subject area securityHello experts, we had an report using the subject area Human Capital Management - Transaction Administration Real Time and it dont consider the security of the employees…Lucas B Maciel 12 views 3 comments 0 points Most recent by Lucas B Maciel Reporting and Analytics for HCM -
Will Oracle Fusion Cloud BIP report Bursting supports Dot Matrix PrinterSummary: one of the report needs to be printed in Dot Matrix Printer. So, We need below information 1. Will Fusion BIP bursting supports Dot Matrix Printer? 2. If so, in…
-
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E…Sankalp Shukla 1.5K views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…Saher 51 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What are the considerations of enabling and disabling the global "SQL Pruning" setting in BIP?A customer enabled the global SQL pruning setting in production which caused various BI publisher report issues (primarily, missing columns from various CSV and RTF outp…Harrison Jacob 12 views 0 comments 1 point Started by Harrison Jacob Reporting and Analytics for ERP
-
OTBI analysis about Learning CommunitiesSummary: OTBI analysis about Learning Communities Content (please ensure you mask any confidential information): Hello experts, we need to create reports about the learn… -
How to perform drill-down directly within an Oracle PBCS report?Hi, I’m working on Oracle PBCS in the Reports section and I was wondering if it’s possible — and if so, how — to enable drill-down functionality directly within a report…
-
OTBI Prompt returning wrong DataWe are creating a report in OTBI using subject area "Maintenance Management-Work order performance Real Time". Select Work Order Priority in Data as well as Prompt. In D…
-
Is there a PVO (or combination of PVOs) that returns the accounting status of a Payables invoice?I need to return the accounting status (Accounted, Partially Accounted, Selected, Unaccounted) for a specific AP invoice but using PVOs. The column "ApInvoicesPostingSta…
-
Add a Column with a Static Value in OTBISummary Trying to add the same value to all records, i.e. add a dummy column that holds a static fieldContent In OTBI, I need to add a column to a report that doesn't ne…Lisa G. 743 views 6 comments 0 points Most recent by Alex Pagliarini - Ninecon Reporting and Analytics for HCM -
What Lease Accounting table stores lease term?Hi, Lease Accounting UI has Lease Term in addition to Lease Start Date and Lease End Date. I am not finding Lease Term, which table is this in? Screenshots below:jess-izumi-234 31 views 5 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Lease Accounting
-
Need to Fetch Last Updated Records in ess_request_history tableI’m building a report using the ess_request_history table, where I need to fetch incremental records based on a timestamp filter. However, I couldn’t find a 'last update…
-
FCCS Report - Rest API - How to trigger?Summary: I have the reports under Library in FCCS. Is it possible to execute this report using REST API or EPMAutomate? I tried to use rest API URL "https://mikcons-test…
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 574 views 8 comments 0 points Most recent by User_K7YG4 Reporting and Analytics for ERP