Reports
Discussion List
-
POV or Prompt for a Single Fiscal Year That Works for Two Different DimensionsSummary: I am working on a report in narrative reporting that pulls data from our ERP GL and EPM Planning applications. The ERP GL has an Accounting Period dimension whi… -
I need a unique users report in HCM Fusion.Summary: User Audit Report. Content (please ensure you mask any confidential information): Hello, everyone! I need a report or query that allows me to identify unique us…Alexandre Paes 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
FCCS MR: Is there a way to disable or lock the Grid POV ellipsis to prevent invalid POV selections?I am working on a Management Report in FCCS that uses a Global POV and two grids, each with its own Grid POV containing specific hardcoded members except the Movement di…Patrick Pontillas 21 views 5 comments 0 points Most recent by N.S-Oracle Financial Consolidation and Close
-
FCCS Report Bursting FunctionalityWe have been testing the bursting functionality but are unable to get the report to display the alias automatically when using bursting. Is there a way we can use the "A…MehryaarAnwar 71 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
OTBI Analysis Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversionHello, I'm getting the error in my OTBI Analysis: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion when I add a column Called "Requirement Text" fr…JessSantos 21 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Requirement is to display image uploaded in DOR in BIP reportRequirement is to display image uploaded in DOR in BIP report. I am able to get the UCM content id how to get the image that was uploaded in XML to use in RTF ? select f…
-
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…Sankaran Lakshminarayanan 2 views 2 comments 1 point Most recent by Venkat Vatikuti Reporting and Analytics for HCM
-
help with if/then formula in EPM ReportI need help with a formula in a report. As soon as I add the subtraction part to the final part of the statement i get an error. This works: IF(IsMissing([G]), 0, [F]) T… -
Blank page appears end of report in RTF template even though conditional split page is used.We are encountering an issue in a BI Publisher RTF template where an extra blank page is generated at the end of the PDF output. The template uses a conditional page bre…Sai Teja Madishetty 45 views 1 comment 0 points Most recent by Yemi Onigbode Reporting and Analytics for ERP
-
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…Elliot Hall-Walker 326 views 4 comments 1 point Most recent by SR_1234 Reporting and Analytics for ERP
-
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…Akhil Vutukuri 2.3K views 3 comments 0 points Most recent by Ashish1Soni Reporting and Analytics for HCM
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
Participant Feedback Report including feedback from 360 performance - need helpSummary: Hi there, hoping someone could help me out: This report using Subject Area: Workforce Performance - Requested Feedback Real Time does not include the participan…
-
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every…
-
NR Chart Legend Label/Text Cuts Off or Not Displaying in fullHi Everyone, Anyone know if there's a way to get this label text to display in full? The legend doesn't seem to be adjusting for the longer member alias. I found a KB ar…
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
HCM alerts real time Subject Area - data not returningSummary: HCM alerts real time Subject Area - data not returning Content (please ensure you mask any confidential information): Hello I am trying to write an Analysis usi…
-
Machine learning files - CausalityAnalysisPromptTemplateSummary: what is the best way to update this machine learning files to show my data without %. Do I take a copy of an existing example, or do I write my response based o…
-
How to report on journey task expiration configuration?Summary: Is it possible to report on journey task expiration configuration (i.e. Task 1 expires 10 days after assigned date, Task 2 expires 10 days after due date, etc.)…
-
Lease details report showing values in adjustment column for ROU but not for lease liabilityWhen a lease is amended, the lease details report is updated with the adjustment amount for both ROU and lease liability balances. However, upon amending the same lease …
-
Can we filter the data in reports based on smart list member?Summary: I am preparing one report where i am using smart list. I have smart list member created like - Bank Overdraft,Term Loan, Lease Liabilities and i am recording va…Chakresh 52 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
How to fetch the survey section from Performance DocumentHello Experts, Does anyone know where in the tables to fetch the Survey section from performance document? Please Help! TIA
-
Query to get Scheduled BIP Jobs in Oracle Fusion HCMHi All, Is there a way to retrieve the schedule details of BIP reports like job name, report name, schedule start date, schedule end date, frequency etc. using a sql que…Dhanuka Chamal 1.3K views 4 comments 5 points Most recent by gclampitt Reporting and Analytics for HCM