OTBI
Discussion List
-
OTBI Data Missing After Excel ExportThere are two instances with OTBI reports where I have gotten the message below that have impacted reports. In one report, hyperlinks are not working, and in another, ro…Alexander George Demczak III 21 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your thoughts. Content (please ensure you mask any confidential i…Lucky Sharma 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t…Sunil Dabekar 230 views 3 comments 0 points Most recent by Viswanath-Oracle Reporting and Analytics for SCM -
Where can I find the Payment Number for Payables on OTBISummary: I'm trying to pull together a report listing payments made to suppliers and need to include the the Payment Reference Number (i.e. the cheque, payable order (PO…
-
Sample SOAP request payload for OTBI Analysis extractSummary Sample SOAP request payload for OTBI Analysis extract using variables or filter criteriaContent I have an OTBI analysis based on the "Procurement - Purchasing Re…
-
Unable to join Product management OTBI subject areasSummary: Hello Community, I have a requirement where I need to pull the Royalty data from the "Where Used" part of PIM. As part of that we are trying to join below subje…Sai Revanth 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
which table can store the information about user's parent & child relationship roles in fusion hcmHi All, Thanks for looking into this issue. I am looking for table, which can store the current logged user parent -child roles(for Ex: One big role have more number of …Ravindr-Oracle 101 views 10 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
24B FTP server errorSummary: We have certain BIP Reports setup in various environment and most of them have no issue except Dev1 environment, which was updated on 24B and when reports jobs …
-
How to download a detail report containing all fixed assetsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
When manager run the BI report only need to get the details of direct or indirect reportiesSummary: HI Team, When manager run the BI report only need to get the details of direct or indirect reporties how can we develop this requirement? Thanks, Ajay Content (…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Talent Pools - Succession Plan KPI reportSummary: Need to build report using below fields - either OTBI or BIP. Kindly help please. Content (please ensure you mask any confidential information): Column Name Des…Pradnya_Pampatwar 21 views 1 comment 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
What is the diffrence between Date start and Orginal_Date_of_hire in PER_PERIODS_OF_SERVICESummary: Hi Team, we have to two columns for Hire_Date in PER_PERIODS_OF_SERVICE table what is difference between. if not why two columns given. Thanks, Ajay Content (pl…AjayKumar Maddipati 51 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Expense report with attachment informationHello All There is an option in BI to inform that the expense report was created with an attachment, we need to create a report with this information. Has anyone had thi…
-
OTBI Report Job RequisitionWe have an OTBI report is the attached xml. https://us.v-cdn.net/6034893/uploads/LYIGJUNHB6NP/jobrequisition-otbi-xml.txt https://us.v-cdn.net/6034893/uploads/VVZRABE1TC…SauluriR 81 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to report on Historical Organization Hierarchies?Summary: We have 6 historical versions of our organization tree, but when trying to report on the previous versions in reporting, only the latest organization hierarchy … -
Learning Item Title Expiry DateSummary: We are trying to create an OTBI report that shows the completion or expiry date for learning items by employee - how can we add this field in to the OTBI report… -
Need to identify the tables that hold sensitive information using Oracle Cloud RecruitingSummary: I need to identify the any tables that hold sensitive information (PII). We have started using Oracle Cloud Recruiting and want to identify tables that have thi…
-
we would need a report with the previous and new cost center OTBI ?Summary: Hi Team, Hope all doing well ! we would need a report with the previous and the new cost center ? Could you please help me on ? Thanks, Ajay Content (please ens…AjayKumar Maddipati 31 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Adding multiple phone numbers to analysisSummary Add multiple phone numbers to an analysisContent Hi All, I just need some direction on adding multiple phone numbers for an employee in an analysis I am modifyin…User_2025-02-04-08-51-08-912 34 views 4 comments 0 points Most recent by Alexis PJ Reporting and Analytics for HCM -
Philippines Statutory Report - Cash Disbursement JournalSummary: Philippines Statutory Report - Cash Disbursement Journal Content (please ensure you mask any confidential information): Hi, We are trying to get the details on …D Mandal 51 views 4 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global
-
OTBI report for learner count, count of learner according to number of courses completedSummary: I have to create a report to get the count of learners who have completed more than 1 course and learners who have completed more than two courses. Also I need …
-
Can you please provide us the details of the report which provides information about all the reportsSummary: Can you please provide us the details of the report which provides information about all the reports along with permission set to that particular report Can you…Shubham Bindal 11 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Logical SQL join condition for Recruitment and Transaction ConsoleHi, I have a report where I am using below tables for fetching recruitment and postion details like JobRequisitionNumber, RecruiterFullName,DepartmentName,RecruitingType…
-
IN OTBI How to display the data as per user preferred time zone and dynamically add GMT /- ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Manoj Vasa 21 views 2 comments 0 points Most recent by Kadiri Prathusha Reporting and Analytics for ERP
-
TIMEZONE Display on the report field - UTC Timezone to EST TimezoneSummary TIMEZONE Display on the report field - UTC Timezone to EST TimezoneContent Hi Experts, I am using the OTBI Analysis (Payables Transactions Real Time) to create a…
-
Gross earnings reportSummary: Is it possible to create a report in OTBI that shows gross earnings per pay for a specific date range? If yes which subject area should we use? can anyone help …Shameer Shaik 31 views 2 comments 0 points Most recent by Shameer Shaik Reporting and Analytics for HCM
-
Add "Cost Element Type" in OTBI Report "Costing - Period Inventory Valuarion Real Time" subject areaHi, I've created a report in OTBI to detail the On Hand valuation information. We are using the new subjet area "Costing - Period Inventory Valuation Real Time". We need…Sebastián Bach 2 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP