OTBI
Discussion List
-
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 63 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. I would like to add below fields in the report to show this information. Please suggest how we can add these fields and where…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 35 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 …Shreya Datir 51 views 0 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM -
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 13 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 -
Supplier Qualification - Qualifications and Assessments Real TimeSummary: We are trying to create a report using "OTBI - Supplier Qualification - Qualifications and Assessments Real Time Subject Area" please find the report criteria a…Venkateswarlu Kommi 1 view 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
Using dashboard prompts on multiple-subject area analysisSummary: Using dashboard prompts on multiple-subject area analysis Content (required): Hi all, I created an analysis to track a specific group of managers (narrower than… -
Subject area which will give me the conversion factor for a Purchasing UOM to a Stock UOMSummary: Subject area which will give me the conversion factor for a Purchasing UOM to a Stock UOM Content (please ensure you mask any confidential information): I need …Mike.Myers.CDIPRODUCTS.COM 51 views 3 comments 1 point Most recent by Mike.Myers.CDIPRODUCTS.COM Reporting and Analytics for SCM -
In which Subject Area can I found the end date of an account.Hello, I am trying to bring the value of the End date of a GL account in an OTBI report . This value can be inputted in Manage chart of accounts value set values feature…Vlad CONSTANTIN 11 views 2 comments 0 points Most recent by Vlad CONSTANTIN Reporting and Analytics for ERP