Reports
Discussion List
-
what is the previlege for Workflow Transactions ListingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PUGALESWARAN PALANIVEL 41 views 8 comments 0 points Most recent by Ajay Kumar Kotha Reporting and Analytics for ERP -
How to use SUBSTR on Clob in BI Publisher which is not an XMLI am trying to get the Report delivery information of the reports executed with Bursting from the AuditViewDB in Fusion SaaS. The delivery details are in a CLOB column w… -
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R…User_2025-01-30-23-00-53-497 109 views 5 comments 1 point Most recent by Rich Merkel Reporting and Analytics for ERP -
Is it possible to run an OTBI report and the results to be what my manager would seeI want to be able to build reports in OTBI for employees to run, with the results to return as if it was their line manager running the report themselves. I understand t…
-
Get FRS report results in different currencySummary: Is it possible to get all FRS report output in a group currency? Content (please ensure you mask any confidential information): We have a requirement to calcula…
-
Query optimization questionSummary: Processing is fast only when not filtering by wlf_assignment_records_f.COMPLETION_DATE Content (please ensure you mask any confidential information): I have a l…Stefano_Mazzocca 31 views 6 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Is there any API to read files from UCM serverWe have to build integration in MuleSoft to read the file from Oracle fusion UCM server. Is there any API which we can configure in MuleSoft to read the file from Oracle…
-
I would like to use Gen AI in rowsSummary: I'm creating a report where the business would like to see comments for the variance on each row within the Grid based on a certain threshold. Is that possible …
-
Original Candidate sourceSummary: Content (required): Is it possible to capture candidate’s original source via reporting? Currently the system only tracks application source and we lose key dat…Riti Malhotra 41 views 3 comments 1 point Most recent by Riti Malhotra Reporting and Analytics for HCM
-
Blank report + grid error when changing Movement via Grid POVHello, We have a report that contains two grid POVs, where the Movement member can be changed individually for each grid. Some users are experiencing issues when opening…Patrick Pontillas 21 views 3 comments 0 points Most recent by SR912 Financial Consolidation and Close
-
"HRC_TXN_TAC_HISTORY" - Audit report for corrections to transactionsSummary: We have enabled the editing function within the Transaction Console. Users can now adjust the transactions to make corrections while not yet approved. Is there …
-
OTBI Agent Not Sending Files to Distribution List EmailGood Day Experts, We have an OTBI Agent that is not sending the file to a distribution list email. The OTBI Agent is sending our dashboard to an excel file. Sending to i…JMLMIII 61 views 6 comments 0 points Most recent by Vidhya Nadarajan-Oracle Reporting and Analytics for HCM
-
Why does the audit table PER_PEOPLE_EXTRA_INFO_F_ return no value?Hi all, I need to audit the PEI_INFORMATION1 field of the PER_PEOPLE_EXTRA_INFO_F_ table. I configured everything as stated in this document (https://support.oracle.com/…VincenzoCoppola 131 views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
pension reason for leaving qualifying schemeSummary: Report on Employees who have opted out of a pension scheme. Content (please ensure you mask any confidential information): Hi All. Trying to create a report tha…
-
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…Ifeanyi Katchy-Oracle 4.3K views 55 comments 20 points Most recent by Shyam Patel Reporting and Analytics for ERP
-
NR chart report-Lower values showing upside than higher. How to correct this weird behaviour?Summary: Narrative Reporting chart report- Am using a combination chart with 8 data sets 6 of them on primary Y axis, and 2 data sets on secondary Y axis. But the these … -
How to connect organization hierarchy with job requisition?Summary: I am using recruiting real time subject area and trying to connect Job Requisition with Level 3 Organization Name but unable to get result on the Level 3 org na…
-
How to export three reports output into a single pageHi Team, I have merged three reports into a single page. Out of the three, two are OTBI reports & one is a BIP report. When I am trying to export data, only two OTBI rep…
-
Repeating Groups - Excel TemplateHello. Does anyone have any idea on how to make this kind of layout on Excel Templates using BI Publisher? How to make a repeating group like this? -
RTF Template| Bar Graph | Error: Invalid DataSummary: Hi all, I am working on the RTF template where requirement is to show the data in the bar graph format and it is giving me error like invalid data. For testing …
-
How can I get Double Quotes in eText file for column data which has comma (,)Summary: How can I ensure that data containing a comma (,) is enclosed in double quotes when exporting a comma-separated values .txt file from Oracle Example 1 (No comma…Janardhana Kondaveeti 13 views 3 comments 0 points Most recent by MJ_ Reporting and Analytics for HCM -
How to run custom reports in FCCS using rest APIWe have custom reports build under Dashboards Reports section. We want to execute them via rest API. I have tried the rest API provided under https://docs.oracle.com/en/…KamalRawat9918 41 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Email Oracle seeded ESS Job:Import Costs: Generate Output Report outputSummary: We have requirement to email output of 'Import Costs: Generate Output Report'. We find it challenging as this is child job for 'Import Costs' . This report 'Imp…Manjusha ERP Tech09-Oracle 1 view 0 comments 0 points Started by Manjusha ERP Tech09-Oracle Reporting and Analytics for ERP
-
Suppliers with Duplicate Taxpayer ID Report not Available to RunSummary: No capability to open or schedule the Suppliers with Duplicate Taxpayer ID Report Content (please ensure you mask any confidential information): Our business us…AnuragGandhi 21 views 1 comment 0 points Most recent by AnuragGandhi Reporting and Analytics for ERP
-
BI Publisher PCL Printing Issue: Layout Output Appears Scaled DownI would like to ask for your advice regarding the output of a BI Publisher printing. When we register the printer in the ERP and issue the print job using PDF to PCL fil…
-
Custom HR View Only Role to Run HR ReportsSummary Need HR Custom Role BuiltContent Hi all, I need to create custom role that provides access to run some reports in our HR folder, without granting HR roles to tha…Kevin_W 74 views 11 comments 0 points Most recent by Zaneta Zetkowski Reporting and Analytics for HCM -
POV or Prompt for a Single Fiscal Year That Works for Two Different DimensionsSummary: I am working on a report in narrative reporting that pulls data from our ERP GL and EPM Planning applications. The ERP GL has an Accounting Period dimension whi… -
I need a unique users report in HCM Fusion.Summary: User Audit Report. Content (please ensure you mask any confidential information): Hello, everyone! I need a report or query that allows me to identify unique us…Alexandre Paes 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
FCCS MR: Is there a way to disable or lock the Grid POV ellipsis to prevent invalid POV selections?I am working on a Management Report in FCCS that uses a Global POV and two grids, each with its own Grid POV containing specific hardcoded members except the Movement di…Patrick Pontillas 22 views 5 comments 0 points Most recent by N.S-Oracle Financial Consolidation and Close