OTBI
Discussion List
-
OTBI Analysis - DFF Throwing ErrorSummary: I'm building an OTBI Analysis on the Product Management - Item Catalog Category Hierarchy Real Time subject area and pulling several DFFs under the Category fol… -
Learning Subject Area and Organisation Structure Reporting PerformanceSummary: Hi, we have an issue where trying to filter on Org Structure for Learning reporting results in the reports either timing out or taking 10+ minutes to run for a …Kevin Robertson 1 view 0 comments 0 points Most recent by Kevin Robertson Reporting and Analytics for HCM
-
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…Bo Tøpgaard 92 views 4 comments 0 points Most recent by Santhosh_Krishnan123 Reporting and Analytics for ERP
-
Report on Parent Position's Current Incumbent when Position is vacantContent We need a way to report on the parent position's current incumbent when the position itself is vacant. The report that we created shows the incumbent name for bo…Joanne Chung 484 views 14 comments 1 point Most recent by Stephanie McInnes Reporting and Analytics for HCM
-
OTBI Analysis - Create Action Link for Workspace Activity SubtabSummary: Hi All, In Oracle Sales Cloud we have a workspace tab and we have a Activities subtab. I have an analysis report from OTBI where there is an Activity Title fiel…
-
Error While Customizing “Global Subledger Detail Journal Report” – Invalid Table Name IssueSummary We are trying to customize the Oracle seeded report “Global Subledger Detail Journal Report” located in: /shared/Financials/Fusion Accounting Hub. We created a c…
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
Is there an easy way to add the infolets from classic Inventory Management page to Redwood page?We are going through the process of enabling Redwood pages for Inventory Management. We have enabled the Redwood Inventory Management landing page but noticed that the i…Francisco Carrillo-Robles 153 views 11 comments 0 points Most recent by Francisco Carrillo-Robles Inventory Management
-
Organization Calendar Events with Coverage Area Data Extraction QuerySummary: Query to extract Organization Calendar Events with Coverage Area (Geography) Content (please ensure you mask any confidential information): Hi, We have a requir…Vasanthakumar Ravi 1 view 0 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …
-
Salary not populating for some termed employees in Workforce Assignment Salary History Real TimeSummary: I am using Compensation - Workforce Assignment Salary History Real Time subject area and trying to build a report to populate all termed employees and their las…S. Johnson 11 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 Most recent 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 11 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 481 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 11 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 2 views 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 475 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…