OTBI
Discussion List
-
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 31 views 9 comments 0 points Most recent by User_16WBA Reporting and Analytics for HCM -
Is event organization missing from subject area Project Billing - Event Real Time??I can't find it in the list of fields available, but it seems a bit odd for the event organisation to be missing. It also seems to be unavailable to add to View Columns … -
Show OTBI Graph with no values rather than No Results messageSummary: There are instances when the OTBI bar graphs result in no data results. Instead of showing a "No Results" message, is it possible to show the graph instead? We … -
Bulk Agent DistributionSummary: For custom Outlook distributions, we first create the custom report in OTBI to capture the list of team members for Outlook, export it individually, and upload … -
OTBI Report to get capacity rule's booked seat from Learning ModuleHello Expert's, Want OTBI Report to get Booked seats from Capacity Rule in HCM Learning Module. Please check below navigation and Image. My Client Groups> Learning Catal…Rajdeep_Chavda 89 views 6 comments 0 points Most recent by Rajdeep_Chavda Reporting and Analytics for HCM -
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
How to find missing privilege to get archive and unarchive options on reportsSummary: How to find missing privilege to get archive and unarchive options on reports Content (required): Hi Team Greetings! The archive and unarchive options are not s…Parag Hiremath 316 views 11 comments 0 points Most recent by orccjl2 Reporting and Analytics for HCM -
Looking for PO Receipt Number and related data in OTBISummary Cannot find PO Receipt Number, Receipt Date and related date in OTBI Subject Area: Procurement: Procure to Pay Real TimeContent Cannot find PO Receipt Number, Re…Rona Jeongco 890 views 18 comments 0 points Most recent by Dkowall-Virtua Reporting and Analytics for ERP -
What entitlement and roles do I need to be able to create and run query using sqls in BI report.Summary: What entitlement and roles do I need to be able to create and run query using sqls in BI report. I can access Person Management from the UI. But I want to creat…Sunny G 72 views 8 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
HCM Profile-> Set Preference-> LanguagesI want table to get data from Profile-> Set Preference-> Languages. and want joins to create relation between profile and language. profile-> Set Preference-> Languages …Rajdeep_Chavda 57 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Looking for report that shows state from tax jurisdictions cardSummary: We have run our first payrolls with USOPTE and are running into a case with tax jurisdiction cards having the wrong state in a particular circumstance. We want …Dana Lockwood 42 views 3 comments 0 points Most recent by Stephanie Turner Reporting and Analytics for HCM -
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 305 views 4 comments 0 points Most recent by Akash Verma Reporting and Analytics for HCM -
Send a Document of record as attachment through OTBI analysis output via emailDear All, We want to send by mail the output of an OTBI Analysis we have, but we need to send with it an attached file. The file that we need will be the CV of an employ…Patrick Chrabieh 94 views 2 comments 1 point Most recent by Revathi_jt Reporting and Analytics for HCM -
Fusion OTBI Subject Receiving - Purchase Receipts Real Time No ResultsSummary: Fusion OTBI Subject Receiving - Purchase Receipts Real Time No Results The specified criteria didn't result in any data. Content (please ensure you mask any con… -
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…GJ79 81 views 2 comments 0 points Most recent by Satish Kumar Sengar Reporting and Analytics for HCM -
Issue with Supplier Management Redwood Page Changes Not ReflectingSummary: Hi Team, We are facing an issue with the Supplier Management Redwood Page. After the P2T refresh, when I try to add my visualization to the Redwood page using E… -
Subscription OTBI Report is not Fetching Amount data for non-USD currenciesOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): I have observ… -
Can we reserve supplies against Transfer OrdersSummary In a constrained planning system, we can reserve supplies such as On Hand, PO's, PR's etc against high priority customers and high valued Sales Orders. Can it be…Omkar Panda-Oracle 72 views 4 comments 2 points Most recent by Krupesh Mukesh Joshi Supply Chain Planning and Collaboration -
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …ScottLCIS 89 views 5 comments 0 points Most recent by Pankaj Toshniwal-Oracle Reporting and Analytics for HCM -
How to get Home and Work Email outSummary: I'm trying to build a report that includes both Home and Work Email. I have sufficient privileges to view and report on this data. Currently I have Workforce Ma… -
Unable to get the price after made the revision of the Sales order.Summary: Dear, By using a revision option, we are trying to add the new line to a sales order that currently contains several closed or awaiting shipping lines, but syst… -
OTBI - Is Purchase Order Number available in the following Subject Areas?Summary: How to retrieve Purchase Order Number from OTBI Subject Areas for Implemented Change Orders and Requisitions. Content (please ensure you mask any confidential i… -
Procurement - Procure to Pay Real TimeSummary Procurement - Procure to Pay Real Time not displaying the Receipt Numbers created against the POsContent Hi, We would like to create an OTBI report using the Pro… -
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development…Raghavendra Raghunath-Oracle 51.1K views 201 comments 131 points Most recent by Nancy K Reporting and Analytics for HCM -
OTBI Graph: Maintain Same Color for Multiple Measures of the Same SupplierHi, I'm working on an OTBI Analysis in Oracle Fusion and have a requirement to display both Invoiced Quantity and % of Quantity in a stacked vertical bar chart. Currentl…sakthi.paramasivam 21 views 2 comments 1 point Most recent by Abbas Sibai Reporting and Analytics for SCM -
ERP Finance: Do we have any subject area that represents the data in XLA_ACCOUNTING_ERRORS tableSummary: We would like to understand is there any subject area that showcases the create accounting warnings/errors, majorly looking for XLA_ACCOUNTING_ERRRORS. MESSAGE_…Saichand Reddy Danda 63 views 1 comment 0 points Most recent by Abbas Sibai Reporting and Analytics for ERP -
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…Sahil_Makhiza 527 views 27 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP