Category 129
Discussion List
-
Need to move Profit and loss FRS report from one instance to anotherSummary: Content (required): I have created a FRS report of profit and loss statement and I need to move it to another instance. Any suggestions on how to do this Versio…AeeTee 12 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
How to create an OTBI Report to display POs by running for GL Parent/Child Department valuesSummary: How to create an OTBI Report to display POs by running for GL Parent/Child Department values Content (required): How to create an OTBI Report to display POs by …Abhilash K - Deloitte USI 12 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Export Current Page returns all rows i.e, entire dashboard data in OTBI.Summary: Export Entire Dashboard is exporting all rows but "Export Current Page" no longer exports only the rows on the current page. It is exporting all rows. Please ad…Abhilash K - Deloitte USI 32 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Extract Fusion Spend Classification Data using BICCSummary: How to extract Spend Classification Data from Fusion? Content (required): As per Fusion 21C, Oracle has introduced Spend Classification Oracle Procurement Cloud…Guillaume Lecouteux. 12 views 1 comment 0 points Most recent by Guillaume Lecouteux. Reporting and Analytics for ERP -
What System Role gives access to PER_LDAP_ROLES?Summary: What System Role gives access to PER_LDAP_ROLES? Content (required): Hi All, I keep forgetting and cannot find a document outlining this but what role gives acc…Nicolas_Trojack 2 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Which database is used by Oracle Analytics Cloud?Summary: I wanted to understand if Oracle Analytics Cloud sits on the same Cloud Fusion ERP database or it uses a different database. Content (required): To be clear - I…Sumit Vijay 32 views 5 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
COUNT Function to get specific valuesSummary: Hi Experts, I have created a report to get the sum of certain rows by specific values. For example, the column returns values as either "REC" or "UNR". So the r…
-
OTBI - Count FunctionSummary: Content (required): I have the below requirement, A report to capture all transaction details and the entry users has already been created. (The format is attac…Sheneli Fernando 33 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
BIP Cloud - Deployment role missingSummary: BIP Cloud - Deployment role missing Content (required): Please note this idea is related to deployment of BIP reports on "BIP Cloud" Problem Description -------…
-
A report for print options for AR customers - Missing FieldSummary: A report is required to detail the print options for AR customers The issue I am having is location the tables that hold Statement Preferred Delivery Methods fr…
-
How to link the sla to an invoice lineSummary: Need to link invoice lines to the subledger xla and xle files Content (required): Version (include the version you are using, if applicable): Code Snippet (add …
-
How to send and unsend a report based on its content in oracle BISummary: How to send and unsend a report based on its content in oracle BI Content (required): Hi everyone, There's a requirement to have a certain report output mailed …Sushan Peiris 22 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
FRS - Selecting multiple values for Point of ViewSummary: Selecting multiple values for Point of View Content (required): Hi All, We have a requirement to selct multiple values for the POV when selecting the initial re…231094 2 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
After a refresh from Prod to Test (P2T), is there a list of recommended processes to run?Summary: After a refresh from Prod to Test (P2T), no data is showing on neither the inquire on detail balances screen nor the budgetary control dashboard. Content (requi…Edward Rogalski 64 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
How to change the logo dynamically in fusion home page?Summary: How to change the logo dynamically in fusion home page? Content (required): Hi All, Is it possible to change the logo based on the user login on the fusion home…
-
Current year + 2 as filter in columnSummary: Content (required): Hi I would like to show the forecast for 2 years from now for a specific column. For example in the code below I've used a repository variab…Nicolas Vahman 12 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Report on OTBI Agents Scheduled / StatusesSummary: Report on OTBI Agents Scheduled / Statuses Content (required): Is there any way to Report on OTBI Agents Scheduled / Statuses, either via SQL in BI Publisher or…AngelOftheNorth 2 views 3 comments 0 points Most recent by User_VX7QK Reporting and Analytics for ERP
-
Combine BiP and OTBI audit data in custom reportSummary: Is it possible to combine BiP and OTBI audit data? Content (required): We have enabled the BiP audit feature and have compiled an OTBI audit report. Business is…Stefan pettersson 12 views 3 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
DFF not available in Subject area even after running the specified processSummary: We have created an OTBI report for Projects using Project Cost - Actual Real Time subject area and it includes a couple of DFFs. This report was migrated from o…Abhishek Shukla 45 views 7 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
how to define a xml in rtf if there are multiple datasets with the same column nameSummary: Hi everyone, Recently I faced an issue with a seeded report that was customized. The report had two datasets with the same column on both, where when I try to l…
-
Error : Exceeded configured maximum number of allowed output sectionsSummary: Error : Exceeded configured maximum number of allowed output sections Content (required): Hi Experts, We are trying to run thr report " Payables Credit Memo Mat…231094 16 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Getting error in FRS reportSummary: Getting errors in the FRS report Content (required): Hi All, I moved one FRS report from TEST instance to PROD. When I try to run the report in PROD, I am getti…Venkatesan 3 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Prepayment invoice detailsSummary: Prepayment invoice details Content (required): Hi experts, I got new report requirement to display prepayment invoice details based on as on date. 1. prepayment…
-
ERP BI and OTBI Reporting - Creating Custom RoleSummary: Hi Guys, Anyone has any idea how to go about creating a Reporting Role for Applications Internal Team for adhoc BI & OTBI reporting . Is there a delivered role …AshishERPCloud 32 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for ERP -
Error whilst joining Subledger and GLHi, I am trying to create a report that joins the subject areas Subledger Accounting: Journals Real and General Ledger: Journals Real Time. It works fine up to the point…BillM 52 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
BI Bursting - ZIP text files during deliveryHi All Is it possible to zip the text files from BI FTP bursting ? ThanksMurthy Kodavati 12 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
Pick Slips Not printing to printerSummary: Pick Slips Not printing to printer Content (required): We have scheduled Pick waves. Document set attached to the rule. Pick slip is submitted but failed to pri…Chandrajit 2 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
customizing Receivables Aging by General Ledger Account ReportSummary: I'm trying to customize the Receivables Aging by General Ledger Account Report, but I'm not able to get any sample data. Content (required): I have created a co…Anders W. Langholm 25 views 3 comments 0 points Most recent by AeeTee Reporting and Analytics for ERP -
Payment infotile no longer be available from update 22CSummary: The Payment Infotile is no longer available from 22C, and Customers need to apply alternate Options for Supplier Outstanding Balance ( Doc ID 2871676.1 ) on My …AVorster-Oracle 13 views 0 comments 0 points Started by AVorster-Oracle Reporting and Analytics for ERP -
Tools > Audit Reports - What table can I look at to see this data?Summary: Tools >Audit Reports > run the report to view changes to supplier banks. There is a field Description. Need the table where this data is populated Content (requ…Jacque Reeves 12 views 2 comments 0 points Most recent by Jacque Reeves Reporting and Analytics for ERP