Reports
Discussion List
-
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 63 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 136 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…Jeevan Loyal 2 views 0 comments 0 points Most recent by Jeevan Loyal Reporting and Analytics for HCM -
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…JanardhanaKondaveeti 21 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 66 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 2 views 0 comments 0 points Most recent 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 23 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 21 views 5 comments 0 points Most recent by N.S-Oracle Financial Consolidation and Close -
FCCS Report Bursting FunctionalityWe have been testing the bursting functionality but are unable to get the report to display the alias automatically when using bursting. Is there a way we can use the "A…MehryaarAnwar 71 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
OTBI Analysis Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversionHello, I'm getting the error in my OTBI Analysis: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion when I add a column Called "Requirement Text" fr…JessSantos 25 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
Requirement is to display image uploaded in DOR in BIP reportRequirement is to display image uploaded in DOR in BIP report. I am able to get the UCM content id how to get the image that was uploaded in XML to use in RTF ? select f… -
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…Sankaran Lakshminarayanan 3 views 2 comments 1 point Most recent by Venkat Vatikuti Reporting and Analytics for HCM -
help with if/then formula in EPM ReportI need help with a formula in a report. As soon as I add the subtraction part to the final part of the statement i get an error. This works: IF(IsMissing([G]), 0, [F]) T…