To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
ESS Print Job Queue - Oracle Fusion CloudSummary Accessing the ESS Print Job Queue from Oracle Fusion Cloud.Content Hi, As part of performance testing we ran Invoice Print Program for a wide range of dates, cus… -
Concatenating Values in a Database with 'for each' with a delimiterDear all, Is there a way to retrieve data using a 'for each' loop and insert a string between the values? For example: I have the following values in a database table: c… -
SmartView Duplicate name Error from sharded driveSummary: Smartview Spreadsheets are kept in a shared drive (OneDrive). After a hierarchy change (A single value added or moved)we continually see errors like : Essbase E…
-
Cannot connect to URL in FRS ReportSummary: Hello, When trying to edit my FRS report or even adding a member, like Aug-23 in the Accounting Period, the system gives me a white screen with an error of 'htt…
-
Why to use FRS or Narrative reports when we have OBTI and BIP toolsHello Oracle Gurus, When we have reporting tools such as OTBI and BIP, why is there a specific need to use Narrative reporting tool or FRS tool?
-
BI Publisher - How to generate the postal bar codeSummary BI Publisher - How to generate the postal bar code and standard payment barcode on billsContent I have a requirement to generate customer correspondence that inc… -
How to sort data in etext template using a hard coded fieldSummary: We have a requirement to sort data using a record type element. this element is custom and is the first column of the level and not present in the xml file. Ple… -
How do we configure DKIM for BI BurstingSummary: How do we get DKIM for BI Bursting when we can have multiple from email address based on business unit Content (required): When the emails are sent out to the c…
-
Is there a subject area for Chart of Accounts in OTBISummary: Is there a subject are for Chart of Accounts in OTBI? Content (required): Looking for a Chart of Accounts subject area so that I can build an OTBI report Versio…
-
Print Receivable Transaction - customizationSummary: Sending AR Invoice by E-mail to customer through bursting. Content (required): We need to send the AR invoice through E-mail for the particular customer by burs…
-
What is the OTBI export limit?Summary: What is the OTBI export limit? Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 23c Co…
-
Schedule Report > Dest FTP > Case When There is No Data > Ability to Not Generate Output FileSummary: BIP Report > Schedule Report > Destination FTP > Case When There is No Data > Ability to Not Generate Output File Content (please ensure you mask any confidenti…
-
How to extend timeout to more than 18000 seconds?Hi All, When I run a customer report with huge data, the scheduled report shows failed with exceeds 18000 seconds. The timeout setting in data model properties has a lim…
-
Moved: How to extract data from xmltype column using bip reportThis discussion has been moved. -
What type of delimiter can we use for AFF segment in Oracle Fusion Cloud ERP?Summary: Could you please provide the delimiter's value that we can set for AFF? I think that they are below, based on the screen of 23C. !, *, +, -, ., :, =, ^, |, ~ A…
-
Issue with migration of DashboardHi, User has migrated their own dashboard from their own folder to custom folder. Only the person who has developed is able to access but it is throwing error for others… -
Is there any alternative if table is not available for BICC extractionHi, I was working to do an extraction using BICC and not able to get the PVO for some tables like: RCV_SUPPLY, WSH_FREIGHT_COST_TYPES etc. Is there any work around avail…
-
Moved: HFRS - How to generate Date Format for a report Dimension - Accounting Period on report Head…This discussion has been moved. -
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
Moved: How do I keep a table with repeating elements from breaking across multiple pages?This discussion has been moved.
-
how do you change ERP Cloud quarterly patches coWe are currently in Cohort B for current release management patches and want to know how we can change to a different cohort
-
Custom Purchase Order template works fine when PO is in Draft status but does not work when PO movesSummary Custom Purchase Order template works fine when PO is in Draft status but does not work when PO moves to Open statusContent Hi, The Custom PO template works as ex… -
Hot to fetch bursting delivery notification detailsSummary: Looking for a query or table which would fetch bursting delivery notification details. Content (please ensure you mask any confidential information): We have a …
-
How do you update Remaining Life with an effective date?Summary: How do you update Remaining Life with an effective date? When we update the Remaining Life then run calculate depreciation, we want that calculated based on an …
-
query to get ap accounted invoices.Content i need a query to get ap accounted invoices.
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
Moved: Reporting Capability Maturity Matrix : Reporting Road MapThis discussion has been moved.
-
Table details for ESS Job Display NameSummary: Hi, Can you please suggest which table holds the ESS Job Display Name? I have tried few tables like: request_history_view, ess_request_property but not able to …
-
In our FRS Reports, the Description does not work unless you put first few charactersSummary: In our FRS Reports, the Description does not work unless you put first few characters that is you can’t search with string starting with asterisk, but for Name …
-
Report to Monitor User ActivitySummary: Hi All, We have a ask from the customer where in if a collection rep logs in and works an 8 hour shift, manager would like to pull a report to see how many tran…