Sample Reports
Discussion List
-
In BI Report we getting dupilcate records as per ui but we need only one recordSummary: HI Team, We have exist interview survey status report but we getting dupliacte reocrds nearly 700plus. due to report takes as per ui but in ui some of employees…AjayKumar Maddipati 31 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Unable to join Invoice and Procurement Subject Area in OTBI AnalysisSummary I have a requirement to fetch the Purchase order details with corresponding invoice details. Therefore i need to connect two subject areas to fetch the required …Santosh V-228136 650 views 8 comments 0 points Most recent by Khassham Khan Reporting and Analytics for ERP -
Best subject area for pulling "Worker"."Work Email" into OTBI?Summary: Current Subject Area Used: Workforce Management - Worker Assignment Real Time Columns: "Worker"."Work Email" OR "Worker"."Employee Email Address" Content (requi…William_Johnson 41 views 3 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM -
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Need help on calculating Hash Total for National Bank of Kuwait EFT templateSummary: is there any ready to use code to calculate hash total logic in oracle etext template to make a payment to National Bank of Kuwait Content (required): Hash tota…SireeshaJaladi 31 views 1 comment 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP -
Post Conversion validation reports for Core HR moduleHi Team, Could you please help us with the Post Conversion validation reports for the Core HR module? We need the following reports. Please share with us if you have eit… -
we have OTBI Report skills and certfications but it showing unparallely ?Summary: HI Team, We have report facing this is how can sorted Content (required): Version (include the version you are using, if applicable): How it looks in the report…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Prepare Review Content example reportsSummary: Prepare Review Content Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to better engage our e…William_Johnson 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Workforce Talent Review - Talent Review Tasks Real Time reporting bug?Summary: How can we pull a report using this subject area to provide an administrative overview of all existing tasks in a Talent Reviews within the system? Content (req…William_Johnson 21 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM -
Attrition Rate DashboardSummary: Hi Everyone, I am just wondering, if there is any seeded dashboard available to fetch the information about the attrition rate. Thanks in advance. Version (incl…ShawShankk 101 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to pull rehire date in OTBI REPORT?Hi Team, How to pull rehire date in OTBI REPORT? ThanksSM_EP 211 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Application usage reportHow long the audit data has been captured without doing any configuration related to the application usage insights? What is the minimum time period (days/months/years) …Sangeetha Kumar 121 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to find deeplink for Allocate Checklist page?Summary: How to find deeplink for Allocate Checklist page? Content (required): Hi All, How to find deep link for Allocate Checklist Page? From Tools -> deep links , i go… -
In Xsl template we are getting error like:sun.util.calendar.ZoneInfo cannot be cast to java.util.SimSummary: Hi Team, Hope everyone is doing good! We have an requirement, where we have to use Current date condition in xsl template as mentioned below, but we are getting…MaheshRayudu7 61 views 2 comments 0 points Most recent by MaheshRayudu7 Reporting and Analytics for HCM -
Better approach to follow in loading manpower or salary costsSummary: Which is the better approach to follow when HCM is not used a) Uploading salary costs to the General Ledger (GL) and subsequently uploading them as costed trans… -
How to restrict Effective Date parameter in schedule process, not to generate on specific DatesSummary: We have an ADP Payroll Extract. During the scheduling process, where in Effective Date Parameter should not pass Saturdays,Sundays and should consider every alt…MaheshRayudu7 51 views 1 comment 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below.Jeff Hare CPA CISA CIA 221 views 6 comments 2 points Most recent by Pallavi S Reporting and Analytics for ERP -
Just like for each that populate several rows in Excel Template, can we do the same for columns?Summary: Hello, For the Recruiting module, our client wants to have a report that dynamically populates the Questions found in Questionnaires of Job Requisitions based o… -
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 83 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Is there a way to get the Stop Date for Initiatives to populate if I want to make a report from hereSummary: We would like to be able to see when initiatives will stop so we don't miss making a new one. Is this something that can be done or do we have to keep our own s… -
We have developed OTBI Report issue with output formatSummary: Hi Team, We have developed OTBI Report but issue with output format that is when try to export the report in csv or excel we getting multiple records please fin…AjayKumar Maddipati 43 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Performance Task Status subject area is not pulling data belongs to old org structure.Summary: Performance Task Status subject area is not pulling data belongs to old org structure. Content (required): We have created new organization structure version in…Swati U 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to fetch Arrear balance details for terminated EmployeesSummary: Content (required): Hello, Our requirement is to fetch the arrears details for the terminated employees, adjust them accordingly. Deduction report has a section… -
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 -
OTBI:Individual Comp: Single row with Award Amount and Frequency in spite of data model constraints1- Below OTBI report has been built using "Compensation - Individual Compensation Real Time". It provides insights into the Awards awarded to an employee and the frequen…Abhishek Dixit-Oracle 61 views 2 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM -
Developing of a Report to capture Requisition Approval HistorySummary: We require to capture the approval history of Requisitions. Such as who the requisition is currently pending approval, who has completed approval, the next appr…Janitha Perera 814 views 9 comments 0 points Most recent by Janitha Perera Reporting and Analytics for ERP -
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 -
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… -
Custom Report example for PPM Allocations ?Summary: Custom Report for PPM Allocations ? Content (required): Hello I would like to create a custom report for PPM Allocations, will you please share with me the tabl…Cesar Saveedra 41 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management -
We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference?Summary: Hi Team, We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference? what is the main purpose of ESS JOB . How can we u…AjayKumar Maddipati 115 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM