Category 129
Discussion List
-
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…sarathkumarkondadadi 26 views 0 comments 1 point Started by sarathkumarkondadadi Reporting and Analytics for ERP -
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 …Sai Krishna Chelikani 11 views 0 comments 0 points Started by Sai Krishna Chelikani Reporting and Analytics for ERP -
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…PrerakKhandelwal 31 views 0 comments 1 point Started by PrerakKhandelwal Reporting and Analytics for ERP -
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…Sameer Khan 29 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
OTBI 条件分岐Summary: I want to implement conditional branching in OTBI. What operations are required to achieve this? Content (please ensure you mask any confidential information): … -
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…Jason Madden 33 views 7 comments 1 point Most recent by Jason Madden Reporting and Analytics for ERP -
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…Cindi Jacobsen 32 views 4 comments 0 points Most recent by Yahya Khan Reporting and Analytics for ERP -
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…Sreedhar Elagandula 12 views 2 comments 0 points Most recent by Sreedhar Elagandula Reporting and Analytics for ERP -
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…Hans Krogstie 17 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Need the joining table for Manage contract types columns buyer role and seller roleSummary: I need the joining for OKC_CONTRACT_TYPE_PARTIES for buyer role and seller role as I am getting whole data for the roles but I need to get only buyer and seller… -
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 …Jefferson Teixeira 12 views 1 comment 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
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…SwapnilSurange1 34 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
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…Sam Mathews-81448 24 views 3 comments 0 points Most recent by Sam Mathews-81448 Reporting and Analytics for ERP -
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…Gary Wan Guanghui 22 views 1 comment 0 points Most recent by Gary Wan Guanghui Reporting and Analytics for ERP -
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…Anjali Sidharthan 11 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
Need to know the Accounting Status identifier from Projects expenditure/costing tablesSummary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. For this request we need to know … -
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… -
What is the subject area of Project Definition DFF on OTBI on Projects module?Summary: We cannot find Project Definition DFF on OTBI. What is the subject area of this attribute on Projects module. DFF is BI enabled, we run "Import Oracle Fusion Da… -
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…MayuriMMote 174 views 3 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Reporting and Analytics for ERP -
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 …SireeshaJaladi 106 views 6 comments 1 point Most recent by Sri Prasanth Reporting and Analytics for ERP -
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 … -
Report Output data getting spit in two rows in excel file due to line breakageSummary: We have an OTBI report based on an Analysis where the Data Model is also using Analysis. In the data, there are line breaks within certain fields. When exportin…Nikhil Kubba 60 views 3 comments 0 points Most recent by Nikhil Kubba Reporting and Analytics for ERP -
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…Anshul Bansal 36 views 1 comment 0 points Most recent by Sai Revanth Reporting and Analytics for ERP -
Need to see supplier full account numberSummary: Is there any standard report in oracle we can leverage to see the full account number of Supplier. Could you please confirm? Content (please ensure you mask any…