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
-
Performance of BI GL balances querySummary Performance of BI GL balances queryContent The Attached BI query timesout when executed with just the tree values. I have passed nulls for the remaining levels c…saravana maneeian subhramaniun 62 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI -
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…
-
Practice QuestionsSummary Practice Questions
-
OTBI dashboard operators link to BI publisherSummary Can we use OTBI dashboard operators in BI Publisher sqlContent We are embedding SQL query based BI publisher report in OTBI dashboard. The OTBI dashboard has an …
-
Find parent value in CoA hierarchy for balancing segment in OTBIContent As an investment fund manager , my company closes the periods per FUND which is defined in the hierarchy of the Balancing Segment Chart of Accounts. As per Oracl… -
ERP – Procure to Pay Enterprise Structures Best Implementation Practices, 10 June 2020, 9 a.m. PT -Content Submit your questions for the ERP – Procure to Pay Enterprise Structures Best Implementation Practices session to have them answered during the live event. Post …
-
ERP – BI Publisher: How to configure XSL and RTF templates, 9 June 2020, 9 a.m. PT - Submit QuestionContent Submit your questions for the ERP – BI Publisher: How to configure XSL and RTF templates session to have them answered during the live event. Post your questions…
-
Fixed Assets - Asset Balances Real TimeSummary Assets OTBI Report for CIP not showing balancesContent Hi FA Experts, We built an OTBI report with Fixed Assets - Balances Real Time Subject area to display bala…
-
OTBI Report how to only have the last valueSummary I have a report for asset that have cost and Net book value, but i have all the different net book value instead of only having the last net book valueContent He… -
Electronic Purchase Order Submission ReportSummary Purchase Order submitted ElectronicallyContent hi Guys, I am creating a report for Purchase Order submitted Electronically. How do I identify PO is submitted ele…
-
Standard report shortcut icon by name on dashboardSummary Seeded Report icons by namesContent There are multiple reports in the Report and analytics Based on client need can we make shortcuts of reports as icon on the d… -
Stop Email Bursting on Lower EnvironmentsSummary Prevent Seeded Process to Send EmailsContent Hi Experts, Need Help!! Recently we had got Production environment cloned to Test, so the data was also occupied, Th…
-
Difference between data in Essbase Cube and Fusion Transactional dataSummary Trying to illustrate the difference between what data is stored in the Financial Essbase Cube and what is in the Fusion transaction database.Content Hello Everyo… -
Enable All or Multiple selections from a Pivot Table prompt in OTBISummary The Pivot Table prompt should allow the selection of all or multiple items.Content We have a requirement to allow the selection of All or multiple items from the…
-
Attach Custom List of Value to ESS JobSummary Custom List of Value to ESS JobContent Hi Experts, I have two questions pertaining to ESS jobs and are as follows:- 1) How can I attach a custom list of value to…
-
Dynamic headings in columns when using relative promptsSummary Would like to be able to change the heading dynamically to proper formatting for our business, without hardcoding. We are using relative to prompt for accounting…
-
ERP – BI Publisher Introduction: How to configure EFT templates, 3 June 2020, 9 a.m PT - Submit QuesContent Submit your questions for the ERP – BI Publisher Introduction: How to configure EFT templates session to have them answered during the live event. Post your ques…
-
Tables for Documents Attached to a ProjectSummary Tables for Documents Attached to a ProjectContent I am trying to create a custom data model to include document attachments in Manage Financial Project Settings … -
Invoice AttachmentContent Hi, When I have three instalment and when I click View Image from Invoice screen and it would print PDF with three pages which is seeded functionality. The templ… -
MANAGE PERSONALLY IDENTIFIABLE INFORMATION IN FINANCIALSSummary MANAGE PERSONALLY IDENTIFIABLE INFORMATION IN FINANCIALSContent Hi All, There is a mandatory feature of 19C i.e. Manage Personally Identifiable Information in Fi…
-
Does Oracle provide seeded test scenarios / scripts for the various Oracle Cloud modules?Summary Does Oracle provide seeded test scenarios / scripts for the various Oracle Cloud modules?Content If so, how would you get access to them please ?
-
Sample SOAP request payload for OTBI Analysis extractSummary Sample SOAP request payload for OTBI Analysis extract using variables or filter criteriaContent I have an OTBI analysis based on the "Procurement - Purchasing Re…
-
Anyone has query to link PPM projects with GL in fusion?Summary Anyone has query to link PPM projects with GL in fusion?Content Anyone has query to link PPM projects with GL in fusion?Pradvin Heggar Prabhakar-147626 110 views 0 comments 0 points Most recent by Pradvin Heggar Prabhakar-147626
-
Anyone has query to link PPM projects with GL in fusion?Summary Anyone has query to link PPM projects with GL in fusion?Content Anyone has query to link PPM projects with GL in fusion?
-
Replace Dynamic SQL with Explicit SQL notificationSummary Notification received from OracleContent Hi There, Since yesterday we have received many notifications stating "Replace BI Publisher Dynamic SQL with Explicit SQ…
-
Viewing pending scheduled reportSummary How to view the schedule details for a scheduled reportContent Followed steps from other posts to search in the "hierarchy" view of scheduled processes. I do not…
-
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…
-
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 …
-
Unable to view audit data in _ tablesSummary Unable to view audit data in _ tablesContent Hi All I have enabled audit for user roles and able to view the data from Tools -> Audit reports. I want to extract … -
What is the obj Type and obj key and Action to achieve drill down to 'Manage Project Page' from theSummary What is the obj Type and obj key and Action to achieve drill down to 'Manage Project Page' from the OTBI report.Content Hello Experts, I have followed https://ww…