OTBI
Discussion List
-
Will selecting Application Role within Report Agent set up secure the rows based on AORs?Summary: Hi all We want to create an agent that sends the results of an OTBI analysis to our HR Business Partner population. If I add our application role for them will … -
Actionable Dashboard for AP Invoice Approval in Oracle Fusion CloudSummary: To approve bulk invoice all columns are not available in the worklist where the approver can view the columns and select and approve. So can we create a actiona…Jagjit Singh Arora 125 views 0 comments 0 points Started by Jagjit Singh Arora Payables, Payments & Cash Management -
We have a requirement to fetch salary component calculation columns in OTBI and a stat graph.Summary: We have a requirement to fetch all these calculation columns in OTBI as we have partially developed the solution in BIP, but client want this in OTBI so can we …Kumar Rajgeet 41 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Grade MidpointSummary Joining Worker Assignment Real Time to Grade Rate Real TimeContent Hi, we're currently building reports for use in UAT ahead of upgrade to Cloud next year. I've …User_2025-02-08-05-56-00-229 18 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Grade Step DetailsContent Good Day, Within Report creation in OTBI we are trying to report on all Grade Step Levels from Grade to Step to Ceiling etc. But we are unable to find the "code"…User_2025-01-28-07-12-45-467 130 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Grade Step in OTBISummary Workforce Management - Worker Assignment Real Time does not display current gradeContent Hi, Does anyone know which subject area would give me Grate step values …User_2025-01-31-00-03-33-089 305 views 25 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to get results when pulling Grade data in with Job Structure dataSummary Report fails when fields from Grade Rate Real Time are pulled inContent Using two subject areas: Workforce Profiles - Model Profile Real Time and Workforce Manag…User_2025-01-28-20-43-56-568 37 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Comparing columns from two different Analysis areas.Summary Comparing columns from two different Analysis areas.Content I am attempting to grab Job Codes for employees and the grades for the jobs. In the analysis i am usi…User_2025-02-10-19-21-48-801 36 views 14 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Issue with Grade Rate Real Time Subject AreaSummary Grade Rate value is not returnedContent We had a requirement to display all workers who has a current salary not equal to the current grade step rate value i.e, …Akash Kiran Jana 26 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Newly Created Supporting References not showing up in OTBI ReportSummary: I created two non-balance carrying supporting references - see steps I followed below. After creating these, I ran the following query within Reports & Analytic…Akbar Ahmed 136 views 1 comment 0 points Most recent by Akbar Ahmed Subledger Accounting & Accounting Hub -
How to report on missing Costing of Positions?Summary: Content (please ensure you mask any confidential information): I'm trying to find a way to report on Position Costing that is missing. In the 'costing of positi…Leanne W 131 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Is there a way to pull service accounts into user admin reports?Summary: Currently our existing user lists only pulls users who are employees in the system. We need to be able to pull a list of all accounts as we have service/generic… -
Parameter definition in reportI will use the last_update_date parameter in the report I prepare. But I want to use the last_update_date column in more than one table in a single parameter. For Ex: pe…Cansel Karasoy 21 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
manager hierarchy analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Bhagyashri_Bhoge 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SCM – PRC: Finally Close POs Using Oracle Integration, 20 August 2020, 9 a.m PT - Submit QuestionsContent Submit your questions for the SCM – PRC: Finally Close POs Using Oracle Integration session to have them answered during the live event. Post your questions by p… -
Standard template Compensation Change statements notificationContent Hello experts, I need to change the notification template the employee receive when Compensation Change Statements is available in Person Information> My Compens… -
How to use Listagg functionality in OTBI AnalysisSummary Listagg in OTBI reportsContent Hi Team, Listagg function in OBIEE reports is used to display multiple lov's in a a single row with (,)separator. How can we achie…Kalyani Koylada 989 views 8 comments 0 points Most recent by Tonya H Reporting and Analytics for HCM -
Only display the row with the earliest seniority dateSummary: Hi I'm creating a basic staff list which has seniority date on (some of our staff have protected service from a previous company) and I need to be able to show …HRJon 41 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to get latest anniversary seniorSummary: How to get the most recent date to show on an employee transaction Content (please ensure you mask any confidential information): In OTBI, using the subject 'Wo…EllieG 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a way to automatically trigger a scheduled job if it encounters failure on scheduled run?Summary: We have one file that was not sent to SFTP location as there is a connection issue in the SFTP as there is an emergency change in SFTP. In Oracle BI Publisher, …Cristelle Rose Sampang 81 views 3 comments 0 points Most recent by Narula Shray Reporting & Analytics for Sales -
How to add the EEO 4 field from Job to a OTBI report?Summary: Adding EEO 4 field to a OTBI report Content (required): Hello - how can you add the EEO 4 field to a OTBI report? I am able to locate the EEO-1 field but not EE…Jbow 51 views 1 comment 0 points Most recent by Shashank Priyadarshi - Oracle-Oracle Reporting and Analytics for HCM -
Payroll - Calculation Cards Real TimeContent Good Morning, We are trying to find granular details with regards to Pension details. On the front end we can see in a sub-folder called 'Calculation Component D…User_2025-01-28-07-12-45-467 185 views 7 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Receipt Adjustments ReportHi, Please let me know if we have any report to see Receipt Adjustments (Return To Vendor and corrections transactions) by REQ or PO (something like Receipt Adjustments … -
Report to get employee default expense accountSummary Report to get employee default expense accountContent Hi is there any report which can get what is the default expense account attached the employee please? this…User_2025-01-29-02-09-34-137 103 views 13 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM -
How to export OTBI Dashboard Section Permission?Summary: I am looking for an option to export the permissions granted at each section level. Is this possible? I attached the screenshots. I appreciate your help. thanks…SantoshKumarBhairi 11 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
General help -> Unable to access oracle.comSummary Unable to access oracle.comContent hello, Is anyone facing this type of issue? I am unable to access any site within oracle.com. Nothing changed in my browsers a…SantoshKumarBhairi 196 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
It is possible to add an additional is column in the Bank Statement Transactions dashboardSummary: There is a native cash management dashboard that shows bank statement lines, their status and other information. It is required that an additional column be add…Cezar Mata 82 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Payables, Payments & Cash Management -
Value as columnTeam, The timecard layout has been configured and there is a custom attribute created like below. PROJ_FUNCTION - AttributeVarchar1 We have got the above details from on… -
How do you add a parameter to a seeded data modelSummary: How do you add a new parameter to a seeded data model? Content (please ensure you mask any confidential information): Version (include the version you are using…CarmenR. 11 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections