Reports
Discussion List
-
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 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 "…
-
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 944 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 111 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
-
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 43 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 -
How to default the Location of Logged In User in Dashboard PromptSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Narendar Rao Naineni 21 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Can we restrict Benefits/Compensation Specialist from accessing Element Entries?Summary: Element Entries in BI Publisher Reports Content (required): For a client, with different legal entities, in reports we are making use of secured views at assign…VDoolhur 21 views 2 comments 0 points Most recent by Ramona Popescu-Oracle Reporting and Analytics for HCM
-
Protecting Sensitive Data in Custom ReportsWhat is the most effective way to provide managers with access to custom reports without exposing sensitive employee data, such as ethnicity, date of birth, home address…Rashi_Churiwala 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
SQL to get the list of permission assigned to Dashboard SectionSummary: SQL to get the list of permission assigned to Dashboard Section Content (please ensure you mask any confidential information): Version (include the version you …ISHWTW 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
SQL Query for Learning Plans and ProgramsSummary: Hello I need a query that gives the following attributes in the Learning module: Program Name Plan Name Plan Profile Name Plan Profile Creation Date Content (pl… -
SCORM ReportingContent Has anyone had any success with creating a SCORM report in OTBI or BI? Would really appreciate help with this. Many thanks MelissaUser_2025-02-06-11-18-47-896 34 views 13 comments 0 points Most recent by Teja Arepalle Reporting and Analytics for HCM -
Is there any seeded report that employees can use to list personal data stored on them?Summary: We have a request to make available in ESS a report to list all personal data stored by the company on the employee. Is there any GDPR seeded report for this? T…Lluis 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report for Screening Services on Requisition TemplateWe are trying to report on screening services (Assessment and Tax Credit) on job requisition templates but when we output fields from Job Requisition Template - Screenin…Samiir S 41 views 2 comments 0 points Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM
-
SQL to Show Which Pay Frequency is Associated to Which Legal EntitySummary: I am tasked with producing a mapping document of which Pay Frequencies are associated to each legal entity. I can find the Legal entities in "HR_LEGAL_ENTITIES"…Mickey James 51 views 2 comments 0 points Most recent by Mickey James Reporting and Analytics for HCM
-
Selecting multiple default values in prompts in BI reports and OTBI AnalysisContent I have a requirement where I need to select multiple values in the prompts in the BI reports and OTBI analysis. For example: Consider the column 'Assignment Stat… -
Table name for Assign As column in learning pageHi Experts, Can someone please help me with the table name for 'Assign As' column. Thanks & Regards, DineshDinesh Jaini 11 views 1 comment 0 points Most recent by Dinesh Jaini Reporting and Analytics for HCM
-
Person Seniority Real Time not showing resultsSummary: The "Person Seniority Real Time" subject area is not returning any results, even though we're currently using the Seniority Dates V3. Does anyone have a solutio…Martijn van den Berg 21 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM