OTBI
Discussion List
-
How to update Data Time Zone offset in the Data Format tab of Column PropertiesSummary: OTBI report using Posting Date can be displayed in Sydney timezone but when it is used in a calculation in Edit Column Formula, it reverts back to UTC timezone.…Jennifer-Leung 13 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
We are trying to access OTBI Reports on Screen Cloud using RSS Feed optionSummary: Not able to access the OTBI reports in the screencloud or any RSS platform. Content (please ensure you mask any confidential information): RSS Feed Version (inc…Adithya Koushik 21 views 2 comments 0 points Most recent by Adithya Koushik Reporting and Analytics for ERP
-
Error in OTBI report while using 2 Procuement subject areasSummary: I am trying to create a OTBI report to understand Non catalog Requisitions which are not created from Smart forms. For this i am combining 2 subject areas namel…Shameek 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI Bad Performance- After Adding Accounting Class Code - Subledger Accounting - Journals Real TimeSummary: Using subject area Subledger Accounting - Journals Real Time, for example looking at source: Projects with a filter on natural account/concatenated segment and …Rich Merkel 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…anusha chunduru 4.2K views 6 comments 1 point Most recent by User_S6U3H Reporting and Analytics for ERP
-
OTBI Report Perfomance issue when I apply the 7 countries in promptSummary: Hi All, We have OTBI report but in report Perfomance issue when I apply the 7 countries only but if i apply one country working fine in prompt . https://us.v-cd…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Absence reportSummary: I have created a OTBI report to pull absence details and it has parameter of two dates start date between. Client is passing the dates of 1st of Aug to 30th Aug…Reddykrishna Chidella-Oracle 51 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can someone help me how to apply Pivot in my OTBI Analysis?Summary: There are multiple values per employee. I want it to display in a single row, but one per column. Is it possible? Your help is so much appreciated. Content (req…Hazel De Castro 31 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please …
-
how to get json formatSummary: Hi, We've a requirement to format output into Json format. Is it possible to do OTBI / BIP Report in this format? Any help is highly appreciated. Thank you! -
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details…Veronica Dumitriu 9.4K views 168 comments 46 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for ERP -
is there any standard PVO available for table MSC_PEGGING_DEMAND2_VSummary: I am trying to extract data from Oracle Fusion using BICC. Please suggest the corresponding PVO for the table, MSC_PEGGING_DEMAND2_V Content (please ensure you …Anuprasad Anilkumar 21 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration
-
BI Publisher or OTBI Reporting on field used for ADP Workforce Now integrationHi, we do payroll in ADP Workforce Now and run a daily integration from Oracle. We want to know if it possible to report on this field used for the ADP integration only.…
-
OTBI - Static PDF attachment in email notificationSummary Is there any option to attach PDF in email notificationsContent Hello, We have a requirement to send email notification to new joiners along with user guides att…User_2025-02-05-07-43-29-505 70 views 8 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for HCM -
OTBI Report for Gross EarningSummary: Hi Can you please suggest if it is possible to create a report in OTBI that will provide gross earnings per element for a specific period? If it is possible, ca…
-
Create/update Install base asset in ALM whenever the install base asset is created/updated in EBSSummary: We have a requirement to Create/update Install base asset in ALM whenever the install base asset is created/updated in EBS as part of the long term EBS to fusio…
-
How can we have unmapped columns in Import Map Template?While Creating an Import Map, we chose to not map few columns to Master Data. These unmapped columns are switched to Ignored status upon saving the Import Map and are no…
-
Periodic Accrual in OTBI giving wrong valueSummary: Requirement is to create a OTBI report that has accrual plan balance and accrual value from last period. Plan is incremental so every period, employees accrue a…
-
SQL for Project Events InvoiceSummary: Trying to get the approved Invoices only and I am getting incorrect values. Content (please ensure you mask any confidential information): Code Snippet (add any…
-
Equivalent reports in fusion for the following EBS reportsSummary: Hi All, Could you please help to find the equivalent reports in fusion for the following EBS reports. 1.All Inventory Value Report 2.Material Account Distributi…
-
OTBI - Retrieve Manager of indirect reportsSummary: OTBI - Retrieve Manager of indirect reports Content (please ensure you mask any confidential information): Hi experts, we would like to create a report for all …Oriana L. 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Custom LOV for OTBI PromptSummary: Custom LOV for OTBI Prompt Content (please ensure you mask any confidential information): Hello experts, we have created a report for all the managers within th…
-
Showing month name in graph in OTBI AnalysisHi, I've developed an OTBI Analysis which has a Graph view where I'm printing the Month in the X axis. The issue I'm getting is month is coming as numeric value but our …
-
Purchase requisition and purchase order Comparison ReportSummary: I want to create a query to retrive PR Amount and PO Amount Associated with It and return difference between them Content (please ensure you mask any confidenti…Mohamed Adel53 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM