Reports
Discussion List
-
How to remove decimal value in BAR CHART - RTF Template - BIP Report?Decimal value is displayed in the Bar chart of RTF Template - BI Report. How to remove decimal values in the chart?SARAVANA KUMAR T-Oracle 11 views 0 comments 0 points Most recent by SARAVANA KUMAR T-Oracle BI Publisher Learning Center -
Date Range Parameter value should be defaulted to previous year in OTBI ReportHi Team/Raghavendra Raghunath-Oracle, We have created an OTBI report it's working fine. However in the Prompt parameter we wanted to default the filed values as below; S…Mahendra Y 51 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to edit and disable delivery option of Oracle HCM Fusion HCM Extract in 24BWe would like to disable the delivery option of HCM Extract and edit one of the Data group filter in 24B. As we do not have Advance edit option enable.Bindu Janoti-Oracle 92 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Identify Hire Dates that are any date in the Next WeekSummary: I have an OTBI report using subject area Workforce Management - Work Relationship Real Time. On the Advanced tab, I have already entered the prefix SET VARIABLE…
-
How to see from front end or fetch data through query for schedule information of hcm extractSummary: How can we see from front end or fetch data through query for schedule information of hcm extract like the schedule date, frequency etc.
-
Navigation flow for NRCS in EPBCSSummary: We are having reports and books in NRCS instance. We created a connection in EPBCS with NRCS and did navigation flow to run the reports and books in EPBCS. For …
-
Frs report not workingSummary: FRS report not running while selecting multiple location. Content (please ensure you mask any confidential information): While Running the Frs report for Single…
-
Intercompany Report Suppress Zero columnsSummary: How to suppress zero columns on Intercompany Report in FCCS Content (please ensure you mask any confidential information): Dear experts, on our Intercompany Rep…Stefano Francese 1 view 2 comments 0 points Most recent by Stefano Francese Financial Consolidation and Close -
what is the diffrence between reports and extracts where we can we the extractsSummary: Hi Team, what is the diffrence between reports and extracts where we can we the extracts ? How can we learn, i'm new to extracts. Thanks, Ajay Content (please e…AjayKumar Maddipati 39 views 6 comments 0 points Most recent by VijayKumar R Reporting and Analytics for HCM -
Filter OTBI report using dff's effective start date and effective end dateSummary: Need to filter dff data using effective start and end date Content (please ensure you mask any confidential information): I created a analysis report which has …Taushif Anwar 121 views 10 comments 0 points Most recent by Taushif Anwar Reporting and Analytics for HCM
-
Which tables stores the information for Manage Benefit ProvidersSummary: Which tables stores the information for Manage Benefits Provider Content (please ensure you mask any confidential information): Which tables stores the informat…
-
Report for Performance Document Question ResponsesSummary Report for Performance Document Question ResponsesContent I have created a performance document with only a questionnaire section. I am trying to build an OTBI r…User_2025-01-22-19-28-29-985 235 views 21 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Looking to Create a Reports Landing Page for HR Users in OTBILooking to create a Landing Page for HR users when they land in OTBI, to allow them to see Developed Standard Reports curated by the business. Would like to have links t…Patrick Scally 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
INFORMATION_TYPE is not unique IN PER_JOB_EXTRA_INFO_F table for same job title.Summary: Integration is failing due to sql not returning data for INFORMATION_TYPE ='EIT'. In BIP report INFORMATION_TYPE is coded 'BMC Grade Details' How the INFORMATIO…Ankush_Jadhav 11 views 2 comments 0 points Most recent by Ankush_Jadhav Reporting and Analytics for HCM
-
How to automate the distribution of reports weekly to specific roles within the specific department?We need an automated system to distribute reports on a weekly basis to all users holding the Line Manager role within the Head Office department. How would I do that? Th… -
Dynamic Date parameter in OTBISummary: I have a requirement to get output depending on date parameter user will provide from prompt . how can i achieve this in OTBI report Content (required): Version…Sudipta007 591 views 8 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Logic to calcuate LOP days including the public holidays and weeklyoffsHi , I able to find of the absent days of employee for a month. Now i need help in deriving the logic to include weekly off and holiday if these days falls in between 2 …
-
Need help with SQL query for Time and LaborI have a query which times out with a single view, even after creating a report with it and scheduling it. When I raised this with Oracle support, https://us.v-cdn.net/6…
-
Is There an way to Default BI report Text parameter to logged in user person id like in Date typeIs There an way to Default BI report parameter to logged in user person id like we default System data in Date type parameter {$SYSDATE()$}. We have a Text parameter whi…
-
Financial report can't be opened in Excel formatWhen Financials report is executed in XLS format for multiple locations. The report can't be opened and its showing format error. (Note: If the report is generated for s…
-
Customer wanted to automate the process to send payslip over personal email for terminated employeesSummary: Hi Team, Would you please help us to get the steps how to achieve the requirement "automate the process to send payslip over personal email for terminated emplo…Rama123-Oracle 101 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
SQL unexpected token errorI have the below section as part of a long query that keep spitting out the error code: Encountered unexpected token: "(" "(" at line 188, column 13. Was expecting one o…alliebaker 64 views 5 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
How to report on worker attachments and correlate to the Performance Document they were uploaded in?Summary: Hi all, My organization has our workers uploaded attachments as part of their annual performance reviews. In attempt to properly maintain full performance recor…kdt8672 21 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Personal Payment Method HistorySummary How to find out if the Employee has Added, Updated or Deleted a Payment Method?Content Hi All, I am trying to build a Personal Payment Method History Report in w…User_2025-01-31-02-00-10-435 157 views 8 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
We need to create one OTBI analysis to display current and previous year calendar for Learning.Summary: We need to create one OTBI analysis to display current and previous year calendar for Learning . How can we achieve this? Content (please ensure you mask any co…Piyal Basak 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is there a way to restrict access in shared report foldersSummary: My colleague and I would like to be able to share reports with eachother but we don't want to others in the business being able to see or use them. Is there any…
-
Default Expense Account in HCM Subject AreasContent The Default Expense Account is a key field for our client that is used for reporting and security management. They would like to report on it in OTBI so they can…User_2025-01-25-01-23-28-110 333 views 4 comments 0 points Most recent by Nishant007 Reporting and Analytics for HCM
-
Is it possible get a output in text format from bip report oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 201 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM