OTBI
Discussion List
-
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P…Sam Samaddar 21 views 4 comments 0 points Most recent by Sam Samaddar Reporting and Analytics for ERP -
Procurement - Purchasing Real Time project DFF missing after 24B updateSummary: Procurement - Purchasing Real Time project DFF missing after 24B update. This was working fine before the update. Did this get removed from the subject area? Co…MichelleHaynes 11 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP -
OTBI scheduled reports/analyses "From" email changedHas anyone else noticed a change in the "From" email address for scheduled reports/analyses from OTBI? I have rules in my Outlook to filter these to a specific folder an… -
Grouping in OTBISummary: Hello, In the screenshot there are 3 lines here coming from one transaction. I want to group these into one line with all the data you can see on the screenshot…
-
Does anyone have a template for annual retirement plan audit information?Summary: I need a report to show Total Gross Earnings, Deferral Eligible Earnings, Employee Contributions, Employee Roth Contributions, Employer Matching Contributions a…Chris West 1 view 0 comments 0 points Started by Chris West Payroll and Global Payroll Interface (GPI)
-
Alternative to Oracle BI Mobile appSummary: Earlier oracle provided the ability to scale the report output to fit the screen size of the device using the Oracle BI Mobile app. However, the app is now in d…Hitesh Khandelwal 13 views 2 comments 0 points Most recent by Hitesh Khandelwal Reporting and Analytics for ERP
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…Cesar Saveedra 23 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
Employee Job HistoryHi I am looking for a data mart/query I can use that provide employee job history. For context, here is what I am looking to do. If we hire an employee into a specific r… -
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …Shubhojit Purkait 625 views 9 comments 0 points Most recent by Subhojit31 Reporting and Analytics for ERP
-
how to add months 24 to a date field in the OTBI Report FilterSummary: I would like to add 24 months to length of service date field using case when. Please provide the code how to write in OTBI Content (please ensure you mask any …Anjan Polimera 13 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Some columns have null values for certain records and record is not retrieved when the column is selSummary Some columns have null values for certain records and record is not retrieved when the column is selectedContent I am using "Fixed Assets - Asset Depreciation Re…
-
accounting asset inquirySummary: Hello everyone, I am making a report from which I need to obtain the following value from the box in red. I can't find the table in which I can locate those val…
-
How to find the information of different view objects using same tableSummary: Hi, We have used the "Rel13_23D_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx" provided by oracle. We have looked for VO using the table GL_JE_LINES. The spr…
-
How to implement the Column Group in OTBISummary: I am checking a seeded report "Top 10 Requisitions Breakdown". can anyone help me how to implement the below column group functionality in OTBI report? Also, Ho… -
Trouble with GaugesSummary: I'm trying to create a simple gauge that shows the percent balance left, but the gauge is not reflecting the correct information. Content (required): I'm using … -
Expression: Project Currency error when using dashboard prompt for project cross subject area real tSummary Error Codes: OAMP2OPY:G689FFB3:SDKE4UTF Expression: Project CurrencyContent wonder if anyone encountered the same issue when developing a new OTBI report using p…Sam Solomun 101 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 1.5K views 16 comments 21 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
GL Detail Report w/ Subledger DetailsSummary: Finalize/Tweak built custom OTBI report to export the last bits of data needed by our auditors. We've built a custom OTBI report that exports GL and SLA numbers…Henry Imgrund 11 views 1 comment 1 point Most recent by James McBride Reporting and Analytics for ERP
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Lalit Sinkar 21 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Want to embed only bip report output and not the header sectionSummary: Hi Experts I want to embed below bip report in the supplier page but i could see that when i embed the bip page the header containing web page, home, catalog,fa…mudassirsOrc-Oracle 11 views 4 comments 1 point Most recent by mudassirsOrc-Oracle Reporting and Analytics for ERP
-
Left Outer Join between the same tableHello, I am trying to get a list of all expense reports and populate the Expense Report History.Event Date only when the Event Status is a specific one. So I attempted t… -
Can we use Pivot dynamically in BIPSummary: Hi Experts , We are having a requirement to convert rows to columns dynamically we used pivot to achieve this but by using pivot we need to hardcode values whic…Bhavani Rikkula 101 views 10 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Drill down to ERP pages through Infolets as standard onesSummary: Hi, We want to create objectives that are actionable that is, as the standard ones from Oracle. For example, create an infolet that shows the number of invoices…Emma Fayos García 21 views 2 comments 1 point Most recent by Emma Fayos García Reporting and Analytics for ERP
-
showing a historical assignment as latest for some employeesSummary: We have an issue where the top (or Max) row is not returning the correct row! Instead of returning the current assignment, it is returning an old assignment for…
-
Project Control - Budgets Real TimeUsing Project Control - Budgets Real Time subject area need to showcase Budget Cost in Project currency as well as in Ledger currency but unable to identify the dimensio…Kalyani-Oracle 21 views 3 comments 0 points Most recent by Kalyani-Oracle Reporting and Analytics for ERP
-
OTBI IssueHi There is an existing OTBI report which attached below. Now the customer requirement is to add the below condition. But on adding this, the count is reducing. Please s…Dona Das-Oracle 31 views 5 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
How to add Dashboard or OTBI analysis on Navigator or Springboard (Home page)This discussion provides step by step guidance on how to add OTBI analysis or Dashboard or any external webpage to application UI home page or on Navigator as new page e…CA Nirmal Choudhary 803 views 1 comment 3 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your thoughts. Content (please ensure you mask any confidential i…Lucky Sharma 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Where can I find the Payment Number for Payables on OTBISummary: I'm trying to pull together a report listing payments made to suppliers and need to include the the Payment Reference Number (i.e. the cheque, payable order (PO…