Reports
Discussion List
-
Oracle Fusion - Process monitor - Process "NAME"Summary: Hi All, I am working on creating a report to have the list of job failed in a specific date range. I am able to get the required information from the ess_reques… -
"Unable to process your request" error in FRS when the default member is set to blank in promptSummary: When the default member prompt is set to blank, it throws an error saying "Unable to process your request." Content (required): The client's requirement is not … -
Impossible to open an OTBI reportSummary: Impossible to open an OTBI report Content (required): Hello experts, we have seen that, since a couple of weeks, a specific user is not able to open a report an… -
UE availability for Person Deduction Card (PAY_DIR_CARD_COMPONENTS_F) without Effective Date contextSummary: Is there any UE available for Person Deduction Card (PAY_DIR_CARD_COMPONENTS_F) without Effective Date context Content (required): Please be informed that there…
-
how can I get one seniority date when multiple seniority dates are there for a person in OTBISummary: I am reporting from Workforce Goals - Goal Status Overview Real Time and Workforce Management - Person Seniority Real Time. When I have Seniority Date showing, …challa praveen 316 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Dependent ReportSummary BIP that provides Dependent info (Name, Person Number, Age, SSN, etc)Content This a BIP that includes Dependent data (sorry, couldn't do an Answers report)Rick P Klassen 193 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…Nageshwaran1 40 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
How to take Length of service(in years), Service category and transfer detailsSummary: How to take Length of service(in years), Service category and transfer details? Content (required): Hi All, We got a BI report requirement to show employee's Le…
-
Data Lineage on the FAW HCM LearningSummary: Looking for Data Model / Data Lineage for FAW HCM Learning area. That will have the joins/ information relation between the entities. Can anyone help with that.…Moumita Samanta-Oracle 71 views 6 comments 3 points Most recent by Moumita Samanta-Oracle Reporting and Analytics for HCM -
What does it mean to have 'INITIAL' in the 'STATE' field in the hrc_txn_data table?When I query the records with 'DRAFT' from the transaction table, the STATE field is reflected as 'INITIAL' AND 'SAVED'. What exactly does INITIAL mean?Cansel Karasoy 11 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM -
How to configure a company's logo for all standard reports?Summary: Hi all, Thank you in advance for your help and support. I am trying to configure the client company's logo on Oracle Cloud for all the standard reports. Is ther…Paul Younes 555 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
How can I create dependent working parameters in SQL report?Hi, I have 'person number' and 'absence start date' parameters that I will use in my sql report and I have defined lov value set for them. But I want start date to come …Cansel Karasoy 51 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
How can I get mass results for Responses in Assessment?Summary: We assigned our organization (~7,200) a video to watch and asked everyone to answer a feedback question. All that was fine except now I am trying to report on a…Aaron Reynolds 32 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Removal of first two rows in OTBI outputHi Team, When we schedule the OTBI report with excel output, Output contains first line with header and next line is blank. Our actual output starts from third line. How…
-
Add "Business Object Type" and "Attribute" columns to the Delete Audit ReportSummary: We had a custom report called 'Delete Audit Report' and the client wants to add columns on it for 'Business Object Type' and 'Attribute' same on what we see on …Maria Cristina L. San Jose 38 views 1 comment 0 points Most recent by Maria Cristina L. San Jose Reporting and Analytics for HCM
-
Termination Headcount MeasureSummary: Subject Area: Workforce Management - Work Assignment Event Real Time, Assignment Event, Termination Headcount calculating terms on the last day of the month in …Rebekah Gilday 101 views 5 comments 0 points Most recent by Yves Blanc Reporting and Analytics for HCM -
User unable to create report in OTBISummary: User unable to create report in OTBI Content (required): Is there a request that must be submitted for users who have access to various subject area, but are un…CraigX 121 views 5 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
Assignment Event/Workforce Trends - Counting a Termination on the Termination DateContent Hello Experts! I'm using Assignment Event Real time and have noticed that terminations are counted the day after their termination date. I suspect it's counting … -
How to count terminations as effective on termination date itself?Summary Looking for ways to summarize terminations per period (i.e. monthly) based on the termination date itself, rather than the effective start date of the term actio…James Hoffmann 88 views 8 comments 1 point Most recent by Yves Blanc Reporting and Analytics for HCM
-
Bursting Report Definition: Email Subject and Body ConfigHi All I can use the the MemberAlias textfunction when naming the attachment file but I would like to use the function in the Email Subject and Message. Is there any way…
-
Can we access SOA MDS schema in fusion OBI reportsSummary: How to access SOA MDS schema in fusion OBI reports Content (required): We want to fetch business rules information in Cloud HCM through an OBI report. Is SOA MD…Hitachi ServiceDesk 21 views 0 comments 0 points Started by Hitachi ServiceDesk Reporting and Analytics for HCM
-
DATE_ADD function ErrorSummary: Hi Everyone! I am try to add specific year to the hire date using Date_add function, but it is throwing "Missing right parenthesis error". Could any one help me…
-
Fusion BI Report Output file name along with current date and timeSummary: Fusion BI Report Output file name along with current date and time Content (required): Hi Team Can someone help me how to add date and time in the custom BI rep…[Deleted User] 2.3K views 4 comments 2 points Most recent by Kavitha Balaiah Reporting and Analytics for HCM
-
Address change by DepartmentSummary: I need to be able to provide address changes only for certain departments. The Workforce Management - Person Real Time subject area does not appear to have the …
-
EPS element by delegate/EPS element by owner analysis not displaying hierarchy dataSummary: After Creating EPS element assigning delegate and assigning projects under it, when we run the EPS element by delegate/EPS element by owner analysis- these do n…
-
Resignation/Termination Approval- Current/Pending Approver DetailsSummary: Resignation/Termination - Pending Approver Details Content (required): Hi All, There is a report requirement to show Resignation/ Termination approval -> curren…