Reports
Discussion List
-
Inquiry: Attaching XSL-Based XML Output to PDF in Oracle Print Transaction ReportSummary: The Print Receivable Transaction seeded job is currently generating PDF output for customers. A new requirement has been raised to build an XSL-based XML output… -
How to embed a xsl based xml output in oracle Fusion Print Receivable Transaction PDF outputSummary: We have a requirement where the output of the Print Receivable Transaction should include both the generated file and the corresponding XML source file, based o…
-
In New migrated Reports reference Prompt is not working with IntersectHi Team, We have migrated FR to Reports. In many of our FR reports, we used a prompt for the entity and referred to the same prompt with level 0 in the next row using th… -
OTBI Agent - Error Generating DocumentI have an OTBI report that I'd like to schedule to run and send the report via email. I've created an Agent to run the report, but when I receive the results via email, …Steven Woods 91 views 3 comments 0 points Most recent by Sridhar_Rejeti_1423 Reporting and Analytics for ERP
-
Historic Grade Steps in OTBISummary: I can see a previous grade step and current grade step using the screens, I wish to see the same information using OTBI. Content (required): When I create an An…ScottHillier 121 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Non-typeable flags - Audit ReportI cannot put the flag on "Show User-Related Details", "Show Attribute Details" and "Show additional object identifier columns", when exporting audit reports. What role/p…Greta S 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
ORA-01719: outer join operator (+) not allowed in operand of OR or IN with payroll reportHi, The environment was recently upgraded to version 24D. Following this upgrade, the payroll report started encountering the attached error during execution (ORA-01719:…Saurav R-Oracle 121 views 1 comment 0 points Most recent by Matthew Hancock Reporting and Analytics for HCM
-
Run the report in Narrative Report based on the system dateHello everyone, I want to ask about the report in Narrative Report or Financial Reporting or Report in EPBCS. My report has prompt "Current date" as the selection: My qu… -
We need to know table which stores Absence StatusContent Hi , We need to know which table stores status shown in attached screenshot. I have checked columns ABSENCE_STATUS_CD and APPROVAL_STATUS_CD in table anc_per_abs…Nidhi Chhajed 859 views 13 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
how to customize employee promotion letter notificationSummary: how to customize employee promotion letter notification Content (please ensure you mask any confidential information): Hi Team, We got a requirement to add new …
-
Consolidation journal report - submitter informationHi, currently, consolidation journal report can be retrieved only with "created by" and "posted by" information but not "submitted by". Can you please add this option as…Christian Oefner 21 views 4 comments 0 points Most recent by SJ00793615 Financial Consolidation and Close
-
I am not able to fetch the pay value for Social Security DeductionsI am not able to fetch the Pay Value of Social Security Deductions For Oman Salary Payment Report in Oracle Fusion Cloud HCM . Can someone help me out with the query or …Tuhinaa Nanda 1 view 1 comment 0 points Most recent by Tuhinaa Nanda Reporting and Analytics for HCM
-
Need SQL Query to fetch degree of the employeeSummary: Hi experts, I need an SQL query to retrieve the degree of an employee. If possible, please provide sample data along with the table and column names to help me …Arti_Priya 71 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Exportfolder location in Oracle Reporting Web Studio through PCMThe oracle application used is PCM and when scheduling a batch run through oracle reporting web studio, there is an option for the results to be saved in an external dir…
-
Restricting a record if its already sent - Oracle Fusion ERP Cloud BI Report Requirement.Summary: We have a report requirement that once payments exceed $600 during a calendar year, we report to the downstream app within 20 days. Also, once a supplier has be…Abhilash K - Deloitte USI 51 views 2 comments 0 points Most recent by AnupamAgr Reporting and Analytics for ERP -
I cannot see bursting enabled in batch scheduler in FRSSummary: I cannot see bursting enabled in batch scheduler in FRS Content (required): I created a batch and added two reports. Next I created a batch scheduler and added …ShitalRamteke 1 view 2 comments 0 points Most recent by Carlos Suarez Lopes Reporting and Analytics for ERP
-
Is it possible to pull USD balance directly for TAR Book Balance Automation?Right now we have set up TAR book balance automation, but for foreign entity it pulls local currency book balances then translated using FX rates to USD balance. Is it p…
-
Reports and Analytics - Catalog - usage numbersSummary: Need to identify usage nubmers of reports in the ERP Tools and Analytics catalog Content (required): We are trying to identify the frequency and usage of report…Marko Puskac 41 views 4 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
Need PVO details for PER_ROLES_DN? Not able to find one in BICC mapping to Finance/HCM listSummary: I am looking BICC Tag for PER_USER, PER_USER_ROLES , PER_ROLES_DN HAve found following for PER_USER and PER_USER_ROLES and not for PER_ROLES_DN HcmTopModelAnaly…Antony P Patrick -Oracle 111 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
HSDL Updates to Requisition are not captured in IRC_LC_HISTORY TableSummary: When a requisition is updated using HSDL and if EXT_PUBLISH_JOB_STATUS , EXT_PUBLISH_JOB_END_DATE columns are being updated without any change to phase or state…vinay karumanchi 11 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Spreadsheet Data Loader (HSDL)
-
Error with running narrative reports on smart viewHi, my client is facing errors with running Narrative reports through smartview for both epm book and reports. They are able to view reports on HTML and pdf but not exce…
-
Assignment Manager (Unsecured) significantly slower in Workforce Performance Subject AreasSummary: Material / significant slowness that appear to be driven by [Assignment Manager (Unsecured)] folder within Workforce Performance Subject Areas, relative to othe…
-
Taleo Oracle Analytics: OAS Agent Management - Secure SendSummary: Is OAS Agent Management a secure send? What we know in the past for OBI, it is not but with the multiple upgrades happened and migration to OAS, we wanted to va…Martin Hernando 1 view 1 comment 0 points Most recent by Martin Hernando Taleo Enterprise Integrations
-
Query on Management Reports in PBCSSummary: Hello , There are a couple of projects that we are working on and was hoping that you could give us guidance . Is there a way to refresh an MR report in excel, …
-
Need to know which bi reports are being run by a user in a monthly basis and how oftenWe need to know which bi reports are being ran by a user in a monthly basis. Here the challenging thing is report ran might be scheduled or adhoc (ran directly) , we nee…
-
OTBI Dashboard only shows Indirect on promptSummary: OTBI dashboard is only showing Indirect in drop down prompt. Need to be able to choose between Direct and Indirect reports. Content (please ensure you mask any … -
Customization of ICP ReportHi, Our client requires some customizations in the ICP report format, such as: Changing the order of accounts in columns. Adding a new table for custom calculations. Mod…Bakul Dehariya 31 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
how to convert blob type to actual text in oracleSummary: the underlying tables store the xml data of employees in blob format, the customer wanted to see the exact content of this File_data column in output results.. …Rama123-Oracle 41 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to get one time data in audit tables after enabling auditing for HCM processes.Summary: How to get one time data in audit tables after enabling auditing for HCM processes. Content (please ensure you mask any confidential information): We have enabl… -
Generate a count of employee self service requests for certain employee data fieldsSummary: Is there a way in OTBI to generate a count of the number of times an employee changed personal information data in self-service over a period of time? My unders…