OTBI
Discussion List
-
How to restrict the data in OTBI report based on AOR (Area of Responsibility)We have created HCM reports from the Absence module, Goals and performance, etc. and we need to restrict the data based on AOR. Is it possible to restrict the data in th…Vikas V. Kamat 203 views 7 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM -
Need inputs to restrict OTBI reports only based on the AOR roleSummary: Need inputs to restrict OTBI reports only based on the AOR role for users that have both AOR and Line Manager data access roles. Content (required): We have cre…Sakthi priyanka B-Oracle 257 views 3 comments 1 point Most recent by GPOtimization Reporting and Analytics for HCM
-
OTBI Worker Attributes Changed After Redwood EnablementSummary: Our reports stopped working in Production after migrating to Core HR Redwood. We’ve observed changes in OTBI column attributes when comparing Redwood and non-Re…Josel Pleyto 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can you help me add the assignment status (Active/Inactive/Suspended,etc) to this SQL query?Summary: Hello team! I have this code, but I don't know how to add the assignment status (Active/Inactive/Suspended, etc). Could you please help me with that? Thank you …Claudia Linares L 101 views 13 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to clear Data in Budgetary Control Application before loading data from EPM PlanningSummary How to clear Data in Budgetary Control Application before loading data from EPM PlanningContent We are running into an issue, we have pushed Budget data from Ora…
-
The datatype of this column is NULL and such columns are not supported in the BICC schedule extractWe are facing error "The datatype of this column is NULL and such columns are not supported in the BICC schedule extract" for few columns in HcmTopModelAnalyticsGlobalAM…
-
OTBI Report is working very slow when fetching the Assessment DetailsSummary: Hi Team, I am currently working on developing reports in OTBI, but I am encountering significant performance issues. The reports are taking an unusually long ti…
-
Document of Record Drill to Document DetailsSummary: This report uses Deep Links for Document Records to navigate directly to the worker's DOR from the report results without additional clicks or navigation. Conte…Melanie Mahon-Oracle 193 views 4 comments 7 points Most recent by Samantha Collins Reporting and Analytics for HCM -
Need to calculate month on month attrition percentageWe need to calculate month on month attrition percentage on the basis of formula = (Attrition count of that month *100)/(Average of (Headcount as of first day of month a…Shaarif_Hussain 31 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Data Security not being applied to OTBIWe have a report created using the Subject Area- Expenses - Expense Transactions Real Time. As per Oracle documentation, this subject area access requires, Expense Trans…
-
How to fetch the physical address of Geo coordinates that we have in Time records?Summary: On the OTL page, we can view the latitude and longitude of the geo-location from which an employee submits their timesheet. Additionally, there is a button that…ManikandanRajagopalan 31 views 4 comments 0 points Most recent by ManikandanRajagopalan Reporting and Analytics for HCM
-
difference balances xla_ae_lines and xla_ac_balancesSummary: difference balances xla_ae_lines and xla_ac_balances Content (please ensure you mask any confidential information): We created an OTBI report in the "Subledger …Francesca1 21 views 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub
-
How to identify a requisition lines if negotiated flag is checkedSummary: Content (please ensure you mask any confidential information): We have some requisition where users checked 'Negotiated' which they shouldn't. This has created … -
I want to Extract in OTBI the 'Enable time limit' and 'Enable Score' Cols from the Assessment Page.Summary: Hi Team, I have requirement to built the OTBI Report to capture the below details in the OTBI Report. Below mentioned columns are check box enabled fields. Can …
-
What is the default size of calculated columns in BICC extracts, and is any documentation available?While generating metadata using BICC R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet (Rel13_25C_BICC_FSCM_Database_Mapping_with_ViewOb… -
How to check Budget Reserved/Consumed against a Particular Purchase Order including its PRs/InvoicesSummary: Need to check the Budget reserved/consumed against a particular Purchase order, including its complete cycle which is PR, PO and Invoice. Using standard reports…
-
Can't inquire into Invoices in the system using Action Link in OTBISummary: Hi. I'm trying to create OTBI Report that will show outstanding Invoices (Unpaid after Due Date is already Due). I'd like to add Action Link, so user will be ab…Yftach Paschur-Oracle 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Payables to General Ledger reconciliation report runs by business unit not legal entity instead?The Payables to General Ledger reconciliation report runs by business unit. Is there any possibility to run it by legal entity instead? There was a requirement to reconc…Pandeyujjwal007 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Marketing - CRM B2B Customers Subject AreaSummary: Marketing - CRM B2B Customers Subject Area Content (please ensure you mask any confidential information): Hi Team, I am looking for details on "Marketing - CRM …Nidhi Chhajed 11 views 7 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Supply Chain Cost Rollup Real TimeSummary: Customer enabled the Perform Standard Cost Rollup Across Multiple Organizations feature and created supply chain cost rollup enabled cost scenario. A cost rollu…
-
How to get Journey Survey Responses?Summary: How do I report the responses from Journey Surveys to the LMs or HR? Can anyone suggest table names for BI reports or Subject areas for OTBI? Content (required)…
-
OTBI Analysis: How to format Person Number as 6 digits with leading zeros?Summary: Hi experts, I have a business need that requires me to extract data from an OTBI analysis and format all Person Numbers as 6 digits with leading zeros when need…
-
Supply Chain Operation for MaintanenceSummary: Supply Chain Operation Dashboard ( Maintenance/Manufacturing, Inventory, Costing and Quality Content (please ensure you mask any confidential information): Orac…
-
in which otbi table are the courses pricing informationSummary: Hi, In need to identify all the active courses for which the fields 'Required' and 'Use to calculate Catalog Item Price in Self Service' have not yet been tagge…
-
how to limit values in OTBI prompt when using SQL Results in choice list values.Summary how to limit values in OTBI prompt when using SQL Results in choice list values.Content Hi All, We have a requirement to show values in prompt as per AOR/securit…User_XT9HW 686 views 7 comments 0 points Most recent by Gerald Hartmann-Oracle Reporting and Analytics for HCM
-
How do I return vacation request data in the transaction console, which tables can I use?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…
-
How can I relate the QP_MATRICES table to the QP_PRICE_LISTS_TL table?I need to obtain the name of a price list from the name of a matrix.