Category 129
Discussion List
-
Is there a limit to the number of columns in a data modelHello, I’m attempting to create a report using a SQL based data model. It has about 90 columns but when I run the report it leaves off the last 2 columns. Is there a lim… -
Can we define custom report view in custom reportDear , We have one custom report (SQL query), now our requirement we have to show data as per user login For example if User ABC login report shows only custom Data whic… -
Fusion UI Customization TablesSummary: Fusion UI Customization Tables Content (required): Hi All, From which table we can get fusion page customization details like, who did the customization and the… -
GL Value set DFF's are not available in SmartView/ FRSSummary: GL Value set DFF's are not available in SmartView/ FRS. Please let me know is this standard functionality. My client want to track this. Let me know we have ano…User_2025-02-12-18-40-30-943 97 views 2 comments 0 points Most recent by User_GRG5N Reporting and Analytics for ERP -
FRS 13 Month Rolling Reports Error Executing Query since 22C UpgradeSummary: Content (required): Hello: Is anyone having issues running FRS rolling reports since the 22C Upgrade? Our other reports are running fine, but we are getting an …
-
FRS Heading not Centering in Excel exportSummary: Content (required): I have an FRS report that has about 13 columns. The header is centered across the report with the ability to autosize. Looks great online bu…Cathy Watson Moore 13 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
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 76 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 24 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 74 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…User_2025-03-07-20-48-43-319 44 views 1 comment 0 points Most recent by User_2025-03-07-20-48-43-319 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 21 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 41 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…Vipusha Chandrakumaran 86 views 3 comments 0 points Most recent by Vipusha Chandrakumaran Reporting and Analytics for ERP
-
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…Sheneli98 1.5K views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
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…User_2025-02-11-10-53-01-866 42 views 2 comments 0 points Most recent by User_2025-02-11-10-53-01-866 Reporting and Analytics for ERP
-
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 42 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri 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…Ed R. 603 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 22 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…User_2025-02-10-15-12-48-631 48 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 45 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 903 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…Vipusha Chandrakumaran 460 views 1 comment 1 point Most recent by Noelle Bartlam-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 81 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 79 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 240 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 44 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP