Reports
Discussion List
-
Which table to get the Plan Period Start DateSummary Plan Period Start DateContent Dear Expert, Which table to can we get the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached …Vasanthakumar Ravi 135 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to download all attachments from a Projects Invoice workflow transactionSummary: How to download all attachments from a Projects Invoice workflow transaction Content (please ensure you mask any confidential information): Approvers are attach… -
MilanMohanty 144 views 3 comments 0 points Most recent by Mohd Affan Ahmed Reporting and Analytics for HCM -
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 110 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 32 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 62 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 132 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…
-
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 3K views 78 comments 9 points Most recent by Pratiksha Sawandkar Reporting and Analytics for ERP -
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.2K 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 12 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 30 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 76 views 11 comments 0 points Most recent by Zaneta Zetkowski Reporting and Analytics for HCM