Category 129
Discussion List
-
Borders are not displaying in Word(.docx) outputSummary: Borders are not displaying in Word(.docx) output Content (required): Hi Experts, We develop RTF with borders, but when we run the output as .docx borders not di…Venkatesan 41 views 3 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
Role required for viewing otbi subject area "Project Costing - Actual Costs Real Time"Summary: Role required for viewing otbi subject area "Project Costing - Actual Costs Real Time" without allowing them to run Import Costs and Import Commitments schedule…MHaynes 51 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
AR Transaction status in OTBII am creating a (crude) AR Aging report for a specific transaction type in OTBI, to include in in a dashboard. All columns I need are included in the subject area "Recei…MaartenDIF 198 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP -
OTBI QuestionsSummary: Content (required): In "Payables Invoices - Transactional Real Time" subject area, why do we have so many invoice currency fields and why some of them are givin…Vinay Gharge 51 views 1 comment 0 points Most recent by Daniel14337-Oracle Reporting and Analytics for ERP -
Digitally Sign BIP report sent to SFTP server using BurstingSummary: Hi Team, Once we set up the SFTP server in fusion as a delivery option, there is a checkbox to sign output. So does it digitally sign the file and it will use w… -
API to manage BIP Catalog ObjectsSummary: Content (required): We have a CatalogService WSDL to download and upload catalog objects, however, that API asks for passing the username and password in the Bo…Vinay Gharge 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
REST API to schedule and run report in Oracle Fusion BIP reportsSummary: REST API to schedule and run report in Oracle Fusion BIP reports Content (required): Version (include the version you are using, if applicable): 22D Code Snippe… -
Need help in understanding the BIP SQL query (new to SQL and BIP)Summary: Hi Experts I'm new to SQL and BIP reporting. I'm working on one BIP report and I have added parameter to an existing BIP query to filter based on item number, a…Sharmava 52 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
How to add customer number field in Manage and create receipt screen?Summary: How to add a customer number field in Manage and create receipt screen? Content (required): How to add a customer number field in Manage and create receipt scre…Venkatesan 91 views 5 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP -
Invoice History Report for a given supplierHi All Is there any standard report which allows to drill down open closed invoices per supplier and also drilldown to the individual invoices via deeplinks ? Thanks Mur…Murthy Kodavati 11 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
Has anyone use SplashBi or Orbit Analytics before?Summary: We are reviewing some external vendor tools to work with Oracle EBS and want to know if anyone has used this before and can make some recommendations. Content (…michael.cordova 113 views 0 comments 0 points Started by michael.cordova Reporting and Analytics for ERP -
Customizing Print Receivable Transactions: Invoices ReportSummary: We have this seeded report "Print Invoice Template" (Defaultinvoice.xdo) which has a corresponding ESS job "Print Receivable Transactions: Invoices" which is a …Ashu Raj-Oracle 554 views 8 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
FRS report duplicating parent when opening in BI catalog, but does not when opening in WebStudioSummary: Content (required): Hello: Does anyone have an idea why a row would duplicate for a parent when opening the report from the Catalog, but not when opening viewin…55Chevy 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Schedule BI Report > Schedule tab > UTC Time ZoneSummary: Schedule BI Report > Schedule tab > UTC Time Zone Content (required): Hello All, When we schedule a BI Report from the Schedule tab: it seems the Time Zone of t…Bernard T 22 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Unable to suppress columns in Smart View retrieveSummary: Apologies if this is the wrong forum on which to ask this - I have created a Smart View retrieve to extract data from ERP, however in Smart View -> Options -> D…Danny Emmerton 194 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Is it possible to group pages members to create a new structure in Financial Reporting StudioSummary: Within Financial Reporting studio , I would like to create a balance sheet for different cost centres , but have a collection of cost centre grouped for each pa…Estar45 21 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Grouping Columns into oneSummary: Is it possible to group different members into one column in financial reporting studio Content (required):Financial reporting studio Version (include the versi…Estar45 32 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Report on Report Usage in FRSSummary: I am trying to gather information on which users run which reports in FRS. I have created an OTBI Usage report but that report does not include reports in the F…Jarrett 41 views 1 comment 0 points Most recent by Daniel14337-Oracle Reporting and Analytics for ERP -
Need a query to get negotiation approver list in oracle fusionSummary: Content (required): Hello everyone, I need a query to get negotiation approver list in oracle fusion.Please advise! BR, Sushan Peiris Version (include the versi…Sushan Peiris 270 views 1 comment 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Getting warning while creating Content Data setSummary: Getting warning while creating Content Data set Content (required): Hi All, Got a requirement to show attachments in the PO PDF report. So we try to customize t… -
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…Sushan Peiris 145 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Calculate difference between previous and current amountSummary: How to add a column for calculating the difference between yesterdays closing amount and todays opening amount Content (required): We have built a simple OTBI r…Stefan pettersson 42 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP -
How to customize Goal workflow notificationSummary: Content (required): Hi All, We have a requirement to customize the Goal workflow notification. we need to replace the word Goal with Objective. Is it possible ?…Venkatesan 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
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 98 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 14 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 71 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP