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
-
Does OTBI report follow Data Security enabled for usersSummary: Does OTBI subject areas enforce the Data Security Context values that have been assigned to users. For example, a user has been assigned one BU and One ledger, … -
How to link "Corporate card transaction reversal" invoice lines from expenses to Company AccountSummary: I am attempting to create a BI report using SQL Query to report on the miscellaneous invoice lines, which are system generated from credit card expense reports …
-
Custom BI report for ESS job historySummary: Hello All, I would like to know if there is a way to create a custom BI report for monitoring ESS job submitted by specific users. I have the below tables, howe…
-
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…
-
Is there a size limit for email attachment for BI reports?Summary BIP - Report size is 15MB, job succeeds but never sends email.Content My report generates 15MB excel file but fails to email the report every time. I limited my …
-
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…
-
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…
-
Access BU in BIP based on UI RolesSummary: I have a client who has requested a specific functionality for displaying Business Unit (BU) names in the Business Intelligence Publisher (BIP) List of Values (…
-
Unable to join Invoice and Procurement Subject Area in OTBI AnalysisSummary I have a requirement to fetch the Purchase order details with corresponding invoice details. Therefore i need to connect two subject areas to fetch the required …
-
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…
-
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 … -
Define Hyperion Financial Management from Financials Setup and MaintenanceSummary: On selecting the Setup and Maintenance --> Financials --> Financial Reporting --> Define Hyperion Financial Management Configuration task I get the below messag…
-
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, … -
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 …
-
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 … -
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…
-
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…
-
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… -
Open FRS report using a URL link from BI Tile or similar?Summary: Fusion Financials: How to open a FRS report via a URL link from a BI reporting tile or similar? Content (required): Is there any way to open a FRS report via a …
-
Moved: How to link PL and RL rows when parent_je_header_id is not populatedThis discussion has been moved. -
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…
-
Outstanding Corporate Card Transaction ReportSummary Need to determine who has not processed card transactions through expenses.Content With the corporate card administrator role, we can see there is $xx amount of … -
Using Oracle Database Cloud Schema Service to access Oracle Fusion DatabaseSummary: Using Oracle Database Cloud Schema Service to access Oracle Fusion Database Content (required): in MOS article 1910762.1 it states "If the SaaS / Fusion service…
-
update on subtemplateSummary: 1- i update on Award Approval Notification Report. 2- has template AwardApprovalNotificationBodyReport.rtf. 3- in this template i have multiple subtemplate like…
-
BICC REST API to get last_extract_date of a PVOSummary: BICC REST API to get last_extract_date of a PVO Content (required): I am looking for BICC REST API to get last_extract_date of a PVO Version (include the versio…
-
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…
-
How to download SSH Private Key uploaded in Upload Center?Summary: We need to download the SSH Private Key which was uploaded in the Upload Center of BI Administration. How to download it? Content (required): We need to downloa…
-
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…