Category 129
Discussion List
-
Project Number Analysis Is Showing Project Templates As WellSummary: We are trying to generate a new OTBI that lists all the project numbers, irrespective of the project status, and the list shows Projects templates along with Pr…N K Shah-Oracle 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
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 -
Excel Bursting issues with Payables Payment Register reportSummary: Strange behavior in custom Payables Payment Register report Content (please ensure you mask any confidential information): I have customized the seeded 'Payable…
-
Arabic text not displaying properly when generating pdf outputSummary: Arabic text not displaying properly when generating pdf output Content (please ensure you mask any confidential information): Hi Experts, In Invoice Print Templ…Venkatesan 92 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
which table stores the information of Fusion Middleware Error Messages ReferenceWe wanted to find oracle Fusion Middleware Error Messages Reference code and thier meanings from backend tables. While performing any transaction in our fusion instance …Opkey PA 31 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Executing dynamic queryHi, We have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as paramet…JayK 22 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
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
-
General Ledger Detail Dashboard is showing 0(Zero) AmountsSummary: We have developed a Dashboard named CHRS General Ledger Detail Dashboard. In which we were using "General Ledger - Journals Real Time" and "Subledger Accounting…Narasimha Rao Kondapalli 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Error when submitting Intercompany transactionSummary: When creating an Intercompany Transaction, I'm getting the following error. The primary customer site for the customer assigned to the Technical Shared Services…
-
Intercompany Activity in FRSSummary: Intercompany Activity in FRS Content (please ensure you mask any confidential information): Hello - We have a requirement to be able to identify the Intercompan…
-
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
-
Unable to find subject area to fetch FAI Required field for OTBI reportSummary: Hi, we have a requirement to fetch FAI Required field but unable to find the subject area for OTBI report. Content (please ensure you mask any confidential info…Prathyusha pari 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to implement FTP Bursting for Print Receivables TransactionsSummary: How to implement FTP Bursting for Print Receivables Transactions Content (please ensure you mask any confidential information): How to implement FTP Bursting fo…shrikardixit 23 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
22C PORTAL UPLOAD AS A DELIVERY METHOD FOR CUSTOMER TRANSACTIONSOracle has introduced this feature in 22C - I wanted to check if anyone has used this - I do see that delivery method LOV has a new value but I do not see where we need …Dhruvjoshi23 222 views 4 comments 0 points Most recent by Frank Meoli Reporting and Analytics for ERP -
repeate notes for each purchase orderSummary: i created a purchase order report , i have the same notes for each purchase order , when i created a template i can't adjust notes for each po. i uploaded xml f…
-
How to display the German Umlaute like, ä, ö, ß in invoice templateSummary: Unable to display the German Umlaute like, ä, ö, ß in invoice template Content (please ensure you mask any confidential information): We have a requirement for …
-
FRS report Grid IssueI am trying to create FRS report with Grid1 and Grid2. I have lots of columns and detail in Grid1, I would like to copy same detail from Grid1 to Grid2. I am not able to…
-
Query to fetch approver details for all pending requisitionsSummary: Query to fetch approver details for all pending requisitions Content (please ensure you mask any confidential information): We are creating a report which will …Nidhi Chhajed 394 views 13 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Oracle BIP or OTBI reports output in Non-English languages in Oracle Fusion Financials (SaaS)Summary: Oracle BIP or OTBI reports output in Non-English languages Content (required): Hi Team , We are looking for the Oracle BIP or OTBI reports output should be in H…
-
Query to find out GL code combinations used in a bank account (LE and Org access Level)Summary: I need to build a report to query to find out GL code combinations used in a bank account (LE and Org access Level). I used one of the sql provided in oracle do…Mansi1302 952 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Can we do Dynamic Custom File Name in BI Publisher???Summary: We have a requirement to save XML file on the BI report custom name on output files before send the file to SFTP location. File name must have the tag sent by …Sarinee.p 521 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Need a query to get the project actual cost ,committed cost and actual revenue of the project (PPM)Summary: we are developing a BIP report which gives project-wise budget details and actual cost and revenue details. we were able to get the project budget cost and budg…
-
Receivables Aging by General Ledger Account Report - Group by Natural Account segmentRequirement is to group Receivables transactions in "Receivables Aging by General Ledger Account Report" by Natural Account segment only, not by alll Chart of Account di…
-
How can I create this formula for a custom column in OTBI?Summary: I'm attempting to create an asset replacement report with the ability to drill back to the replaced asset (DFF). I need to create a formula to compare two colum…Tasha Kretlow-Oracle 111 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI users are able to edit the report when they have only Read permissionSummary: OTBI users are able to edit the report when they have only Read permission Content (please ensure you mask any confidential information): Version (include the v…Pablo Schenquerman 31 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
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 331 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 121 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…