Category 129
Discussion List
-
how display member name alias on a formI am having trouble displaying the member name and the alias side by side in the rows of this form. What is shown below is the alias. The member names are the actual acc… -
Can we schedule a BI Report run and place the generated file in an SFTP location?Summary: Can we schedule a BI Report run and place the generated file in an SFTP location? How can we do this? -
How to call an Integration in OIC from ESS Job in Oracle Fusion SaaSSummary: How to call an Integration in OIC from ESS Job in Oracle Fusion SaaS Content (required): I have an Integration in OIC and I want it to be triggered by submittin… -
How to display number into decimal number in Oracle cloud sqlHi Team, Need to know about the function to convert integer into decimal like 185 it should display 185.00
-
Report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projectsHello, We have a required to build a BIP report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projects. We need to fetch the financi…
-
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…
-
OTBI time out for regular user super user runs in 22 secondsSummary: We have an OTBI analysis that we built. Content (please ensure you mask any confidential information) For a super user it runs in 22 seconds, but for a regular … -
Is there any method to output a certain number of lines without destroying BIP Excel template layoutSummary Is there any setting/method to output a certain number of lines without destroying the BIP Excel template layout? Content Hi, We are conducting feasibility verif…
-
query to get a tax registration number for legal entitySummary: query to get the tax registration number for legal entity Content (please ensure you mask any confidential information): I want to create a SQL to retrieve a ta…
-
There is a need to show GL Account and Description in 2 separate columns in FRS ReportThere is a need to show GL Account and Description in 2 separate columns in FRS Report Is there any way to split Account into Account and Description column in FRS reportLakshmiVanarasi 11 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
How to execute BIP report and get a PDF file by calling SOAP web service ?Summary: How to execute BIP report and get a PDF file by calling SOAP web service ? Content (please ensure you mask any confidential information): BIP reports were run u…
-
Grouping in FRS based on parameters passedCompany Cost Center 1111 11111 2222 22222 3333 33333 If user selects the above combination in the parameters in an FRS report, the data should be fetched for the sum of …PrerakKhandelwal 41 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
Combine OTBI and BIP report, role issue/quesitonSummary: I have created a report where I combine OTBI and BIP report in one BIP datamodel. This is due to missing information on OTBI side. Report works as a charm but l…alexey.shtrakhov 71 views 5 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
FRS report for particular ledger and Period not returning Data. What may be the reasonSummary: FRS report for particular ledger and Period not returning Data Content (please ensure you mask any confidential information): Summary: FRS report for particular…
-
Unable to find create data model option after adding related BI rolesSummary: Hi Team, To one of the user account, we wanted to provide access to BI Currently after providing 'BI Administrator Role' and 'BI Publisher Data Model Developer …
-
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b…User_2025-02-11-06-12-35-024 844 views 11 comments 0 points Most recent by Eswarvoona-Oracle Reporting and Analytics for ERP -
Conditionally display columns in an BIP etext rtf template.Summary: Example out of 50 columns, first 30 and last 10 columns will show up always and 10 columns in the middle will show up only on a certain condition. Note: The req…Sunil Pradhan 63 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Chinese letters turning to special character when extracting via CSV BIPHello Oracle, Is there a way to adjust the output character set when extracting a BIP Report (Oracle BI EE Data Source) to CSV? We are having issues when extracting Chin…Ralph Aldrich Magno 11 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Fetching Flow Through Funds fields under Grants module in Base tablesWe are unable to fetch values in Base tables for Flow-Through Funds fields like Sponsor , Reference Award Name, Amount under Grants module. PFB the required fields viewe…PrerakKhandelwal 21 views 1 comment 0 points Most recent by Meredith Bickell Reporting and Analytics for ERP
-
Is it possible to BICC Export a file to FTPSThe client need a way to download/export the BICC file from UCM to client File Transfer Protocol Server. Is there any way to do this?Pedro Bacic 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Table to find PO line level attachmentsSummary: We can see line level attachments on the PO page. However, we don't see the attachment details for all the lines in the fnd_attached_documents table. We also ch… -
Why the printing from the fusion is different from a laptop to another ?!Summary: I've tried to print a report from the fusion (its layout is made by the word in a RTF format) and it's been printed correctly on my laptop but the other laptops…User_F2YWU 11 views 4 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for ERP
-
What tables should I consult to relate the details of budget control associated with obligations ...Summary: We are developing a report in Oracle Publisher related to budget control, but we are unable to find the necessary documentation. We need information on Budget T…OsvaldoFI 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Payables XML can't perform a substring to a concatenated string inside a for-eachSummary: When creating a payment request, we need to have all invoice numbers concatenated in the same field "Ref" from the XML template. However, the bank only allows l…Emma Fayos García 1 view 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Adding manually uploaded attachment in Email BurstingSummary: Is there a feasibility to attach manually upload files in Email Bursting along with Bursting output Content (please ensure you mask any confidential information…Rukmini Kumbham 181 views 9 comments 1 point Most recent by MFM Tech Reporting and Analytics for ERP
-
OTBI Prompt - Default Programmatically setting dateSummary: When adding in an accounting period, I'm not able to programmatically set a date with the format YYYY-MM. I've tried a few different things but I can't seem to …
-
Request for Custom SQL Query for SaaS Service Usage Metric Report (Oracle Fusion Expenses)Hello Team, We are in a need of a custom sql query which Oracle uses to populate a count for the below service in the SaaS Service Usage Metric Report, as we got to know…
-
Is it possible to filter Receivables Subject Area by a rollup within the Chart of AccountsSummary: Is it possible to create an OTBI Analysis that filters a segment of the Chart of Accounts by its roll-up within its hierarchy Content (please ensure you mask an…
-
Oracle Fusion Cloud Sustainability posibility to report via OTBI/Subject AreasThere is a module available for all ERP customers where you can store sustainability data. Created via AP invoices or imported via external systems. This is something th…AnnelizeHenskens 1 view 2 comments 0 points Most recent by AnnelizeHenskens Reporting and Analytics for ERP -
Oracle EPM SmartView pulling backend 16 digit numbers instead of members from Fusion ERPWhen we tried to login into Oracle Fusion ERP through SmartView and perform adhoc analysis, we encountered an issue having 16 digit numbers instead of member names/Alias…Suriaraj.Krishnamurthy 1 view 3 comments 0 points Most recent by Suriaraj.Krishnamurthy Reporting and Analytics for ERP