Reporting and Analytics for ERP
Discussion List
-
REST API for Profitability and Cost Management.Summary: DOWNLOAD FINANCIAL REPORTING REPORTS IN PROFITABILITY AND COST MANAGEMENT WITH REST API. Content (required): Hello, I have reports created from the reporting to… -
Can BICC write CSV files to Object storage or UCM without zippingSummary: Can BICC write CSV files to Object storage or UCM without zipping Content (required): Currently BICC writes CSV files with zipping onto Object storage or UCM. S…
-
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…
-
How to translate Amount in Words from English to Arabic language in rtf templateSummary: we have a requirement to print Payment amount in Words (English) to Arabic language in check template. The expectation is that, translate below given English te…
-
Can BICC write files to Object storage or UCM without zippingSummary: Can BICC write CSV files to Object storage or UCM without zipping Content (required): Currently BICC writes CSV files with zipping onto Object storage or UCM. S…
-
SKIP ROW based on an attribute in one sheet of a multi sheet excel templateSummary I have a summary and detail excel template. I need to suppress rows which have a value of zero on one particular attribute of the row.Content I have inserted the…
-
GL Budgets not being returned from General Ledger - Balances Real TimeSummary: Subject area General Ledger - Balances Real Time not returning data for GL Budgets (budgets are loaded) Content (required): Hi, I have followed Doc ID 2177122.1…
-
Convert Period Name to DateSummary: Trying to convert period name format to date format mm/dd/yy Content (required): Hi All, I'm trying to convert the column "Fixed Assets - Asset Depreciation Rea…
-
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…
-
Pricing List ReportHi, I am looking to create BI publisher report on Pricing List. If you can share the query and RTF template if any available please do share Thanks -
rtf template balance lines between two adjacent cellsSummary: RTF Template - Balance lines between two adjacent cells Content (required): We've modified our invoice print template to include serial numbers when applicable.…
-
Query to fetch List of OTBI usersHi Team, We do have a requirement to Create a report for List of users having OTBI access. Regards, Ramu
-
How to find from which system or ip submitted a bip reportSummary: can we check from which system or ip a bip report got triggered? we are using a generic login shared across all developers and testers Content (required): can w…
-
Obtain the number of SQL executions or the number of executions of the BIP itselfSummary: I want to create a query to extract the number of data model runs or BIP reports run in ERP's BI publisher. Content (required): The objective is to extract the …
-
How to check Agent HistorySummary: How to check Agent History Content (required): As JOb history in BI shows executions of BI reports, do we have similar place to see executions of Agents ? Versi… -
OTBISummary: Hi Experts, I want to measure the performance for last 5 years, the year should be consist the data from July to Jun, instead of Jan to Dec. how I can convert t…
-
Getting an error while trying to open Supplier Master OTBI reportSummary: Unable to open Supplier Master report created in OTBI Content (required): Hi, I have created a supplier master report in OTBI with the fields such as Supplier N… -
Report for License ConsumptionSummary: Simply do not know how to pull a report that tallies license consumption by user. Content (required): Can someone provide the report or directions for reporting…
-
What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…
-
OTBI results in errors saying "The specified criteria didn't result in any data."Summary: OTBI results in errors below Error Message : The specified criteria didn't result in any data. This is often caused by applying filters and/or selection steps t…
-
Custom sort OTBI ColumnI have a column in my otbi analysis. They return me the values Exceeds Performance Expectations, Inadequate, Meets Performance Expectations ,Nearly there, No PMS Rating.…
-
Add Segment Description to OTBI ReportSummary: We have a report that uses the subject area General Ledger - Journals Real Time subject area, and we want to add the segment description for our 5 segment. We k… -
Download the zip file (Authorized Hosted Named Users.zip) does not workSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Is it possible to generate a list of Oracle Fusion users and the method they use for authenticationSummary: Is it possible to generate a list of Oracle Fusion users and the method they use for authentication (SSO or Local authentication)? Content (required): Is there …
-
Setting Tab Names in Excel When Downloading an FRS ReportSummary Setting Tab Names in Excel When Downloading an FRS ReportContent I have 60+ Company (Balancing Segment) values. When I generate a report in FRS and then download…
-
How to include invoice attachments from UCM on bursted email outputI have created a custom email notification for invoices requiring receipts. I am using an RTF template for the email body and would like to include manually uploaded inv…
-
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Orac…
-
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe… -
Expression: Project Currency error when using dashboard prompt for project cross subject area real tSummary Error Codes: OAMP2OPY:G689FFB3:SDKE4UTF Expression: Project CurrencyContent wonder if anyone encountered the same issue when developing a new OTBI report using p… -
I cannot see bursting enabled in batch scheduler in FRSSummary: I cannot see bursting enabled in batch scheduler in FRS Content (required): I created a batch and added two reports. Next I created a batch scheduler and added …