Reports
Discussion List
-
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 123 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 876 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 3 views 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 87 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 53 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 3 views 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 43 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 23 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…
-
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 4 views 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 48 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…
-
MMM-YY date format, grouping dates and showing same value in promptWhen doing the custom data format for a date field as MMM-YY, how can that be achieved in the prompt so that they're only having to select a single value for the month a…
-
Fetching Job Requisition with Sensitive Information in OTBIHi Team, We are fetching job requisition details from OTBI in the Recruiting - Recruiting Real-Time subject area. However, we also need to retrieve additional candidate-…Jeeva - Cloud Vantage 25 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Generate Button disabled for Enterprise Journal Reports Tab after December 2024 UpgradeSummary: There are multiple system reports appearing under Task Manager Reports Tab after December 2024 upgrade, Even Generate button is enabled to extract reports in PD…
-
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…a.w.anand 3.7K views 9 comments 0 points Most recent by Gongati Nandish Kumar-Oracle Reporting and Analytics for HCM
-
Filtering on attributes on epbcs reportingMy client wants to have a report where they are able to filter on the attributes. They currently have three separate attributes in the POV but they would like to be able…
-
Fast Formula with FF type "Extract Criteria" is not working when we are trying to add it in extract.Summary: Hi Team, We have designed extract to pull the employee assignment details but it was picking the multiple records for an employee. We used fast formula in "Filt…
-
Is it possible to add a Field Tag inside the Textbox in RTF TemplateSummary: We have a requirement to add name field inside a text box and add a photo inside a circle shape. I tired, but not able to add those fields. I even tired to add …Sujeeth Chinta 81 views 9 comments 0 points Most recent by User_OCKZO Reporting and Analytics for HCM