Category 129
Discussion List
-
Users with experience of using SQLConnect by BI SplashSummary: Users with experience of using SQLConnect by BI Splash Content (please ensure you mask any confidential information): We are reviewing the feasibility of granti… -
Is there anyway to extract Essbase cube data to connect with Powerbi beside smartview File?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BICC - Get Full Extract on every scheduled runSummary: BICC - Get Full Extract on every scheduled run Content (required): We have a requirement where we need to schedule a PVO on a daily basis. And the output of the…
-
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.6K views 62 comments 9 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
How to Create a Report for Approval/Reject Notifications in Fusion?Hi Everyone, We have a requirement to generate a report for all email notifications sent from Oracle Fusion for Approval or Rejection actions. The report should include …Mohini soni 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
We would like to understand the New Redwood features for Oracle FinancialsHi Team, Can someone please help us understand What are the new Redwood Oracle financial features? Is there any documentation or screenshots explaining the Finance upgra…
-
BICC Downloading Files from UCMSummary: We are investigating using BICC to schedule extract from Oracle ERP rather than relying upon our existing process of using Custom BI Publisher Reports then burs…
-
Delivery Filename in BIP Bursting definitionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Utkarsh_Upadhyay_HCG 13 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
FDI create a custom subject area using the PVO'sWe have a requirement to print the AP invoice attachment URL and the attachment file name in the FDI report. Currently ap invoice subject area don't have these attribute… -
Will Oracle Fusion Cloud BIP report Bursting supports Dot Matrix PrinterSummary: one of the report needs to be printed in Dot Matrix Printer. So, We need below information 1. Will Fusion BIP bursting supports Dot Matrix Printer? 2. If so, in…
-
What are the considerations of enabling and disabling the global "SQL Pruning" setting in BIP?A customer enabled the global SQL pruning setting in production which caused various BI publisher report issues (primarily, missing columns from various CSV and RTF outp…Harrison Jacob 12 views 0 comments 1 point Started by Harrison Jacob Reporting and Analytics for ERP
-
PVO BankAccountExtractPVO returns bank account data in OTBI - Issue SQL but no data via BICCNeed to identify missing privilege or profile. PVO FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountExtractPVO not returning data via BICC. In Fusion > Tools > Rep…Stéphane Lamy-Bouchard 31 views 2 comments 0 points Most recent by fusionenthu Reporting and Analytics for ERP
-
How to perform drill-down directly within an Oracle PBCS report?Hi, I’m working on Oracle PBCS in the Reports section and I was wondering if it’s possible — and if so, how — to enable drill-down functionality directly within a report…
-
OTBI function enablingHi Team When the user is working in OTBI (Subledger Accounting – Journals Real Time) and need to extract parts of the “Journal Line Description” field using pattern matc…
-
Is there a PVO (or combination of PVOs) that returns the accounting status of a Payables invoice?I need to return the accounting status (Accounted, Partially Accounted, Selected, Unaccounted) for a specific AP invoice but using PVOs. The column "ApInvoicesPostingSta…
-
How to count the number of pages per supplier in a report using RTF.Content (please ensure you mask any confidential information): I am creating reports using BIP (BI Publisher), and I use RTF templates for the layout. The report outputs…
-
Which table holds the error details for unsuccessful imports of Customer Credit hierarchy data?Summary: Hi Team, I am in the process of importing "Credit Hierarchy" data through "Import Management" (Object = Hierarchy & Hierarchy Member) and am working on a BIP re…Dhilip Kumar P. 2 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
How to build an Custom AP trial Balance report without having to use ap_trial_balances tableSummary: 1. We are trying to build a custom AP trial balance table which we will be sending to ARCS returning the output in a csv format, but without using the ap_trial_…
-
PO PDF Report Showing Truncated “Text to Supplier” – Full Attachment Name/Text Not Printing CompleteHi all, We’re facing an issue with the PO PDF report where the Text to Supplier (or text from the URL attachment) is not printing completely. When we open the attachment…
-
BICC mapping documentation for a specific PVO missingSummary: Hi, we are doing BICC extracts on every day basis. One of the PVOs we are extracting and which is working fine is: FscmTopModelAM.PrcPoPublicViewAM.GlobalPurcha…Frank.Steinjan 13 views 2 comments 0 points Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 540 views 8 comments 0 points Most recent by User_K7YG4 Reporting and Analytics for ERP -
AP_Invoices joins for Supplier Detail where vendor_id is negativeSummary: Sql question, I am looking for ap_invoices_all joins where vendor_id is negative, for the following scenarios; - expense (vendor id = -10016), one time supplier…Robert of STAU 806 views 9 comments 0 points Most recent by Adnan Saleem Reporting and Analytics for ERP
-
Default Multiple Value for Multiple Selection ParameterSummary: Is anyone know how to pass the multiple default value in multiple selection parameter. Content (please ensure you mask any confidential information): N/A Versio…Yeung Shing Keith 14 views 2 comments 0 points Most recent by Yeung Shing Keith Reporting and Analytics for ERP
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 21 views 2 comments 0 points Most recent by Palash Kumar Singh Reporting and Analytics for HCM
-
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 38 views 7 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
Query to get Oracle GL COA Entity Segment, Oracle Legal EIN/TIN ,Oracle Legal Entity NameSummary: Hi Everyone, I need query to create a BIP report which fetches the Oracle GL COA Entity Segment, Oracle Legal EIN/TIN , Oracle Legal Entity Name. Thanks in Adva…
-
Financial reporting studio books doesn't have an option to download in excelSummary: Any work around to this? Currently it allows only pdf and html. Users would like to download the whole book as an excel Content (please ensure you mask any conf…
-
BIP Based ESS Jobs Completed with Errors Post Environment RefreshSummary: BIP Based ESS Jobs (Seeded and Custom)are completing with errors immediately after submission following the recent Environment Refresh (Self Service) . Unable t…
-
Auto Refresh a BIP ReportSummary: How to refresh a BIP report after a certain period of time? Content (please ensure you mask any confidential information): HI, We want to show a report on a Dis…
-
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Orac…Noelle Bartlam-Oracle 33.7K views 93 comments 55 points Most recent by User_QY8JM Reporting and Analytics for ERP