Category 129
Discussion List
-
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 12 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 23 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 14 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 215 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 307 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 851 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 417 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 69 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 32 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 258 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 94 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 408 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 24 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP