OTBI
Discussion List
-
Which are the tables or views behind Quality Action Rules?Summary: Hi Team, We need to know the table/view which are storing the data for Quality Action Rules that are being created from UI. Content (please ensure you mask any … -
what is the BICC VO for Position EFF?Summary: I am trying to find the PVO for extracting Position EFF data and it is not available in the datastores. I could find the Assignment and Job EFF but not Position…Veena Pindiganti 11 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management -
Add otbi report in a DCS appContent Hi, We are trying to add OTBI reports in a DCS application. We tried using iframe using the analysis URL but are only able to view the report data if I am logged…ShreySH-Oracle 34 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Can we create an OTBI Audit report for work definitionSummary Audit policies setup was enabled for work definition but we didn't find any audit subject area for work definition so can you please confirm whether we can devel…Balamurugan Kulandhaivel 11 views 7 comments 0 points Most recent by Balamurugan Kulandhaivel Manufacturing -
Table for main contact in CRMDear all, Please help, I need to identify the table that brings me the main contact of the CRM module in Oracle Fusion Cloud. Thank you.Jhonattan Diaz 31 views 3 comments 0 points Most recent by Madhuri Cheruku-Support-Oracle Reporting & Analytics for Sales -
OTBI for Model Profile vs Person Profile Competency Gap AnalysisSummary: Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to pull Person Talent Profile Competencies ratings and Model… -
Table used for Project Financial ManagementSummary: Can i please know the table we are storing Project Management details in. Content (please ensure you mask any confidential information): Navigator > Project Man…Priyansha Singh 1 view 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management -
How to extract ship to customer and ship to site name?Hi, How to extract ship to customer and ship to site in a receivables table? We only found id. Thanks, Regards -
Model Profile vs Person Profile Competency Gap AnalysisContent Hi All, Wondering if anyone had a great analysis comparing the competency minimum proficiency level identified in a model profile to the assessed competency prof…Lauren Owen 142 views 3 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Absence update history not availableSummary: Currently when the employee update the existing absence record and submit it, the back end does not hold both the data on the absence entry table. Unfortunately…Sobitha Venkatraman 1 view 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM -
Data isn't retrived due to special character in Business Unit promptSummary: Hey, We have an issue with our Performance dashboard. The dashboard is based on OTBI analysis reports and the Performance subject area. One of our BU was create…Markovich Chen 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to identify C-Suite leader in headcount reportI'm trying to add a column that will identify our C-Suite leaders for each employee in headcount report. C-Suite leader would be the CEO - 1 or whomever is the top-most …S. Johnson 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Absence Report CalendarSummary: Hello Experts I have been tasked to develop a Calendar Report that looks like the attached as the screenshot system will be replaced soon. I am uncertain how at… -
SQL How to get point information for questions at manage activities -> (i) information -> ViewSQL How to get point information for questions at manage activities -> (i) information -> View Content (please ensure you mask any confidential information): Version (in… -
url enrollement link otbiSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
How to get sales order number associated with a work order in Oracle Fusion?Hi, I have a requirement to write a query to get the work order number associated with the Sales order. Is there any table in Oracle Fusion which stores the association … -
Unable to add table or link to a oracle analytics deliversWe have the next análisis with the next details: this is the text in the notificatión: [u] Hola, @2 [/u][br/] Recuerda que debes registrar tus vacaciones en la plataform… -
Fusion ERP - Roles x Privileges ReportHi everyone, Do we have a report that lists all the privileges for all roles (including both predefined and custom roles) in Fusion ERP? Something like this: Role | Priv…Jorge Gutierre 61 views 4 comments 1 point Most recent by Jorge Gutierre Reporting and Analytics for ERP -
possibility to build OTBI analytics report from Cash Management bank statement + Accounting dataSummary: Hi, would like to ask for any hint and help, if OTBI analytics tool is suitable to build report from Cash Management bank statement + Accounts from Primary and … -
work centerSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Is there any report code for identifying special characters within a field?Summary: Currently some of our addresses contain commas or other special characters. Is there a way to identify these records within OTBI? Content (required): Address Li…Mark Stoker 21 views 3 comments 0 points Most recent by Robert-Jan H. Reporting and Analytics for HCM -
How to get report on learning item associated with communitySummary: Content (please ensure you mask any confidential information): We are looking for SQL to fetch list of learning items associated with topic community. we tried … -
Release 12 HCM OTBI Subject Area descriptionsSummary List of Release 12 HCM OTBI Subject AreasContent This spreadsheet provides the list of HCM OTBI R12 subject areas with descriptions, business questions answered …Raghavendra Raghunath-Oracle 943 views 11 comments 10 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Requisition Template ReportSummary: Hello - We are looking to create a report which shows all jobs and the requisition template they are associated to based on the Job Details section. We are not …Shanna Oppenheim 113 views 19 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Formula to pull two months data for automated reportSummary: OTBI Formula to pull two months data for automated report Content (required): Hi we have a task to automate the report which pulls termination for the current a…