OTBI
Discussion List
-
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 60 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 47 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 33 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 287 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 91 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… -
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 61 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 84 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 50.8K 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 23 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 52 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 528 views 27 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
unable to see the custom manager types in OTBIHi, I'm using 'Workforce Management - Worker Assignment Event Real time' subject area, I've checked the matrix manager dimension as well, but i' don't find any other cus…Antony Jerome 55 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
journal approval notification email template updateSummary: we would like to update the journal approval notification email template so that the journal lines are exported to excel and the excel file is attached to the a…padakanti saikumar 37 views 1 comment 0 points Most recent by Devesh Tyagi General Ledger & Intercompany -
Not able to capture failure events on the maintenance work orderSummary: Not able to capture failure events on the maintenance work order Content (please ensure you mask any confidential information): We are trying to add failure eve… -
Mexico CFDI 4.0 - EDICOM Integration, UUID Storage, Receipt UUID, QR Code & Invoice PDF Best PracticHello Team, We are implementing Oracle Fusion Receivables for Mexico (CFDI 4.0) with EDICOM as the PAC provider and would appreciate any Oracle documentation, implementa… -
Mexico Localization (CFDI 4.0) – Best Practice for EDICOM Integration, UUID Storage in AR TransactioSummary: We are implementing Oracle Fusion Cloud Receivables for Mexico (CFDI 4.0) and plan to use EDICOM as our PAC provider. We would appreciate guidance, solution arc… -
Preview Offer didn't show Draft Watermark while previewing the offerSummary: Content (please ensure you mask any confidential information): Dears , I added Draft Watermark to the rtf file and while trying to preview the offer the draft w…Beshoy Hakim-Oracle 12 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Draft WaterMark missing while previewingSummary: Content (please ensure you mask any confidential information): Dears , I am working on adding DRAFT watermark on rtf file , it working offline while testing on …Beshoy Hakim-Oracle 25 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Is it possible to realize OTBI analysis to extract manager different from line manager data?Summary: Possibility to realize OTBI analysis to extract manager different from line manager data? Content (please ensure you mask any confidential information): Hello, …Caterina Ruggiero 31 views 2 comments 0 points Most recent by Baskaran Sambandam Reporting and Analytics for HCM