OTBI
Discussion List
-
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 944 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 111 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… -
The following KFF segments has set up issues and needs to be resolved before BI extender can be runSummary: We are running: Import Oracle Fusion Data Extensions for Transactional Business Intelligence Output file shows this error: Why are we seeing these errors?. We a…Bo Tøpgaard 122 views 5 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
We want to use OTBI to get the date and time the purchase order was opened.Hello. We want to use OTBI to get the date and time the purchase order was opened. Now, we are using Communication Date column, but it only has the day and not the time …
-
OTBI Subject Area for Transaction Tax Determinants in Order ManagementOTBI Subject Area for Transaction Tax Determinants in Order Management
-
Transit time for a sales order in OTBIIs there any field available for Transit Time for a Sales Order line (calculated by the system) in OTBI Work Area. We would like to have a OTBI with Order, Requested Shi…
-
Innovation Management - Retrieve Attachment DataSummary: We are working in the Innovation Management - Proposal module. Under the Attachment tab of Proposal module, user can upload image attachment(s) by Catergory (e.…Poh Chie 13 views 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management -
Innovation Management - how to customize the DefaultReportDataModel and DefaultProposalReportSummary: We are working on the Innovation Management - Proposal module, and the Proposal Action Menu consists of Export function which using the default data model and d…Poh Chie 21 views 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management
-
How to report P2P transactions approval statuses and current approver?Summary: The aim is to report on the approval status and identify with whom the approval is pending. The subject area Human Capital Management - Transaction Administrati…
-
Learning report not working - ORA-01652: unable to extend temp segment by 128 in tablespaceSummary: We are unable to run the attached learning analysis. This analysis was working without any issue and we didn't do any modifications. When we ran it recently it …
-
UPDATE RECEIVABLES RECEIPT DFF using APII tried to update receipt DFF with the following Payload: single…
-
Risk Matrix in MaintenanceSummary: During one of the discussions with a client who has several offshore platforms, they wanted to know if Oracle has any solution for Risk Managment and scheduling…
-
How to default an Order Type when performing Return All TransactionSummary: How to default an Order Type when performing Return All Transaction Content (please ensure you mask any confidential information): We have a requirement to defa…
-
We looking Variable pay plan details in OTBI for which subject area need to use ?Summary: Hi Team, May I know which subject area need to use for Variable pay plan details as per below screen shot. Variable pay plan details: Content (please ensure you…AjayKumar Maddipati 11 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Employee details at the time of the absenceI would like to report on the worker details at the time of the absence. If for example an employee changed department today, the absence from last year would show the d…NusratB 42 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
I am looking for the field.Summary: Hi, I am looking for the column/field of "Does not meet the required criteria for the role" in ORC. Content (please ensure you mask any confidential information…Robb 61 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Analysis of employees assigned performance goals and not assigned performance goals for a goal plan?I have created an analysis using the Workforce Goals - Goals Status Overview Real Time subject area. I have selected the following subject areas and applied filters (scr…Adrian Clarke 64 views 2 comments 0 points Most recent by Adrian Clarke Reporting and Analytics for HCM -
How to default the Location of Logged In User in Dashboard PromptSummary: 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 21 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM