Reports
Discussion List
-
Can multiple users be entering inline Notes in one report to different line items simultaneously?Summary: Can multiple people be working in the same report, entering Notes on different line items of an inline Note Template as long as a dimension member (like account…Stephanie Philopoulos 31 views 1 comment 0 points Most recent by Komala Reddy-Oracle Narrative Reporting -
How to return the max value based on a column?Summary: Content (please ensure you mask any confidential information): I've created a report using Workforce Learning - Learning Records Real Time subject area. The fol…Giuseppe Cannova 83 views 2 comments 0 points Most recent by Sai Darbha-Oracle Reporting and Analytics for HCM -
Oracle Best Practice of Creating Management Reports Remote Library (Planning) or NRSummary: Hello experts, we are in the process of building Budget Book with around 50+ Management Reports, need oracle's recommendations on the below 2 scenarios. Create … -
OTBI for Model Profile vs Person Profile Competency Gap AnalysisSummary: Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to pull Person Talent Profile Competencies ratings and Model…
-
Ability to view history for a Note in Narrative ReportingSummary: Is there functionality to view history for a Note aside from the original author and date and most recent modified by and date? Content (please ensure you mask …Stephanie Philopoulos 31 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
Model Profile vs Person Profile Competency Gap AnalysisContent Hi All, Wondering if anyone had a great analysis comparing the competency minimum proficiency level identified in a model profile to the assessed competency prof…Lauren Owen 142 views 3 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actualSummary BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4445, maximum: 4000)Content Hi, Can anyone please suggest a…Manisha Chakraborty 138 views 10 comments 0 points Most recent by Viswanadh Reporting and Analytics for HCM
-
Absence update history not availableSummary: Currently when the employee update the existing absence record and submit it, the back end does not hold both the data on the absence entry table. Unfortunately…Sobitha Venkatraman 1 view 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Data isn't retrived due to special character in Business Unit promptSummary: Hey, We have an issue with our Performance dashboard. The dashboard is based on OTBI analysis reports and the Performance subject area. One of our BU was create…Markovich Chen 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to identify C-Suite leader in headcount reportI'm trying to add a column that will identify our C-Suite leaders for each employee in headcount report. C-Suite leader would be the CEO - 1 or whomever is the top-most …S. Johnson 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What is a variable formula that uses the standard working hours converting our analysis to days?Summary: What is the formula that we can use for our Absence Analysis that will use "standard hours" (which isn't always 8 for us, sometimes it's 24, sometimes 7.25 etc)…MissHeidiJ 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence Report CalendarSummary: Hello Experts I have been tasked to develop a Calendar Report that looks like the attached as the screenshot system will be replaced soon. I am uncertain how at… -
url enrollement link otbiSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to retrieve data from excel dataset into Fast formula?Summary: How to retrieve data from excel dataset into Fast formula? Content (please ensure you mask any confidential information): I have this data model with excel base…
-
need sql query / table name to get system ip and host name Against transactionsSummary: i need to get system details against each transaction. ex: some one created 1 transaction then need to know through which system it got created (system ID , hos…Eswaraiah.chikkala 42 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Mail notification sending limitSummary: Hi Experts, Using Oracle Fusion HCM Cloud, is there a limit on the maximum number of people a BIP report can be sent using bursting? Regards, Sumit Upadhyaya Co…Sumit Upadhyaya 52 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Flow Ess job definition running long time.Hi, We have created a flow which will execute HCM Extract, While we ran the Flow it taking too long time, but separately if I run that Extract it is completing with in s…Kiran Kollamsetti 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Dynamic Fields Not Fetching in Journeys Report for Tuition Reimbursement TaskDear Oracle Community, I'm seeking assistance with a report issue I'm encountering in the Core HR module. I've created a report and linked it with a data model for the "…Sunil Kumar A 1 view 0 comments 0 points Most recent by Sunil Kumar A Reporting and Analytics for HCM
-
How to fetch Person Type from Assignment Details from Fusion TablesSummary How to fetch Person Type from Assignment Details from Fusion TablesContent Hi, I need to fetch Person Type (which shows value: 'Regular' in front-end Employee Ma…User_MC37Q 3K views 11 comments 0 points Most recent by Manu Choudhary Reporting and Analytics for HCM -
Release 12 HCM OTBI Subject Area descriptionsSummary List of Release 12 HCM OTBI Subject AreasContent This spreadsheet provides the list of HCM OTBI R12 subject areas with descriptions, business questions answered …Raghavendra Raghunath-Oracle 945 views 11 comments 10 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to retrieve Opening Lease Liability calculations for Migrated LeasesSummary: Query to retrieve Opening Lease Liability calculations for Migrated Leases Content (please ensure you mask any confidential information): Per the Lease Migratio…Janelle Azimullah-Oracle 117 views 1 comment 0 points Most recent by Swetha Manupati-Oracle Lease Accounting -
Financial Reporting Book, but no data is coming up - only showing as blankSummary: We have a Financial Reporting Book, but no data is coming up - only showing as blank. When I run directly run the report, I can see the data, but when it is def…
-
Unable to test Connection while using SFTP serverSummary: Hi Team, While is try to add a new connection with SFTP server, by giving all host, port , username and pwd and try to establish connection , it is getting fail…Dhilipkumaar-Oracle 64 views 2 comments 0 points Most recent by Dhilipkumaar-Oracle Reporting and Analytics for HCM -
How to retrieve audit reporting details concerning attachments like f.ex. Document of RecordsHi, Our client would like to have an Audit Report that generates the creation, update or deletion info of a Document of Record (with related user data of course; resp. w…
-
SmartView and ProjectsSummary: Hi, I am looking for help/guidance if Smartview can be used with project information. Hundreds of projects are used to track IT spend using one account. Use cas…Larry Greenblatt 21 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Project Management
-
We looking Variable pay plan details in OTBI for which subject area need to use ?Summary: Hi Team, May I know which subject area need to use for Variable pay plan details as per below screen shot. Variable pay plan details: Content (please ensure you…AjayKumar Maddipati 11 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Employee details at the time of the absenceI would like to report on the worker details at the time of the absence. If for example an employee changed department today, the absence from last year would show the d…NusratB 42 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Associating Independent and Dependent Value Sets to BIP Report Parameters in Oracle Fusion HCM CloudSummary Associating Independent and Dependent Value Sets to BIP Report Parameters in Oracle Fusion HCM Cloud – A Worked ExampleContent The business requirement is to cre…AshishERPCloud 160 views 3 comments 5 points Most recent by Dasari Dileep Reporting and Analytics for HCM