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
-
How to add Reports and Analytics menu to Order Management Dashboard pageSummary: We have a requirement to add Reports and Analytics drop down menu with access to all reports on Order Management Home Page. Content (please ensure you mask any … -
China Localization - FinancialsHi All, Does Oracle Fusion Cloud supports Localization for China? Is there a standard document on this? What are various reports supported for China Localization for mee…
-
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your thoughts. Content (please ensure you mask any confidential i… -
Standard Memo Line Report - Revenue CodingSummary: I have a customer requirement to be able to export a list of all standard memo lines and their associated Revenue coding, required fields highlighted in .JPG. C…
-
ODI Marketplace integration with SharepointSummary: Team, do we have any possibility of connecting ODI with SharePoint for data exchange. Has anyone on the team encountered this need before? can you please share …
-
OTBI PO Balance Report to Tie to Budgetary Control Obligation BalancesSummary: I am attempting to build an OTBI report that will pull PO balances by PO that will ultimately tie to a cost centers obligation balance in Budgetary Control. We … -
showing a historical assignment as latest for some employeesSummary: We have an issue where the top (or Max) row is not returning the correct row! Instead of returning the current assignment, it is returning an old assignment for…
-
Run SOAP web service from bi publisher.Summary: Hi, please I would like help with the following: I try to setup a connection as web service: I define the datamodel to use this connection: Looks good! it seems…
-
How to create a new KPISummary: How to create a new KPI Content (please ensure you mask any confidential information): Hi Team, How to create a new KPI reports for Finance? Could anyone guide …
-
Load XML file into the dataset with xmlpserver/services or use BIP as print serverSummary: I am looking for a way to upload an XML file to a dataset that uses an XML file through the services offered by xmlpserver, but I can't find how to do it. I see…
-
IN OTBI How to display the data as per user preferred time zone and dynamically add GMT /- ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI IssueHi There is an existing OTBI report which attached below. Now the customer requirement is to add the below condition. But on adding this, the count is reducing. Please s…
-
I did customize a standard notification. But the change i did was not appreadSummary: PO notification Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any… -
Read-only Privileges for General Ledger TasksSummary: Kindly let us know if there are any read-only roles / view roles available for the following tasks: Financial reporting structure: Manage Chart of Account value…
-
Sql query issueHi All, We have a sql query. Now we have a requirement to add a condition so that employees with AEI_ATTRIBUTE4 from PER_ASSIGNMENT_EXTRA_INFO_M table is NULL, should sh…
-
Issue during passing a parameter to OTBI analysis in Page Composer doesn't workIssue during passing a parameter to OTBI analysis in Page Composer doesn't work Description : I am trying to do page customization using the page composer for the "BPA C…
-
"Check Digits" on a Supplier Bank Account Record in BIP SQL TABLE locationHi Guys Does anyone know please which BIP table contains the field "Check Digits" for a supplier bank account? I need to get the checkdigits field for a supplier bank ac…
-
Query to get Contract Financial SummarySummary: Dear All, I'm need a report that gets data from the following table in the Contract Financial Summary. What are the oracle tables or Views to get this data from… -
How to query the emirate in Customer Account Site addressHello, We are currently creating a Customer report, and we need to retrieve the Emirate under the Customer Account site address. From which table and what field can this…
-
In which Subject Area can I found the end date of an account.Hello, I am trying to bring the value of the End date of a GL account in an OTBI report . This value can be inputted in Manage chart of accounts value set values feature…
-
How to read a tab delimited data using querySummary: I have a text file which have data separated by tab. I need to split that into multiple columns. How i can write a query to achieve this. any idea please. Conte…
-
Populating xcc_balances table - requesting more informationSummary: Hello, Our BI report which shows the budget amounts for our accounts is missing a certain account for specific periods. It looks like the period names are missi…
-
Add "Cost Element Type" in OTBI Report "Costing - Period Inventory Valuarion Real Time" subject areaHi, I've created a report in OTBI to detail the On Hand valuation information. We are using the new subjet area "Costing - Period Inventory Valuation Real Time". We need…
-
XLAFSNAPRPT job nameHi, I need to find the job name (ex: for XLAFSNAPRPT, job name is Create Accounting). Is there any table that store this information or it is only MetaData (xml) ? Thank…
-
How to add 2 columns in group by in Excel templateSummary: Need to add 2 columns in Group by expression in EXCEL template Content (please ensure you mask any confidential information): below condition is working for 1 c…
-
FND_PURGE_RECENT_ITEMSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to create drill down charts in Oracle BI Publisher (BIP) Reports?Summary: How to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables? Content (please ensure …
-
Is it possible to store both US and Local Legal Entity Identifiers in Oracle?Summary: Our business team would like to know if it's possible to store multiple registration numbers for an Entity in Oracle. Content (please ensure you mask any confid… -
Performance considerations while doing Bulk Email BurstingSummary: At a time, need to send around 5K email notifications to supplier/supplier sites belongs to country . Content (please ensure you mask any confidential informati…
-
Redwood Impact for Oracle Cloud FinancialsWe have been working on the HCM side for the Redwood updates and wanted to confirm the impact that Redwood will have on the Oracle Cloud Finance side. Please let us know…