Reports
Discussion List
-
Getting error -ORA-01840: input value not long enough for date formatSummary: I am getting error in BI report due to below line of code. Error - ORA-01840: input value not long enough for date format to_date(:sdt,'yyyy-MM-dd')Swati U 324 views 5 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Unable to get required currency format in Excel outputSummary: this is the tag we are using to get amount column in US format. we are able to get it in PDF output but not in excel. Content (please ensure you mask any confi…Nalsoft Pvt Ltd 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Seeded Function PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS takes longer to run in BI ReportThe function takes longer time to run in BI report and gives time out errors out when run in Adhoc. Since we are placing this report in dashboard as a link to BI, the re…
-
Unexpected behavior of FCC ReportWhen we open a report, it works and displays report with correct numbers. But as soon as we try to expand account category to check numbers on detailed accounts, it does…MKhade 81 views 8 comments 0 points Most recent by Danut Ianovici-Oracle Financial Consolidation and Close
-
Is Project Number for AP available in General Ledger or Subledger Accounting Subject AreaGood Day Experts, Is project number field for AP available in General Ledger or Subledger Accounting Real Time subject area? Just like the PO Number for AP where I can g…
-
How to suppress aggregated column in order not to repeat its values for every rowsSummary: Suppress aggregated column value Content (please ensure you mask any confidential information): Is it possible to suppress the value of aggregated column in ord…JMLMIII 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report should drill to show the courses that are part of the specialisation.Hi, We need assistance with an OTBI analysis where clicking on a specific specialization should redirect to another analysis that displays the courses included in that s…Saurav R-Oracle 31 views 0 comments 0 points Started by Saurav R-Oracle Reporting and Analytics for HCM
-
Join in OTBI is not removing data where joining two subject areas.Summary: When joining two subject area's the data is not removing information in one of the subject areas. Content (please ensure you mask any confidential information):…Max W 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How To Export Narrative Reporting Reports to another EPM instance (EPBCS) ?Summary: We have report/s in Narrative Reporting Cloud service (NRCS) that we want to export out of NRCS and then import into Planning (EPBCS) applicaiton. There is no f…
-
Sql to find t4 information of employee (like tax year and boxes information etc)Summary: Dear exports, Any one have sql/otbi report to pull the information exist in canada t4 slip? Please suggest Content (please ensure you mask any confidential info…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Chinese numerals in FCCS?Summary: Is it possible to see amount balances in FCCS in Chinese numerals? This would be needed in Web Forms, Adhoc Grids, SmartView, Reports, Journal Reports, ICP Repo…
-
Download grid as Excel ad-hoc when data rows/columns are hiddenSummary: When downloading grid as Excel-adhoc in Narrative reporting, it gives an error if all data rows/columns in the grid are hidden. This was not an issue in FR befo…
-
Changes Only Extract is not Picking up New Hires , Terminations and Changes for Some RecordsSummary: Changes Only Extract is not Picking up New Hires , Terminations and Changes for Some Records. Can any body give some Inputs to debug this and what could be the … -
Benefits Report of Terminated EmployeeSummary: Hi All, Does any one have a Benefits report of terminated employees which Shows their enrollments with Dates parameter? Thanks Content (please ensure you mask a…Naveen setti 11 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Is there a way to find out if the users really using the current assigned role that they have?Summary: In the Fussion application, we can pull list of users who has a certain data role. But we wanted to know who among those users in the list that are actually usi…Lorejean Gelacio 31 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
language alias selection for a reference doclet when used in report package?Summary: A single report can be ran manually against any language alias available in your Chart of accounts, but do you really have to double your reports when used as r… -
Using Dashboard Prompts When Using OTBI AgentGood day Experts, Is there a way to use the available dashboard prompts in a dashboard when creating an OTBI Agent? For example I have a dashboard where the default peri…JMLMIII 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Export Using Formatted > Excel Row LimitationGood Day, I have a set of data consisting of 90,000+ rows. Exporting via Data > Excel, all rows are retrieving when exported. But exporting using Formatted > Excel, it o…
-
When PJF_OPEN_XFACE_REPORT table gets purged? Is there a setup to control the same?Hi, We have a requirement to automate a Projects creation via FBDI using inetgartion. As part of error handling we found that even though interface table data gets purge… -
Inbound interface issue 24CHI Experts, After 24C patch upgrade in our instances we tested inbound interfaces what we saw is after all the steps completed (2/2) the generated HDL is failed to load … -
Need dashboard prompt based on field with complex formulaSummary: I have a report on a dashboard that has a field that gives me the highest level of education obtained by first ranking the degrees on the employee's records and…
-
Vacation hours disbursedSummary Vacation hours disbursedContent Hello Community, Are you aware of any report in oracle that will tell us vacation hours disbursed? We are specifically looking fo…User_2025-02-05-16-57-43-236 6 views 6 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Sql Query to get payroll deduction detailsSummary: I am looking for a query which provides terminated employees last earnings and deduction details from payroll. Content (please ensure you mask any confidential …Rahul K-Oracle 511 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Customer wanted automate the T4 slips that should deliver to terminated emps personal email addressSummary: Hi Experts, Need suggestions on how to automate the T4 slips that should deliver to terminated emps personal email address, if anyone implemented this functiona…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
PPM Control Budget Balance Report RequirementHi, We have multiple requirements from users asking for drilldown of balance shown in Award Overview Page under Control Budget Balances view. So we are trying to develop…