OTBI
Discussion List
-
In order management old and updated data needed in OTBI in separate lines.Summary: When we create a sales order due to some issues if we cancel the sales order, we are able to see the updated data of the sales order in the OTBI report. The req… -
Recruiting Custom Posting Description Fields Query / SQLHello Experts We need to fetch in a query posting descriptions, for internal and external posting, that were entered by the Manager on Job Requisition Creation > Recruit…Pedro Teixeira 207 views 1 comment 0 points Most recent by Ben Baumes-Oracle Reporting and Analytics for HCM -
how to pass the parameter Item/Change notice to our DM based BIP reportSummary: We have a Report on which we want to pass the Item number/Change Number to the BIP Report, However the report is not passing the parameter which we are passing …Prakash Shetty 11 views 2 comments 0 points Most recent by Prakash Shetty Reporting and Analytics for SCM
-
Top 5 reasons for sicknessSummary: Hi, Has anyone got any ideas how i can get top 5 reasons for sickness and display the same as a % of the total absences? Also how to achieve the top 5 reasons a…BillM 31 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to export csv file for Import Jounals with OTBI.Summary: Do you know how to export csv file for Import Jounals with OTBI? I tried to create OTBI report like the following. It is used Project Costing - Actual Costs Rea…
-
Query/Web service to extract the Payment Methods for all employeesHi, I have a requirement to find the employee's Payment method. Is there a table which stores this data or a web service which can be invoked to extract this information?
-
BIP Data Model - How do I join multiple Data Sets created from OTBI AnalysisSummary: BIP Data Model - How do I join multiple Data Sets created from OTBI Analysis Content (please ensure you mask any confidential information): After creating 5 dat…Mike.Myers.CDIPRODUCTS.COM 31 views 5 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM
-
OTBI report showing Expense Items Not in Expense ReportsSummary: Is there a way to create an OTBI report showing expense items not in expense reports? I tried to create one using the subject area Expenses - Expenses Transacti… -
Database table that is equivalent to the OTBI Subject Area Payroll Calculation Cards Real TimeSummary: Can someone provide the Database table name that is equivalent to the OTBI Subject Area Payroll Calculation Cards Real Time specifically looking for the Calcula…Laura Goodall-Brown 21 views 2 comments 0 points Most recent by Laura Goodall-Brown Reporting and Analytics for HCM -
Talent Review - no results OTBISummary: We have created a custom Talent job/data role which contains the relevant security access to view Talent in My Client Groups. We now want this custom Talent rol…Jo Ord 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Data is not retrieving for not started status in OTBI DashboardsSummary: Hi Team, I hope this message finds you well. We are currently facing an issue retrieving data for the 'not started' status regarding employee feedback. Specific…Sujan Kumar Dash 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Learners cannot view the uploaded videos after enabling redwoodSummary: Content (please ensure you mask any confidential information): Learner is not able to view the approved videos after redwood is enabled. What could be the issue… -
Payroll - Payroll Balances Real Time subject area giving No ResultsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to access OTBI dashboard for Procurement - PurchasingSummary: An user can not access to a dashboard for Procurement - Purchasing on OTBI, the user has assigned the purchase analysis role Other user with te same role can ac…
-
Opportunity market place report - Self service PUBLICSummary: Do you have any report available that could help me to provide a listing of all jobs available in opportunity marketplace ? The report should be public (linked …Jacqueline GRANDIN 21 views 3 comments 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Sickness Absence ReportingSummary: We have work schedules entered for all employees showing their working days. We need to export this in our absence reports so we can calculate working days lost…Karen Wilson 11 views 4 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
BI Publisher - Object_version_number column in gl_je_headers tableDear All, After creating a journal manually, the object_version_number in gl_je_headers is set directly to the value 3. Can anyone tell me what the purpose of this colum…George Mattar 11 views 1 comment 0 points Most recent by Uddipta Bhaumik-Oracle General Ledger & Intercompany
-
How should I find the full names of the people in the approvers column in the fa_fusion_soainfra.WFTHello, I use the APPROVERS column in the fa_fusion_soainfra.WFTASK table in my report, but the username is included there. I need approvers display name information. Can…Cansel Karasoy 31 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
No Results for Supply Chain Rollup Costed BOM ReportSummary: We are not seeing any results for the new subject area, Costing - Supply Chain Cost Rollup Real Time, that supplies results to the Supply Chain Rollup Costed BO…
-
pivot table/ stacked graphSummary: Hi all, I have created an analysis and used a pivot table to generate the stacked graph. Does anyone know if we can move the totals to the top so that it is not…
-
SUPPLIER BALANCE AGING - SQL QUERY NEEDEDSummary: We have a customer requirment to customize the supplier balance aging to increase the aging buckets than the standard one. So we want the sql query for the unpa…Yara Ibrahim-Oracle 423 views 2 comments 0 points Most recent by Sean Rogers Payables, Payments & Cash Management
-
How to set a As-Of Date Prompt in a Dashboard PromptSummary: How to set a As-Of Date Prompt in a Dashboard Prompt Content (please ensure you mask any confidential information): Hi, we created a dashboard. This dashboard h…Barile Alberto 92 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need inputs to display Payroll Run Results based on JobSummary: Need inputs to display Payroll Run Results based on Job Content (please ensure you mask any confidential information): We need to display Payroll Run Results da…Visu 21 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Is there a Workforce Management - Position Event Real Time Subject Area?Summary: There is currently a Subject Area for Workforce Management - Position Real Time selectable when creating an Analysis in OTBI. This Subject Area shows the max ef…Gloria Brewster 31 views 4 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for ERP