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 sum a variable in XSL template?Summary: I'm unable to a sum a variable data in XSL template. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code… -
Existing HFRS report built on tree needs to be compared with control budget that doesn't have a treeSummary: Content (required): Hello Aim - To have a report that can be used to compare actual and control budget data. The below points describes the issue that we are cu… -
How to Create Alias TableSummary: Hello, I have requirement to create FRS reports for multi-language reports in oracle cloud and need help to create Alias Tables as this is required to fulfill t…
-
Essbase error (1020032): Data item found before member errorSummary: Getting below error in SmartView while connected to GL Essbase Cube: Essbase error (1020032): Data item found before member error Content (required): Version (i…
-
Copying personal custom Dashboard to Shared Folder > Custom > Dashboards throws Error Codes: QM3V3HSummary: Moving a personal dashboard to shared folder throws error Content (required): User has a custom Dashboard created in My Folder >Dashboards They want other users…
-
In an ERP only implementation, no HCM, how can we handle multiple assignment in autoprovisioning?Summary: In an ERP only implementation, no HCM, how to handle multiple assignment in autoprovisioning? Content (required): We are not using HCM Cloud, has anyone have a … -
How quickly does Oracle make updates to federal reports?Summary: When the federal government makes changes to a federal form, such as the Federal Financial Report (FFR), how quickly does Oracle make this change to the report …
-
How can we call a BI report through REST APIs?Hi, We need to call a custom BI report, through API. Can you please provide us an example of how to have/prepare the report path? And how the whole URL should be like? K… -
What are the steps to enable & implement SAML authentication in Oracle fusion & also at client sideSummary: We are using SOAP APIs host://idcws/GenericSoapPort operations - GET_FILE, GET_SEARCH_RESULTS, UPDATE_DOCINFO for consuming data from UCM that is extracted via … -
Need help on calculating Hash Total for National Bank of Kuwait EFT templateSummary: is there any ready to use code to calculate hash total logic in oracle etext template to make a payment to National Bank of Kuwait Content (required): Hash tota…
-
Moved: How to link PL and RL rows when parent_je_header_id is not populatedThis discussion has been moved. -
Are there downloadable dashboards for Financials modules?Summary: I am looking for downloadable dashboards like the ones created by Caroline Gladwin (please refer to link: OTBI Sample Dashboards - 1. How to Install and Configu…
-
Extend SQL Query Timeout Interval for BIP Data ModelsSummary: Extend SQL Query Timeout Interval for BIP Data Models Content (required): We would like to understand if the "Server Value" for "SQL Query Timeout" parameter ma…
-
What is Oracle Fusion alternative for rowset and columnset used with FSG reports in Oracle EBS?Summary: In Oracle EBS, FSG Reports maintenance was quite simple. We used to maintain rowset and column sets. We can combine any rowset and columnset to form a FSG repor…
-
Any benefits to benchmarking Fusion processes and activities?Summary: We are considering a benchmarking activity across our systems, although with Fusion being a cloud product the benefits of such an activities are uncertain - oth… -
How to move up one node in my xmlSummary: Getting data from one node up of xml Content (required): I have a template that gets the data from node . I need to also display columns from which is one leve…
-
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, … -
Need a query to get the project actual cost ,committed cost and actual revenue of the project (PPM)Summary: we are developing a BIP report which gives project-wise budget details and actual cost and revenue details. we were able to get the project budget cost and budg…
-
SQL query to generate Fiscal Classification Code on customer profile & site levelSummary: Need help in determining SQL query to retrieve fiscal classifcation code from customer profile & site level. Content (required): Hi all, What SQL query should I…
-
Tables not available for BICCC extraction - what is the alternative?Summary: While configuring data extract from BICCC, we notice that within a data store many tables do not have equivalent PVO. Below are few examples where I could not f…
-
Out of the box reports in Oracle Cloud ERP with samplesSummary: I'm aware of the seeded reports that come out of the box in Cloud ERP with some samples included in it. There was an Oracle Support note or something similar bu…
-
Data modelling in OTBI?Summary: Hi In Payables (and therefore also in the Procurement subject areas such as Procurement - Spend Real Time) it sometimes happens, that an invoice is matched with…
-
How to send the BIP Report Output to Customer without Scheduling Cloud BIP ReportWe need to send BIP Report output to a mail id which is passed as parameter. We have enabled the Bursting it is working. But customer is not accepting to schedule the Re…
-
Does the FND_TREE_LOG and FND_TREE_LOG_PARAMS table purge over time?Summary: Could you please confirm if Oracle purges data from FND_TREE_LOG and FND_TREE_LOG_PARAMS tables over time? If yes, then what is the frequency, and is there a se…
-
How to rollup the quarterly data in SmartView ?Summary: The QTD column is not fetching data in SmartView ad-hoc analysis. What is the procedure to enable quarterly roll-up? Content (required): We have created an Inco…
-
Unable to Use the Manage link on the Home page to add reports to favoritesSummary: Unable to Use the Manage link on the Home page to add reports. Content (required): Version (include the version you are using, if applicable): Code Snippet (add…
-
Having issues with BI Report. Wont pass multiple selections on ParametersSummary: I have the following attached report where when attempting to select multiple parameters such as Expense Status or departments I encounter the ORA-00909 error. … -
OTBI login based data will display but user id not matchedSummary: OTBI dash board /analysis based on login user name data will display if user name/display name not matched still they want data using custom session variable to…
-
Calling runReport in xmlpserver/services/v2/ReportService Webservice with SSO enabled user(Azure AD)Summary: Hi All, I am working on calling a BI Publisher report from a custom application using xmlpserver/services/v2/ReportService webservice. The requirement is to use…
-
Can we control access of custom objects based on custom roles in Fusion ERP?Summary: Can we control access to custom objects based on custom roles? Can we customize our own roles for user access or for the security purpose Content (required): Ve…