OTBI
Discussion List
-
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 191 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 23 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 668 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.
-
Expose custom pivot tables in supply planning to OTBISummary: We have created custom pivot tables within supply planning cloud. Is there a way to see these custom pivot tables in OTBI? Can we export the custom pivot tables…Ramakrishna Reddy M 12 views 1 comment 0 points Most recent by NinaLyubenova-Oracle Supply Chain Planning and Collaboration
-
HCM Extract and BI Publisher - GC overhead limit exceededTeam, We have a HCM Extract which is invoking the BI Publisher to generate PDF output. But we are getting an error and HCM Extract is not generating any PDF output. Erro…
-
How to provide the gap between the 2 bars in bar graphSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Narendar Rao Naineni 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report with Payments Disbursements and Invoices with Invoice distributionSummary OTBI Report with Payments Disbursements and Invoices with Invoice distributionContent I am trying to create a report that shows only the invoice expense account …User_2025-02-06-00-15-19-515 759 views 3 comments 0 points Most recent by J Dimond Reporting and Analytics for ERP -
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…Ripendra Kumar-Oracle 683 views 3 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for SCM
-
Which criteria (OTBI Subject Area) need to create a report for identify slow moving itemSummary: Which criteria (OTBI Subject Area) need to create a report for identify slow moving item Content (please ensure you mask any confidential information): How to i…
-
OTBI output is different for 2 different usersSummary: Hi, We have a custom OTBI report which is scheduled to send report to the Business Users. This report shows that 100 employees have missing family contact infor…Sailajad 21 views 8 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM -
Issue: Unable to expand Calculation Components Detail folder in Payroll - Calculation Cards Real TimSummary Users building reports on Calculation Cards Subject Area when try to expand Calculation Components Detail folder, the folder doesn't expand. Solution is provided…Tanvi Jain-Oracle 141 views 1 comment 2 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
how to link between sales order and discount list through SQL in oracle fusion (non-matrix rule)Summary: I can link the SO to the discount list name by following the post below if I am using MATRIX_RULE https://community.oracle.com/customerconnect/discussion/commen…
-
View Reports and AnalysisSummary: View Reporting and Analysis on the Cloud Help Center Content (please ensure you mask any confidential information): There used to be a link for Reporting and An…AVorster-Oracle 21 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM