Reports
Discussion List
-
No results using subject area "Workforce Management - Worker Assignment Real Time"Summary: Hello, I'm trying to create a learning report showing employee's division, branch, department. I get results I need except from the 3 criteria. I have both HR A… -
BIP | SFTP issuesSummary: In which table holds the FTP failure error messages. Content (please ensure you mask any confidential information): Assume that BIP report unable to place the f…
-
How to rearrange row in OTBI report?Summary: Hello, I need some help. I want to rearrange the performance tasks according to the order below per employee but every time I sort, the entire column sorts. Wor…
-
Conditional Suppression in EPM ReportsSummary:Cannot get Conditional Suppression to work in EPM Report Content (please ensure you mask any confidential information): I have migrated a FRS Report to Reports. …
-
How do I query Administrator Profile Options?We often find that there are Administrator Profile Options that are enabled or disabled during upgrades that we are unaware of and are not part of the release notes. Bec… -
We looking employees Names in arabic language like LANGUAGE = 'AR'Summary: Hi Team, We looking employees Names in arabic language. for department name we used Transalation table HR_ALL_ORGANIZATION_UNITS_TL ,,and dept_arabic.LANGUAGE =…AjayKumar Maddipati 171 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
SQL needed to find parent department in department tree for any given department nameSummary: SQL needed to find parent department in department tree for any given department name Content (required): Hi All, Please share SQL to find parent department in …C.R.Balaji 3.3K views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Scheduled Report taking the extract in UTCSummary: Hello, The query is that if we are scheduling a custom report in IST time zone like 2.45 AM IST BUT the scheduled report is extracting the data from form 9.15 P…Awadhendra Tripathi 11 views 1 comment 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
how to suppress 0 data in FCCS reportsWe have two test environments and when I open the same report it shows different row counts. In test environment A, there are some entities that are not visible in Test …Patrick Pontillas 36 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 41 views 16 comments 0 points Most recent by mathew060581 Reporting and Analytics for ERP -
Learning Management - Activity Completion DateSummary: Hi - I am trying to build an OTBI report that would show all activities in a course at the employee level and whether or not they have completed that activity o…
-
Need help in creating new Talent Profile printable versionSummary: How to create new Talent Profile printable versionRavindr-Oracle 11 views 2 comments 0 points Most recent by Christine Yokoi-Oracle Reporting and Analytics for HCM
-
Batch Scheduler FunctionalitySummary: Is batch Scheduler Changing? Content (please ensure you mask any confidential information): FR is going away in June 2025. Currently we use batch scheduler to r…
-
Is it possible to Freeze additional columns/rows in EPRCS reports apart from the default ones?Only default rows/columns are freezing in EPRCS reports. We need additional two columns to be freeze which are text columns, and it contains account descriptions and its…Pramila Sakthivel 11 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
DM for an Emergency Contact ReportHi Sorry if this has been asked before and I see a number of reports in OTBI but I am looking to see if someone has a data model for an Emergency Contact report. I am lo… -
what is the formula or calculation logic for lease revenueSummary: what is the formula or calculation logic for lease revenue? In lease details report for revenue lease, we can find the lease revenue column on Payment Amortizat…
-
Extract XML or output from ESS jobSummary: Is there a way to extract XML or output from ESS job through SOAP webservice, or REST to outside of Oracle fusion Content (please ensure you mask any confidenti…Sunil Pradhan 82 views 4 comments 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
talent profileSummary: hi, Could I get the pending transaction data (includes items data) which is under approval for employee talent profile. Content (please ensure you mask any conf…User_L2S8E 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
NRCS Suppression settings for Departments with no DataHi All, We have a NRCS report using a PBCS application as Data source. We need to suppress the full report if any department has No Data. We have tried different combina…
-
Issue post moving FR reports from one folder to another within the Explore repositoryWhen we move a specific FR report from one folder to another within the explore repository, the refreshable version of the report in smartview stops to work. The excel t…
-
Table to find instance name/Environment NameHi Team, Could you please share a table or SQL to find the instance name, when values would be DEV1, DEV2, or PROD. I have already checked the ASK_DEPLOYED_DOMAINS table…Swapnil Kashid 556 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
actual vs budget bi publisher based on COASummary: Hi, is there a BIP report where we can extract initial budget and adjusted amount for chart of accounts 1-3. Content (please ensure you mask any confidential in…
-
Report only one sheet excelSummary: Hi, migrating the reports from Financial Reporting to Report, we noticed that downloading the report in Excel on Financial Reporting inserted the report in a si… -
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL?Welsey 770 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a report migration tool for migrating HFM reports to FCCS Management Reporting?Summary: Is there a report migration tool for migrating HFM reports to FCCS Management Reporting? Content (please ensure you mask any confidential information): I believ…Jack Traynor 42 views 3 comments 0 points Most recent by Vlad Rusu-Oracle Financial Consolidation and Close -
Position Request Status ReportHello, I am looking for a report that will give me all the positions requested for New Position, Backfill/Replacement, and Promotion by leader. Ideally the report captur…
-
Report on User Name Last Updated DateSummary: I'm looking for a report to tell me the last updated date / last updated by for the User Name, please Content (please ensure you mask any confidential informati…