OTBI
Discussion List
-
Supporting References with balancesSummary Calculate YTD balances for Supporting References with balances fieldsContent Hi all, Can YTD balances be derived or calculated for Supporting References with bal…Pavan SK 80 views 2 comments 1 point Most recent by Miranda Ho-Oracle Subledger Accounting & Accounting Hub -
Is it possible to add a calculated SQL-based column in an OTBI Analysis?Summary Need to return a segment value name in a column from an OTBI analysis using a SQL QueryContent Hello, Our Financial users have created several OTBI reports based… -
How to add OR condition in the input of the OTBI analysisSummary How to add OR condition in the input of the OTBI analysisContent There are suppliers whom we create only invoices and there are suppliers whom we create only PO …Manish Kumar Sinha 41 views 7 comments 2 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
ITEM ISSUANCE WITH COST REPORTSummary This report including Item issance with cost details and accounts.Content Please find the attached Catalog file. unarchive the catalog in your OTBI reports. -
Table name for 'Manage Upstream and Fulfillment Source Systems'Summary Table name for 'Manage Upstream and Fulfillment Source Systems'Content What is the table for 'Manage Upstream and Fulfillment Source Systems'.
-
How to get count of child nodes in ETEXT templateSummary How to get count of child nodes in ETEXT templateContent Hi experts, how can i get the count of child nodes in etext template, ex : in attached xml i want to dis…Pradvin Prabhakar 139 views 6 comments 1 point Most recent by Pradvin Prabhakar Reporting and Analytics for HCM
-
Subject area analysis results are showing differently for different segment combinationsSummary we have an analysis created, with 3 subject areas, which is behaving differently for these GL account combinations. 1. Totals and columns are correct for the com…
-
FTP OTBI report outputSummary Option to FTP OTBI report outputContent Is there option available to FTP OTBI report output? Pease let us know steps/process to FTP report output. Version 20C
-
OTBI Learning Offering Deep Link ReportSummary This report lists all Learning Offerings and respective Deep LinksContent This is an alternative solution for MOS Doc ID 2535239.1 The Oracle Learning Cloud Offe… -
Seeded Lookups with their values in HCMSummary Need a list of lookups with their valuesContent Hello, I need a seeded list of lookups types with their values, I was not able to find it in any subject area so …Akanksha Jain 71 views 3 comments 2 points Most recent by Akanksha Jain Reporting and Analytics for HCM
-
Query to identify the UCM document ID for an Expense Report attachment in BI PublisherContent Hi experts, Based on the document: How to identify UCM Document ID for an attachment from the Expense Report? (Doc ID 2520471.1) I have built a query to obtain … -
How to get last Audit Date by expense reportContent Hi Is there any table capture Audit date. Thanks VenkateshKammarapalli Venkatesh-Oracle 52 views 1 comment 1 point Most recent by Soumya Prakash Parhi Expenses
-
Amendment need to an existing reportSummary Multiple NationalitiesContent Hi, How can I modify the attached report so that only the primary nationality is displayed? For context, there are many employees t…User_2025-02-05-22-44-35-842 31 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Benefits report - Users accessing UI vs submitted electionsSummary Users accessed vs submitted electionsContent Would it be possible to build a report that gives number of users that access UI vs submitted elections? Attached sc…User_2025-02-10-08-27-16-805 24 views 4 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Prior Salary not showing in reportSummary Prior salary not showingContent Hi, The report attached should show all prior salaries and current salaries - one of our users has said that the Prior salary is …User_2025-02-05-22-44-35-842 38 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
SQL Cash Advance Report from ExpensesSummary SQL Cash Advance Report from ExpensesContent Hello I was wondering if you can share with me any SQL regarding open Cash Advances from Expenses. Thanks for your h…gabriel kinovisques-163562 49 views 2 comments 1 point Most recent by Balachander G-Oracle Reporting and Analytics for ERP
-
After 20C OAC DataSync from ERP Cloud fetching 0 recordsSummary We are observing in Data Sync the PVO's are getting 0 records while fetching data from ERP cloudContent We are seeing this currently in all instance where the Da…Kammarapalli Venkatesh-Oracle 45 views 2 comments 1 point Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for ERP
-
Account Segments Report ExampleSummary Account Segments Report ExampleContent Hello all We need to develop a report about Account Segments. We made it by Query and it is bringing the correct informati…Pedro Teixeira 20 views 2 comments 0 points Most recent by Pedro Teixeira Reporting and Analytics for HCM -
Subledger Journals - OTBI Subject AreaContent Hi, In Subledger Journals OTBI subject area, Accounting period column does NOT show in ascending/descending order in prompts. Using the below SQL in the prompts …Vinod Kumar Mohanraj 56 views 1 comment 1 point Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
Compensation with manager with access 'limited'Content hello, I have a question, on a compensation plan, if a manager is not eligible to a compensation plan but he manage someone inside the compensation plan, he have…User_2025-01-25-01-33-46-269 64 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Missing Create Infolet tile iconSummary Missing Analytics tab and Create Infolet optionContent Hello, I am interested in creating an Infolet based on information that is present in Product Information …
-
Is there any standard report in AP with Fields (Vendor Name, Site, Opening Balance, Transaction, CloSummary Is there any standard report in AP with Fields (Vendor Name, Site, Opening Balance, Transaction, Closing Balance)?Content Is there any standard report in AP with… -
Adding days to the Date prompt in OTBISummary Adding days to the Date prompt in OTBIContent Hi Team, I have one requirement to add 6 days to the prompt date and fetch the value based on the new value. +6 or …SM-Oracle 161 views 1 comment 0 points Most recent by Mallikarjuna Maganti Reporting and Analytics for HCM
-
How to enable export functionality in ReportsSummary How to enable export functionality in ReportsContent Hello, We created reports using OTBI and have put them under 'My Dashboards' but we are wondering why we can…Tony Puentes 42 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM