Category 81
Discussion List
-
User Login report.Summary: Looking for report which provides number of user login into Oracle HCM Content (required): Version (include the version you are using, if applicable): Code Snip…Prabhu Krishnamoorthy 401 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Is it possible to pick multiple selections (that add up) in the POV of reports?Summary: Is it possible to pick multiple selections (that add up) in the POV of reports? This would be similar to how it behaves in Pivotables in Excel as per the screen… -
Ability to resize Dashboard on a pageSummary: Hi - my organization is currently working on implementing Oracle Learning and I was playing around with the Administrator Dashboard: The goal was to see if we c…
-
Duplicate required assignments created for the same employeeSummary: A learning admin accidentally duplicated a required assignment which was based upon an OTBI analysis. The users were duplicated and when they login they see two… -
Formula rows/columns from reports in ad hoc gridsSummary: Hi all, As I was opening reports in Smartview, I noticed that my formula rows / columns from the reports are not imported (everything is there accept for the fo…
-
OTBI report on Contract. Unable to find Contribution Percent present in Contract Billing pageSummary: OTBI report on Contract. Unable to find Contribution Percent present in Contract Billing page in any subject area. Content (required): OTBI report on Contract. …Shashank Verma-Oracle 31 views 2 comments 0 points Most recent by Shashank Verma-Oracle Project Management -
Report on names of attachments attached to Document Record TypeSummary: Is it possible to generate a report which lists all names of attachments attached to the document type? Do not need to be able to download the file just want to…
-
Aggregation function like stringagg() is supported in oracle BI queriesselect string_agg(goal_name,',') from (select distinct goal_name from HRG_GOALS) t Received ORA-00904: "STRING_AGG". invalid identifierChandra Thangavelu 121 views 1 comment 0 points Most recent by MandeepGupta BI Publisher Learning Center
-
What role is needed to run ESS job Vertex Payables Transaction Tax Action Report ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Anthony Cambria 71 views 4 comments 0 points Most recent by Murali Gangidi Reporting and Analytics for ERP
-
W_2 document delivery preference reportSummary W_2 document delivery preference reportContent Hi All, Recently we enabled W_2 consent functionality enabled. Is there any seeded report to get the details that …Peoplesoft 42 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Need Employee wise data where Checklist Response Text and Response answer in same row using OTBITrying to create an OTBI report from a survey which consists of both Response answer type and Text answer type questions. The report should show employee details, checkl…
-
How to see how many API's are being called in an environment?Summary: Is there a way to see how many API's are being called in an environment? Content (required): Looking for a report or somewhere in the UI where we could see the …
-
performance between xmlpserver/services/ExternalReportWSSService versus more api rest in integrationSummary: performance between xmlpserver/services/ExternalReportWSSService versus more api rest in integration on oic Content (required): hello I could to know that diffe…Alessandro_Moccia 21 views 0 comments 0 points Started by Alessandro_Moccia Reporting and Analytics for ERP -
Is there any way to change the order of displaying prompts in Run Time Prompt Window - ReportsSummary Looking for option to change the order of displaying prompts in a Run Time Prompt Window (Financial Reports)Content Hi All I'm looking for option to change the o… -
BIP: How to create 'Year' parameter?We have a requirement to provide Year parameter as a dropdown in BIP report. It should default to current year, and allow users to select any other year from the drop do…Anshul Rai 71 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to avoid overlap labels in BI Pie chart?Summary: Our customer is using HCM cloud and developed some dashboards and it has some pie chart and labels are overlapping each as shown in the attachment. How to fix t…Peoplesoft 51 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Tables in BIPSummary: Hello does anyone know the table where I can get these? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any co…Hazel De Castro 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
BICC - ability to product a single CSV output merging data from many data stores/VO'sSummary: Does BICC support selecting columns from different data stores/PVO's and apply query filter? Content (required): We have a business requirement to extract large…Arun N-OC 373 views 8 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Customize Receivables aging seeded ReportSummary Customize Receivables aging seeded Report - to include Project information and grouping totalsContent Hi, We want to customize Receivables aging by General Ledge…User_V0Y9V 647 views 7 comments 6 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
BI Publisher Excel TemplateSummary: How to display a column conditionally in BI Publisher Excel Template? Also I want to display a hard image in excel based on condition of data source in excel te…
-
Security Console Audit Report?Summary: I am looking to build a report to show when changes to team member's security profiles were changed in Security Console, and when they were changed. I can't see…
-
Need a report to find Learning InitiativesHello Team, I am looking for a report to fetch the learning Initiatives data(Setup data). That would be great if anyone can help. Thanks, Minatiminati_behera-Oracle 42 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need help with CAST formulaSummary: I have a report using Subject Area Recruiting - Recruiting Real Time. I need to calculate the number of remaining openings (Number of Openings - Hired Count) mu…
-
How to remove a subject area access from duty role?Summary: How to restrict subject area access in a duty role? Created copy of "Absence Management Transaction Analysis Duty" role. Want to remove "Payroll - User-Defined …K Qureshi 82 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Facing Issue with Multiple Adjusted Service DatesSummary: Trying to run service anniversary reports using our adjusted service dates. However employees have multiple adjusted service dates and need the report to only p…Dannielle Dellucci 101 views 19 comments 0 points Most recent by Rahul.Yarlagadda-Oracle Reporting and Analytics for HCM
-
Can an extract generate the 4 different templates based on different conditionsSummary: Hi all, I am working on a requirement where I have to generate 4 different templates based on the different condition. I have built the extract which is fetchin… -
Create Individual Compensation History reportSummary: I need to create a report of historical individual comp data, to include only additional comp like bonuses and such - No regular salary needed. I’d prefer to do…
-
Remaining questions and answers from the “Learning Records Real Time” OTBI Subject Area presentationWe had a really good and lively Q&A session in this presentation. We had so many questions that we didn't have time to address all of them. So here is a list of the ques…