Category 129
Discussion List
-
Enable custom reports centrally for all Job managers in PPM manage project financial plan analyticsWe are new to Oracle.. How can i enable list of custom report for all users/ or job manager role in the PPM manage project financial plan analytics pop up tab on the rig…
-
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…Jason Madden 27 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 35 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 7 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 15 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 9 views 1 comment 0 points 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 26 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 21 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 99 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 98 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 28 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 26 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…
-
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.Harshitha S Motagi 33 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Comprehensive SQL to Retrieve Contracts with Lines, Fulfillment, Deliverables, Risks & Attached DocSummary: This post shares a comprehensive SQL query that retrieves detailed Contract information from Oracle Fusion ERP Cloud, especially for ECM_BUY contracts. It conso…
-
Regarding COA future1 segment name change impact on custom reportsSummary:Is there a specific option to find out what all custom reports are touching the chart of accounts Accounting Flexfield to analyze the impact of chart of account …Savita_1 8 views 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 2.3K views 58 comments 9 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP