Reports
Discussion List
-
Not able to send Bursting output zip file to mail as it exceeds the limit of 10MBI am using legacy distribution file, for generating the reports in a folder structure. I can not split the entity list in the file as i am extracting the reports in a fo… -
Career Site Metrics ReportSummary: Does anyone have Career Site metrics report based on Candidate Tracking subject area in OTBI? Content (please ensure you mask any confidential information): Doe…AvinashP 1 view 3 comments 0 points Most recent by Durga Magar-232055 Reporting and Analytics for HCM -
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…Adil_R 276 views 14 comments 0 points Most recent by Srinivas_Godari Reporting and Analytics for HCM
-
The Multiple Natural Accounts selected in Single row But Data showing in multiple Rows in FRS OutputCreated FRS Report , One Row We selected Multiple natural account in output data Showing Multiple rows, Expectation Is : Should be appear In Single RowRama Mohan ReddyB 34 views 3 comments 0 points Most recent by Pradnya Bhosale Reporting and Analytics for ERP
-
how to calculate average percentage of Budget Utilization in workforce compensation module?Summary: My requirement is to find out the average percentage of Budget Utilization in workforce compensation module. How can I derive that? Content (please ensure you m…Pritha 12 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Issue with Error Message and Reported Hours in OTBI Report for Imported Time EntriesSummary: After submitting the process “Process Imported Time Entries”, a few time cards are erroring out. I need to build an error report that shows: Person Number Time …Raghavendra M 31 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera…
-
Row width changes with multi line commentary in narrative reportingWe have a notes template column in the report, but when we enter any commentary which is bulleted or multi line, the row width changes and the report and package do not …
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
Schedule process runs on working daysHello, Is there a way we can schedule a process for a BIP report which runs first 8 business days on hourly basis and from 9th day to end of month to run daily basis. Pl…
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…Bernadette Dorris 382 views 1 comment 3 points Most recent by amarzhc Reporting and Analytics for ERP
-
Administrator and role report from Oracle Cloud InfrastructureSummary: I am required to provide my InfoSec team with a report of Administrator users and their role in Oracle Cloud. Please advise how best to achieve this Content (pl…David Boudreau 11 views 0 comments 0 points Started by David Boudreau Identity and Access Management
-
EPM Reports too slowFew months ago we completed the migration of our reports from Financial Reports to Reports. Overall, they are very similar, however one common feedback we are getting fr…
-
Is it possible to exclude the Entity in a formula column in Management Report with NonConsol method?We have the connection setup with FCCS and we are comparing the direct pull for Consolidated Balances & Formula Column ( Sum of Children+Elims+Adjustments). We are tryin…Shilpa_S3 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
BI Table with ActivityAttemptId or the ActivityAttemptNumberSummary: Hi, I need to load LearningRecordActivityAttemptV3 object. To use LearningRecordActivityAttemptV3, I need to uniquely identify the rows to update using either t…Camilla Crescenzi 131 views 2 comments 0 points Most recent by DanWoodward Reporting and Analytics for HCM
-
Need SQL query to get the report category details based on the HCM Extract nameSummary: Need SQL query to get the report category details based on the Extract name Content (please ensure you mask any confidential information): We need SQL query to …
-
ICP Matching Report displaying incorrect EntitySummary: Content (please ensure you mask any confidential information): Hi all We have an issue where our ICPs Matching Reports are displaying incorrect Entity which are… -
How to extract records for a specific date that is in CURRENT_YEARSummary: I have an OTBI report showing all employee terminations. What formula can I use to return only terminations in the CURRENT_YEAR? Field is "Worker"."Termination …
-
-
Headcount and salary report with as of date using Workforce Assignment Salary History Real TimeSummary: Objective: To create an analysis with headcount (aka assignment) and salary data. Issue summary: We believe [Compensation - Workforce Assignment Salary History …bwdata 72 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Repeated Heading property is not set to Hide by defaultSummary: As per the Nov patch "Repeated Heading Property Support in Reports" says that by default it will be set to Hide, but we see its set to Default Has anyone else e…Tejaswini Kulkarni 41 views 5 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Ability to scan all reports for specific fieldsSummary: Hi - We recently introduced a second Organization tree where we have only had 1 tree since our initial go-live in 2018. With the addition of this new tree, anyw…
-
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 183 views 9 comments 0 points Most recent by User_O1LQ5 Reporting and Analytics for ERP
-
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERRORChanikya Neelam-Oracle 21 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
query to get timecard calculation for an employeeCan anyone help me getting sql query for calculated quantity in Timecards entries of an employee.
-
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe…
-
Subject area for Employee data (About me)Summary: Hi All I am trying to create a report on employee's 'about me' section. Not too sure what subject area/table to use for this? or if someone has something made a…Jeevan Loyal 41 views 6 comments 0 points Most recent by Jeevan Loyal Reporting and Analytics for HCM
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…
-
How to Query Cost Code from Oracle Fusion HCM OTL Time Card Tables?Summary: Hi Community, I need help identifying which table/column stores the Cost Code information visible in the OTL Time Card interface in Oracle Fusion HCM. Context: …Vishal Purohit 52 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
Check member usage in reportsIs there a way to know in how many reports is a particular member used? For example - If I want to see which reports have the member FCCS_Total Assets used in them. Is t…