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
-
Looking for PO Receipt Number and related data in OTBISummary Cannot find PO Receipt Number, Receipt Date and related date in OTBI Subject Area: Procurement: Procure to Pay Real TimeContent Cannot find PO Receipt Number, Re… -
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.
-
Audit tables for Project Tasks and Sub Tasks in Oracle fusion cloud and policies to enableHi, Are there any Audit tables for Project Tasks and Sub Tasks related in Oracle fusion cloud to create a BI publisher report? I was able to enable the audit policies fo…
-
Unable to find error details in interface table GL_SEGMENT_VALUES_INTERFACESummary: Hi Experts, Could anyone please provide the details for 'GL_SEGMENT_VALUES_INTERFACE' table. The import program 'Import Segment Values and Hierarchies' getting …
-
Online Excel preview to view BIP report outputs instead of downloading the file?When getting a BIP Report output in Excel format, is it possible to preview it online (as in cases with PDF/CSV outputs) rather than having it downloaded to system and o…
-
BIP検索条件についてSummary: Could you please tell me how to specify multiple search conditions for BIP? Content (please ensure you mask any confidential information): In the search screen …
-
How i could find KB29474Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
SQL for all roles and it's inherited roles for BIP.Summary: Hi, I have a requirement to create a BIP report to fetch the details of all Roles and its inherited roles. I have seen that it can be achieved by OTBI but can't…
-
-
Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…
-
Table details for ESS_REQUEST_HISTORY and ESS_REQUEST_PROPERTYHi, Are ESS_REQUEST_HISTORY and ESS_REQUEST_PROPERTY database views? If yes then what are the tables using which these views are created or where can we find query of th… -
Change database timezone?Hello Gurus, I understand that data in Oracle Fusion tables are being stored in UTC timezone. Can that be updated to timezone per Organization's choice? If yes what can …
-
Is there functionality to leverage Data Access Sets for BIP reportsHello, Does anyone have any feedback on how to secure BIP reports via Data Access Sets? We are trying to split out security roles so that International crew only see the…
-
Which subject area can I use for procurement contract agreement deliverablesSummary: Which subject area can I use for procurement contract agreement deliverables? Content (please ensure you mask any confidential information): Version (include th…
-
Multi Language in Single BI Publisher ReportHello Community, We are having a requirement to Generate Invoice Report such that for certain Provinces the report should show the invoice in two languages in single fil…
-
Procure to Pay DashboardsSummary: Procure to Pay Dashboards Content (required): How can these be added to the home dashboard once the user is login, instead of going to reports and analytics and…
-
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…
-
how to pull data from FCCS into Analytics and combine with Fusion Cloud ERP data (Finance)Summary: We would like to have some ideas about how to extract data from FCCS in reports in Analytics and combine with Fusion Cloud ERP data (Finance) Content (please en… -
Issue Using Two Subject Areas in a Single OTBI Analysis to Bring Budget and End Of The Day Balance.We are trying to build an OTBI analysis that contains Ending balances and End Of The Balance(EOD) related transactions within a period. To achieve this, we are using two…
-
Dynamic Deep Link URL in BI Publisher Report not workingSummary: I have a RTF template that shows details of AR Invoices. I have inserted a link on Invoice Number to take the user to the transaction in the application using D… -
Export and import of 'Participants' and 'Rules' configured in the BPM WorklistSummary: Export and import of 'Participants' and 'Rules' configured in the BPM Worklist Content (please ensure you mask any confidential information): Is it possible to …
-
Is there any standard checklist or set of best practices to follow after a P2T process?Dear all, Following the completion of a P2T process (data migration from Production to Test), I would like to inquire whether there is a standardized checklist or a set …
-
Query for Transaction Console transactionsSummary: Query for Transaction Console transactions Content (required): I am looking to write a query that contains the below information from the Transaction Console, r…
-
Impact of import oracle fusion data extensions for transactional business intelligenceSummary: Hi, Please help us to understand if the program - Import oracle fusion data extensions for transactional business intelligence will impact in any of the current…
-
SoX BI report for Role and ESS changesHi All, As part of SoX auditing, we are looking for lookback BI reports to identify Role and ESS changes as we find from our analysis that the Audit reports available ou…
-
pasteItem2Summary: Which value of flagACL I should use to correspond to the ACL option 'Create'? Content (please ensure you mask any confidential information): Unarchive the BIP c…
-
Date format in parameter display as DD/MM/YYYYSummary: User want date parameter supports either input manually DD/MM/YYYY or select from calendar. Currently it display as MM-DD-YYYY and cannot change the format, whi…
-
need to fetch the timestamp when Invoice status changes to Approved at summary levelSummary: for every invoice, when clicked on 'Validate' it will kick a process in the backend "Validate Invoices" which will change the status of Invoice to Validated nee…
-
Oracle BICC which PVO can be used ?Summary: In Rel13_25C_BICC_FSCM_Database_Mapping_with_ViewObjects there are GL PVO not described in 'Extract Data Stores for Financials' (https://docs.oracle.com/en/clou… -
Need sample query to get Original transaction number from credit memosSummary: Need sample query to get Original transaction number from credit memos Content (please ensure you mask any confidential information): need to know about the bac…