OTBI
Discussion List
-
Compensation History tables and dataHi All, I am unable to get the Compensation History data using below query. Can you please advise if anyone has the query or table accordingly. SELECT hth.transaction_id…Sai Shyam 41 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service -
How to join 2 different tables using query builderHi Oracle Community, I m new SQL and took help of query builder to select few columns from payroll tables and would like to join with HR tables. The next few columns I, …
-
BIP report parameter is not working as expectedSummary: Hi All, For BIP report parameters, I have used the below part and it is not working as expected. When a period, CO, and Account parameter is given that time it …AKV27 13 views 1 comment 0 points Most recent by Sandeep19rm Reporting & Analytics for Fusion Service
-
drill down financial reporting and otbiSummary: drill down financial reporting and otbi Content (please ensure you mask any confidential information): is it possibile drill down in accounting hub for financia…
-
We are trying to extract month from a date column in OTBI after we convert it to Mountain Time.Summary: We are trying to extract month from a date column in an OTBI report after we convert it to Mountain Time. However we get the month from UTC only.Any suggestions…
-
How To Print Sales order Line Text Attachments into BIP reportSummary: We have requirement of "Print Sales order Line Text Attachments into BIP report", Please note: We have the same requirement for PO line text attachment which is…
-
Can we add GBPA number as a link in a BI report?Summary: We have a BI report to extract details related to Purchase Agreements. Can we have the Purchase Agreement number as a link in th report , clicking on which woul…
-
Information about Report and its linked data modelSummary: looking for any table or Subject area where we can get information about Report and its linked Data model. to ensure that every report linked with report after …Amit_Ekbote 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Dashboard Filter in IST but results in ESTI have a dashboard filter that is run off IST time. Is there a way to modify the time zone in the dashboard filter? For Example: When entering a date range of 5/29/23 to…
-
Incomplete information in the dashboard Customer Listing ReportSummary: Site Purpose Source Reference field does not always display record information Content (please ensure you mask any confidential information): In the dashboard C…SERGIO BARRETO 11 views 0 comments 1 point Started by SERGIO BARRETO Reporting and Analytics for ERP -
Changes or new journals not reflecting immediately in OTBI reportWe have OTBI GL drill down report built on General Ledger - Journals Real Time subject area. But any new journals are not reflecting in this report immediately. How we c…Narasimha Raju 21 views 4 comments 0 points Most recent by Narasimha Raju General Ledger & Intercompany
-
how can I create a aging OTBI report of negotiation by status.Summary: how can I create a aging OTBI report of negotiation by status. the columns i expected is status, count, days count (rage created date ie,0-5 days, 5-10 days). C…
-
How to Create Planned Order Report from Supply Planning DetailsSummary: Currently, user will go to supply planning screen and export planned order details manually to get the report. We need help for query to write this report and s…AISYAH ATHIRAH 92 views 2 comments 0 points Most recent by AISYAH ATHIRAH Supply Chain Planning and Collaboration
-
How to add Batch quanity in Work DefinitionHi, We have more than 3000 work definitions in our application. means that for each and every work definition, we must add the batch quantity. is there any methods or sp…
-
Need column mapping of With this note in learning assignment in OTBI Subject areaSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI analysis with Termination Reason and Termination Category are failing after 24A upgradeSummary: Hello, All our OTBI analysis with Termination Reason and Termination Category in them are failing after 24A upgrade. I forced deployed PER_ACTION_OCC_EIT_EFF ex…
-
Remove column from Excel BI Publisher reportI have a report containing many columns that I prepared using Excel Publisher and I want to remove a column, but when I upload it back to the system by clicking delete t…Cansel Karasoy 524 views 2 comments 0 points Most recent by Alexandru Burcea-Oracle Reporting and Analytics for HCM -
OTBI report how to display parameter list of values only with the report result in the list ?Hello , In OTBI report, we would like to have a list of values on parameter “location “ based on the values of the report result . Only the values that are extracted fro…Revital Mefano 432 views 4 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
Displaying different sections in mobile app and web app on dashboardHello, in the dashboard I have prepared, I want some sections to appear only in the web application. I want some of them to appear only in the mobile application. Is thi…Sinem Kara 21 views 1 comment 0 points Most recent by Florin Loghin-Oracle Reporting and Analytics for HCM
-
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
Employment Terms Assignment Number in OTBI Report AnalysisHow do you retrieve Employment Terms Assignment number format? into an OTBI Report Analysis in the format needed for use in spreadsheet loader template?
-
How to reconcile MPA invoices vs GL Trial Balance ?Summary: How to reconcile MPA invoices vs GL Trial Balance ? Content (required): Hello We have several invoices in AP that were transfered to GL in summary hence I was w…Cesar Saveedra 81 views 2 comments 0 points Most recent by CA Syed Irshad Ali Payables, Payments & Cash Management
-
How we get difference of two sum from the same table?Summary: Content (please ensure you mask any confidential information): Hi, We would create a column in a report who get a difference of two sum from the same table. Wha…Ylenia Gentile 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Can you create a personalized prompt to combine multiple selections into 1 prompt selection?Summary: Wondering if it's possible to create a custom prompt in an OTBI report to create a 'group' to select for a variety of different job name codes? Content (please …
-
How to use TOPN in a filter in a column in OTBISummary: I would like to use a TOPN filter in a column formula in OTBI to provide the latest date. There are multiple lines per employee and just want the latest seniori…
-
Just went live and delivered reports don't return data. Need help troubleshooting Absence Calendar.Summary: I am brand new to Oracle and trying to figure out why we're not seeing data in the delivered reports. The one I'm working on now is the Absence Calendar. I've r…Dana Lockwood 51 views 8 comments 0 points Most recent by Dana Lockwood Reporting and Analytics for HCM
-
CX - Is venn diagram possible in OTBI?Total value of opportunities and Total number of opportunities should be displayed in the diagram along with the status. Is following design possible in OTBI?Nalsoft Pvt Ltd 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Reporting on Leave Duration Without Absence ModuleSummary: Need to report on how long employees have been on a continuous leave using assignment real time subject area. This is for an existing report and my preference i…Matthew Phillips 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM