OTBI
Discussion List
-
Permission for standard folderSummary: Hello, I'd like to know if we can set permission for Human Capital Management under shared folder(the standard folder) to specific users. I managed to do that i…Mayar Mohamed 1 view 2 comments 0 points Most recent by Mayar Mohamed Reporting and Analytics for ERP -
Report notifies manager when time reported by employee is less than 4.5 hoursSummary: I need to build a report that will have coloumns Emp name, number, manager name, department, and calendar days in recent time card on which date employee report…
-
Detailed PO Costing Report - OTBI vs. BIP?Summary: I believe a BIP report will be required to meet the requirements as defined below, but I wanted to first rule out OTBI as a possible solution tool. Content: I h…
-
How to fetch a comma separated string into separate columns in Oracle fusionSummary: We have a column name - "Approvers" from table - "FA_FUSION_SOAINFRA.WFTASK". When we have multiple approvers for a transaction and those will appear in the "Ap…
-
We can see GL Balances subject area but not GL Accounting Segment Value / Account RegisterHi Expert, We can see GL Balances subject area but not GL Accounting Segment Value / Account Register. how to GL Accounting Segment Value / Account Register in OTBI cont…Rambabu_Mullamuri 1 view 0 comments 0 points Started by Rambabu_Mullamuri General Ledger & Intercompany -
Exclude User from AP Invoice approval cycleSummary: AP Invoice Auto-Approved but Workflow Still Triggers Approval Notification A user has been excluded from the AP invoice approval cycle . An approval rule has be…Esraa Yousef 12 views 2 comments 0 points Most recent by Esraa Yousef Payables, Payments & Cash Management
-
Unable to find POZ_SPEND_AUTH_REQUESTS is raised for which multiple BUSummary: Hi Team, We are trying to build a SQL query to get the spend authrozied pending approval request along with BU details, table - POZ_SPEND_AUTH_REQUESTS provide …
-
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…Gail Langendorf-Oracle 466 views 8 comments 4 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Output Manager Hierarchy in OTBI with fixed column postionsSummary: Can OTBI output all employees with their manager hierarchy in fixed positions (consistent column data)? Content (please ensure you mask any confidential informa…
-
Is it possible to change the account sign convention at the system level in Oracle ERP Cloud?Summary: Hello Experts, I would like to confirm whether it is possible to change the default sign convention (natural balance for each account type, e.g., Revenue and Li…Yuyeon KIM-Oracle 14 views 3 comments 0 points Most recent by Rich Merkel General Ledger & Intercompany
-
How to add custom report when performing Release and Pick Materials in Manage Work OrdersSummary: We have a requirement where we want to trigger a custom BIP report along with Print Pick Slip report when we perform Release and Pick Materials in Manage Work O…Prince Choudhary 11 views 2 comments 0 points Most recent by Natchirajan Shenbagamoorthy-75581 Manufacturing
-
HCM Position HierarchySummary: Hi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name …
-
Report image only visible in pdf not in wordSummary: Hi all, We noticed that when downloading a custom report in word we cannot see the image/enterprise logo attached. Whereas, when downloading the same report in …Silvia Stangarone CAI 1 view 1 comment 0 points Most recent by SankarBalu Reporting and Analytics for ERP
-
HY000. Code: 60009. The user request exceeded the maximum query governing executioContent We have created an analysis with BI Admin role. When we are running this analysis with BI consumer/author role. we are getting error: HY000. Code: 60009. [nQSErr…User_F89L9 461 views 10 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Procurement Procure to Pay real time subject area no data showing on purchase order measurements colProcurement Procure to Pay real time subject area no data showing on purchase order measurements Ordered Amount, Delivered Amount and Open Ordered Amounts User has AP ro…
-
Query to fetch manage person contribution transaction dataSummary: Need a sql query to fetch transaction details of a ICP plan containing details of plan name, its input values, status of the transaction and the level of approv…
-
How to rename BI Publisher excel output spreadsheet.(sheet1, Sheet2,...)Summary: Business needs to display Sheet1,Sheet2.... to different names when generating the output in Excel through BI Publisher. Content (required): Business needs to d…kalyan gade 607 views 6 comments 0 points Most recent by User_GMBW9 Reporting & Analytics for Fusion Service
-
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 1.3K views 7 comments 1 point Most recent by User_GMBW9 Reporting and Analytics for ERP
-
Oracle Business Analytics Reporting OverviewSummary Watch this video to learn about using Oracle Business Analytics for Supply Chain Management.Content Link to the video: https://www.youtube.com/watch?v=DSRvYKS2wG…Pankaj Mongia-Oracle 525 views 2 comments 11 points Most recent by Mohammed Rafi Reporting and Analytics for SCM -
How to convert column into HTML format in BIP datamodelSummary: OTBI column output: Here how same column appears in SQL Datamodel in BIP So, could you kindly help on how we can convert this Comment column to be displayed as …
-
Display manager and employees' phone numbers on a single row in OTBI analysis reportHi I try to display the manager and employees' phone numbers and email on a single row in otbi analysis table, but without any success. For the employee, I use this form…rrr 21 views 5 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Inventory Aging ReportSummary Any Custom or Standard Inventory Aging Report available in FusionContent Looking for Inventory Aging report with 1-2, 3-4,5 Years Buckets data for the inventory … -
The Program Name is not populating in the ERP Project Costing module.Summary: The Program Name exists upstream but did not flow into the Project Costing module. As a result, costs are missing from the Project Cost by Transaction report. C… -
How to grant read-only access to "Costing - Inventory Valuation Real Time" without UI AccessSummary: How to grant read-only access to "Costing - Inventory Valuation Real Time" without Application access. Content (required): We have a requirement where we need a…Yasser Ali 61 views 3 comments 0 points Most recent by NatalieyaMoro Reporting and Analytics for SCM
-
delete value set valuesSummary: Good Morning Can I delete value set values (account values ) in the account segment took the wrong hierarchy by mistakeEsraa Yousef 22 views 6 comments 0 points Most recent by Venkatesh Padamwar General Ledger & Intercompany
-
Cloud Bi Bursting report output showing each email [external] in mail inbox, how to correct.Hi all, we have cloud Bi bursting report output, showing each email subject [external] in mailbox. How to remove external description. Kindly guide me.sasi 11 views 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration
-
How to enable COA to pull account segments into OTBI when they were not originally setup to do so?Summary: I would like information on other potential workarounds to enable Account Segments for use in OTBI reporting when they were not originally configured to do so. …
-
What is the deep link URL for Procurement receipts?Summary: We want to create an action link on OTBI report - when the user clicks on the receipt number, it should open up in the application ( Procurement - My receipts) …Astrid Ferrao-Oracle 421 views 12 comments 0 points Most recent by Aishwarya_Muchandi Inventory Management