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
-
Unable to select parameters in a Manage Job SetWe want to create the Job set and with job parameters itself so that every time we run the job set, we do not have to fill the parameters again. Can you tell us how we c… -
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…
-
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…
-
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… -
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 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… -
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…
-
Burst to multiple email addresses stored in a parameterSummary: Burst to multiple email addresses stored in a parameter Content (please ensure you mask any confidential information): I would like to have Bursting to multiple…
-
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …
-
Retired Assets in previous years should be part of Asset Register ReportSummary: Hello, one of our user raised concern regarding Asset Register Report that "all the assets that were retired last year still appear on the report. They do have …
-
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…
-
Missing Columns in BICC PVO but columns available in the underlying Oracle database tablesSummary: While analyzing the BICC Object Views for sending the data to Traget System—similar to the BIP extracts—for the following three Oracle tables, I noticed that so…
-
How to add page break in etext template (Fixed position based) in BIP reportHow to add page break in etext template (Fixed position based) in BIP report? Need to add page break after every 50 rows.