Category 129
Discussion List
-
Make every report output display date in PST timezone instead of UTC in Oracle FusionSummary: Hi Team , is there a way that you are aware of in oracle cloud that we can make the report to run in California timezone instead of default UTC timezone of clou…Abhilash K - Deloitte USI 261 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Merge Two OTBI Subject Area For PO receipt dateHi , We have a requirement to develop OTBI report for the following fields ( promised date, Requested Date and Receipt date) for po using two OTBI subject areas we are u…Prathyusha pari 92 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to deliver BI Report output to share point locationSummary: Is it possible to create a share point connection in BI administration so that BI Report output can be delivered directly to share point location.
-
Custom Calculated Measure to Sum Two Calculated Measure Fields Not Calculating CorrectlySummary: I want to have a column called, "Total Costs" which sums the amounts from two calculated measure fields but for values where one of the calculated measure field… -
Replacement for FscmTopModelAM.ItemCostDailyAM.ItemCostDailyPVOSummary: With the loss of data availability for this PVO in 24A (see Document 2998181.1 (oracle.com)) our PECSV files are coming back with 0 rows, i.e. the table is no l… -
25A Responsive Self ServiceHi, is there an impact assessment doc available for Responsive Self Service in 25A? If so, is there a step by step setup document? Thanks, Frankie
-
OTBI Performance - Project Cross Subject Area - Date Filters Affecting Performance very badSummary: Using Projects - Cross Subject Area Analysis - Real Time there are severe performance issues filtering by accounting date less than or equal to. There is same … -
how to use listagg function in rtf template?Summary: Requirement to display a value (output of for loop) in a single row in RTF template, as of now its displaying each value in each row. Needs to be handled in RTF…Thanigainathan R 411 views 4 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for ERP
-
User Role Memberships Report - possible location in OTBI?Apart from the scheduled process, the report can be seen. Is it also possible to locate this in OTBI?
-
Inactive User Report - Is it possible to see this in OTBI?Inactive User Report - Apart from the scheduled process, the report can be seen. Is it also possible to see this in OTBI? If yes, where is the path name?
-
how to add attachment column in bank account creation of register supplier page in fusionSummary: how to add attachment column in bank account creation of register supplier page in fusion Content (please ensure you mask any confidential information): Hi All,…Venkatesan 21 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
In Maternity Leave - Absence Type Balance is not Showing for the EmployeeSummary: Created a Maternity leave with Qualification Plan. But Absence Type Balance i am not able to see the number of balance days. -
Flexfield Feature at BIP Model using where LexicalSummary: I want to make a report that similar to Budgetary Control Analysis. My current report, I define the segment1 as balancing segment, segment2 as natural account, …
-
Deliver BIP report to sharepointSummary: Ability to deliver BIP report to sharepoint seems possible, but documentation is from 2007 and doesn't seem to line up with current sharepoint screens. Content …Alex Glose 87 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Define a global function in BI reportsDear All, Is there a way to define a global function in BI reports to use it across all reports? For instance, NLS_NUMERIC_CHARACTERS?George Mattar 31 views 2 comments 0 points Most recent by Alex Kaleas Reporting and Analytics for ERP
-
Error when invoking ESSWebService submitRequest method from SoapUiHi, I'm trying to submit a request to run the job "ItalianSalesVatRegister" and I receive the following error: oracle.as.scheduler.RuntimeServiceAccessControlException: …
-
How to get only Month and year without days in otbi report Pivot table?Hi everyone, I'm working on an OTBI report and I'm stuck with a visualization challenge. I'm using an accounting date in a pivot table, but I want to display each year a…
-
BIP report output with 0 KB.Summary: We have a custom BIP report with a datamodel. The data could be seen when viewed in the data tab of the DM. When the report was ran in the BIP (using the schedu…Chetan Konda 95 views 14 comments 1 point Most recent by Chetan Konda Reporting and Analytics for ERP -
Varalakshmi 31 views 4 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Segment value Security tableSummary: Need a table that stores values stored in Segment Value Security (SVS) Rules. Content (required): Table fnd_object_instance_sets stores the value in FILTER colu…
-
Joining Subledger data with GL dataI need to build a query which joins subledger data table, xla_ae_lines to gl_je_lines. I am attempting this through gl_sl_link_id but the performance is awful, is there …
-
Italian AR E-Invoicing ProgressivoInvio NumberHi, As per Italian reporting requirement we are developing Italian AR E-Invoicing report with XML output. We have a tag called 'ProgressivoInvio', as per the customer re…
-
how to add unpaid reason under transaction tab for collections dashboardSummary: how to add unpaid reason under transaction tab for collections dashboardSwapnil Sapkal 21 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Performance impact while using standard viewsSummary: Is there any performance impact while using the standard views (in a BIP report) listed by Oracle. For eg. using standard view PJF_PROJECTS_ALL_VL, instead of t…
-
Unable to find Award Open and Close date, and Award Approval Date in OTBIHello, I am working on an OTBI report that requires the following fields: Award Approval Date Award Open Date Award Close Date I was unable to locate them in the Procure…
-
Can you use temporary tables in cloud fusion otbi?Summary: Can we use temporary tables in cloud OTBI as a replacement for multiple union select statements Content (please ensure you mask any confidential information): W…Erik Bjerkelund 82 views 2 comments 0 points Most recent by Erik Bjerkelund Reporting and Analytics for ERP
-
How to get the IP address of OTBI to add to a SFTP whitelistI am trying to get my OTBI environments IP address so I can whitelist it on a SFTP site. I found documentation on all the IP address, but I don't know which server I am …NicolaosDerr 101 views 2 comments 0 points Most recent by NicolaosDerr Reporting and Analytics for ERP
-
Unable to view the data in data model with lexical parameterSummary: Unable to view the data in data model with lexical parameter Content (please ensure you mask any confidential information): Hi, We are trying to create a BI rep…JithendraKCV 32 views 1 comment 0 points Most recent by JithendraKCV Reporting and Analytics for ERP
-
Generate blank BIP reportHi Team, We have a BIP report in Oracle fusion that has a bursting code. This works fine when there is data for report. However, if no data is returned by the underlying…Prabhjeet Kaur 345 views 5 comments 0 points Most recent by Cm Adil Ch Reporting and Analytics for ERP
-
How to join from Subledger Accounting (XLA) to transaction application entity code PJBACCOUNTINGSummary: Hi, How do we join to get transaction details in the subledger application from XLA_TRANSACTION_ENTITIES where SOURCE_APPLICATION_ID = '10036' (Project Accounti…