Category 129
Discussion List
-
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 33 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… -
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 16 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 543 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 817 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 27 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.8K views 93 comments 55 points Most recent by User_QY8JM Reporting and Analytics for ERP -
Are XPath functions fn:tokenize, fn:matches, and fn:replace are not supported by Oraclee?Summary: Hi, I am new to XSLT development, As part for customer requirement I have used tokenize function for looping. But PPR formatting is failing because of this. Err…Tejeswar J E 9 views 3 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Purchase Order PDF report issueHi Team, We have customization in Purchase Order PDF report by adding customer logo and also setup the confirmation in configure procurement Functional business unit tas…Chanikya Neelam-Oracle 15 views 6 comments 0 points Most recent by Chanikya Neelam-Oracle Reporting and Analytics for ERP -
Configure audit rule in oracle expense 1. all cash expenses to be audited 2. personal expense on CCSummary: Configure audit rule in oracle expense with following condition- 1. all cash expenses to be audited 2. all personal expenses on Credit card to be audited 3. the… -
For the customized Print receivable transaction report, the ess job fails with errorSummary: As part of the Run , our Print Receivable Transaction Report job is failing and the ESS log message provides us the below error message AR_ESS_PLSQL_WRAPPER_PKG… -
Project Comments in query output FormattingSummary: User created a comment on Project level (might have been copy pasted from some other source), when a sql is written to extract the information, it has all sorts… -
Is there any row level security delivered with BICC?Hello, We need to extract data for our local BI. We are on a Single International Instance, and we want to extract only our data. Is there a way (through security, or pe… -
How can I edit parameter in standard ESS job?Summary: I want to edit (hide/remove/default to a specific value) the parameters of a standard ESS job. Please share steps to do it Content (required): Version (include …Priyal Pareek 638 views 3 comments 0 points Most recent by Sameer_Jain Reporting and Analytics for ERP -
Common Dimensions between Subject Areas in OTBIanyone has a list of Common Dimensions between Subject Areas in OTBI? at least 2 or 3 different Subject Areas? -
Difference between Enabled for UI and Enabled for All of Smartview WebView2 RuntimeSummary: Customer uses both on-premise hyperion and Oracle Fusion ERP Cloud applications (Not user of EPM cloud). In hyperion, they faced an issue before, so the reply f…CS Yuen-Oracle 18 views 0 comments 0 points Started by CS Yuen-Oracle Reporting and Analytics for ERP