Reports
Discussion List
-
Smartview Error - "Unable to get property 'open' of undefined or null reference'Summary: I get the following error when running a macro to generate a report in smartview: "Unable to get property 'open' of undefined or null reference. Any assistance …Gregory Sokol 74 views 3 comments 0 points Most recent by User_P0CAG Reporting and Analytics for HCM -
Assignment Manager (Unsecured) significantly slower in Workforce Performance Subject AreasSummary: Material / significant slowness that appear to be driven by [Assignment Manager (Unsecured)] folder within Workforce Performance Subject Areas, relative to othe…
-
OTBI Dashboard only shows Indirect on promptSummary: OTBI dashboard is only showing Indirect in drop down prompt. Need to be able to choose between Direct and Indirect reports. Content (please ensure you mask any … -
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…Yaniv 664 views 18 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
I am trying to add Division to an analysisSummary: I am trying to create a "Master Employee Data" report that includes payroll information so I'm using the Compensation Details - Salary Details Real Time subject…Jenna Savage - Hunter Douglas 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HSDL Updates to Requisition are not captured in IRC_LC_HISTORY TableSummary: When a requisition is updated using HSDL and if EXT_PUBLISH_JOB_STATUS , EXT_PUBLISH_JOB_END_DATE columns are being updated without any change to phase or state…vinay karumanchi 9 views 0 comments 0 points Started by vinay karumanchi HCM Spreadsheet Data Loader (HSDL)
-
I am not able to fetch the pay value for Social Security DeductionsI am not able to fetch the Pay Value of Social Security Deductions For Oman Salary Payment Report in Oracle Fusion Cloud HCM . Can someone help me out with the query or …
-
BIP error oracle.xdo11g.xqxp.XQException: FORG0001Summary: BIP error oracle.xdo11g.xqxp.XQException: FORG0001 Content (please ensure you mask any confidential information): Hi Team, Greetings! We have run into error for…Parag Hiremath 19 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
how to convert blob type to actual text in oracleSummary: the underlying tables store the xml data of employees in blob format, the customer wanted to see the exact content of this File_data column in output results.. …Rama123-Oracle 6 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to Hide Row in BI Publisher Using Conditional RegionSummary: Hi Expert, I'm trying to hide a row based on a simple condition. We have three rows in the offer letter, and the condition is that if the attribute value is nul…
-
How to get one time data in audit tables after enabling auditing for HCM processes.Summary: How to get one time data in audit tables after enabling auditing for HCM processes. Content (please ensure you mask any confidential information): We have enabl… -
Generate a count of employee self service requests for certain employee data fieldsSummary: Is there a way in OTBI to generate a count of the number of times an employee changed personal information data in self-service over a period of time? My unders…
-
MMM-YY date format, grouping dates and showing same value in promptWhen doing the custom data format for a date field as MMM-YY, how can that be achieved in the prompt so that they're only having to select a single value for the month a…
-
Fetching Job Requisition with Sensitive Information in OTBIHi Team, We are fetching job requisition details from OTBI in the Recruiting - Recruiting Real-Time subject area. However, we also need to retrieve additional candidate-…Jeeva - Cloud Vantage 14 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…
-
Facing issue in RTF template(This exists with maximum width.)Summary: Trying to add two new extra fields in the existing RTF template is giving an error. (Error: This exceeds the maximum width.) Content (please ensure you mask any…Gunal Baskar 433 views 2 comments 0 points Most recent by UdayrajSingh Reporting and Analytics for HCM
-
Fast Formula with FF type "Extract Criteria" is not working when we are trying to add it in extract.Summary: Hi Team, We have designed extract to pull the employee assignment details but it was picking the multiple records for an employee. We used fast formula in "Filt…
-
Is it possible to add a Field Tag inside the Textbox in RTF TemplateSummary: We have a requirement to add name field inside a text box and add a photo inside a circle shape. I tired, but not able to add those fields. I even tired to add …Sujeeth Chinta 72 views 9 comments 0 points Most recent by User_OCKZO 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…
-
permissions to view only some reports by usersmy user should be able to see only Compensation and not the others. I have already created a role and assigned it but still nothing. I create this role and associate my …CamillaRossi 38 views 5 comments 0 points Most recent by Mohammed.Dawoud Reporting and Analytics for HCM
-
Sql query to get cost code effective start date and effective end dateSummary: Sql query to get cost code effective start date and effective end date Content (please ensure you mask any confidential information): Version (include the versi…Anup Karmankar 65 views 18 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM
-
adding different manager types to analysis reportsHello there, I have prepared a report from the analysis and in this report I would like to see the types of managers that people are affiliated with, such as head and ex…Sinem Kara 24 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Need a report to pull time change request details for time and laborSummary Need a report to pull time change request details along with manager comments for time and laborChaitanya Jogi 50 views 3 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 302 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM -
Need to generate a sequence number in outbound file at BIP. How to achieve thatSummary: Need to generate a sequence number in outbound file at BIP. How to achieve that Content (please ensure you mask any confidential information): Need to generate …Ishtiaque AHmed 30 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Please Help with Audit approval QuerySummary: The auditor has requested the dates of the last updates made to our Audit approval rules for the following areas: Job Offer Job Requisition Approval Termination…Global Support Desk 18 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How can the seeded compensation dashboards below for managers be customized?Can anybody suggest the right way to edit these seeded dashboards and do the customization based on our company needs. The need is to Add/ remove parameters Add/ remove …Sameeksha MN 18 views 3 comments 0 points Most recent by Sameeksha MN Reporting and Analytics for HCM
-
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …
-
Can report schedule can trigger notifications based on the notifications triggered in last 24hours.Summary: We have a requirement, where 2 reports are developed. And the first report is triggered manually and for the second report scheduling is required. Is there any …Gowthami Gorantla 27 views 2 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Cost of absence sicknesSummary: Report to show cost($ amount) of employee leave balances Content (please ensure you mask any confidential information): Hi Team, We have developed a report for …Thomas Samuel19 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM