OTBI
Discussion List
-
Can user view reports on approval routing based on purchase categories?Summary: Users want to see reports on approval routing based on purchase categories. Content (required): Version (include the version you are using, if applicable): Code… -
Unable to join the UDT subject area to the Assignment subject areaSummary: Unable to join the UDT subject area to the Assignment subject area Content (required): In the OTBI side, we are referring two subject areas. Based on Terminatio…
-
Need to Create OBTI Report that shows a list of learning Items by Dept.Summary: We need to create lists of learnings that are assigned by Dept. Please provide suggested criteria to get this information. Content (required): eLearning assignm…
-
How to fetch the direct and indirect report details in OTBI based on manager details parameterSummary How to fetch the direct and indirect report details in OTBI based on manager details parameterContent Hi, We are in REL 13 20D. I am working on the Performance r…Radha Devi P 776 views 4 comments 0 points Most recent by User_9B8T4 Reporting and Analytics for HCM
-
Table details which stores Payment System Account name in Payment Process Profile setupSummary: We need table details which stores Payment System Account name in Payment Process Profile setup task Content (required): Version (include the version you are us…Nishanth B Jain 91 views 5 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management -
Compensation Details (Top of Stack) when End DatedSummary: Hi - We are looking to create a report where we are able to audit active employees where their salary was incorrectly end dated. The problem is that when the sa…Kyle Norris 72 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to generate vendor purchase summary report in oracle fusion?Summary: Content (required): Vendor Purchase Summary report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01…
-
How can I get an interaction to filter on 2 columns at once?Summary: I have created a graph to show male/female by Grade level. I created an interaction to drill down to a report, however the interaction is only filtering on eith…Dannielle Dellucci 41 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
Report to get the list of employees with multiple active relationshipsSummary: Report to get the list of employees with multiple active relationships Content (required): Hi Team, Greetings! With Global Transfer- there are some cases observ…Parag Hiremath 334 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Is there a way to encrypt the scheduled reports?Summary: Is there a way to encrypt the scheduled reports Content (required): We are looking into scheduling reports but we need to make sure there is an encryption in pl…Balazs Grajczar 81 views 6 comments 0 points Most recent by teresa.marciano Reporting and Analytics for HCM -
Payroll Element and Related Elements InformationSummary: Payroll Element and Related Elements Information Content (required): In the Payroll Element screen we have Related Elements. We need to know in which table/subj…
-
SQL for Element Status Processing RulesSummary SQL for Element Status Processing RulesContent We are looking for a SQL to display element status processing rules where we attach the element to a fast formula …User_2025-02-01-07-38-26-148 176 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Reporting and Analytics for HCM -
Multiple Bank Accounts in Smartview Cash ForecastSummary Multiple Bank Accounts in Smartview Cash ForecastContent Hi I would just like to inquire if there is a way to do a multiple bank account view at the same time in…User_2025-02-11-12-30-38-982 37 views 3 comments 1 point Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
OTBI report created using Inventory Subject Area for procurement users, shows no Data?Summary: Hi, We have created an OTBI report using Inventory subject area for procurement users to view the Inventory On Hand balances. But the report shows no data for s…
-
Bursting Query table from the reportsSummary: Bursting Query table from the reports Content (required): Hi Team, Greetings! Is there any table(s) which holds the queries included in the bursting query in th…Parag Hiremath 407 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Best practice for reporting on incomplete allocated checklists?Summary: Hi All, Does anyone have any "best practices" for reporting on incomplete allocated checklists? We have a business case to report on number of incomplete checkl…William_Johnson 61 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report on Training Hours for each learnerSummary: Hi all, We are trying to report on each learner's hours during one year - has anybody been successful in building this in OTBI? Thank you in advance for your re…Cora_Stanciu 31 views 3 comments 0 points Most recent by Emily Robinson Reporting and Analytics for HCM
-
CAGR(Compound Annual Growth Rate) Calculation in OTBISummary: Creating an OTBI analysis to calculate CAGR of the joiners in my org in last 3 years. Content (required): I am trying to calculate CAGR of the joiners in my org…Dinky Dudeja 51 views 2 comments 0 points Most recent by Dinky Dudeja Reporting and Analytics for HCM
-
How to generate employee listing report in Oracle fusion?Summary: Content (required): Employee Listing report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01.0) Cod…Radha, Rangu 645 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Unable to display recently created courses on reportSummary: Sorry, another question about the Learning Records subject area. Content (required): I need to create a report which includes all of our EDI training. Again, I'… -
OTBI->Cloud Benefits Sample for 401k, 403B, etc. Enrollments by Gender, Ethnicity, Participant CostsSummary: This is part of a series of sample reports created by Oracle BI and HCM Product Management. You can copy the setup for this report and add it to your Oracle HCM…Adam Gates-Oracle 41 views 0 comments 0 points Started by Adam Gates-Oracle Reporting and Analytics for HCM -
Can the parameter affect both the row and the column in the Matrix report prepared from the analysisI have a matrix report that I use on the Dashboard screen, and the column information consists of job name information. The row information is also from the locations. a…Cansel Karasoy 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM