Reports
Discussion List
-
Creating a Report Book in EPBCSSummary: Content (please ensure you mask any confidential information): Hi, We have created bunch of reports (not financial reports) in EPBCS and resides in Navigator→ R… -
Can you pull columns from one OTBI analysis report to another like a Vlookup?Summary: We have created a Checklist Task which has a DFF that generates a Person Number ("Checklist Task Details"."PER_PERSON_ALLOCATED_TASKS_DFF_DESC_NOMINEENAME_") an…Stephanie McInnes 221 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Role for OTBI reportSummary: Role for OTBI report Content (please ensure you mask any confidential information): Hello experts, we have created a custom role (BI-Abstract) that allows users…Oriana L. 11 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 81 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 140 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 41 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 51 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 2.9K 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 943 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 112 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 61 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