Category 129
Discussion List
-
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 811 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 11 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 43 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 31 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…
-
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 11 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 11 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 671 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 11 views 0 comments 0 points Started by CS Yuen-Oracle Reporting and Analytics for ERP
-
Financial Reporting Studio Issue: 2025 Data Not Appearing CorrectlyDear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2025 data in our reports. Problem Description: Whe…Patrick Chrabieh 57 views 6 comments 0 points Most recent by user10987169 Reporting and Analytics for ERP -
how to create subtotals in excell template for bipI had a requirement to create subtotals for each individual invoice_numbers , when i try to do sum function or subtotal selection it is not giving subtotal for each indi…Voladri Saikiran 25 views 0 comments 0 points Started by Voladri Saikiran Reporting and Analytics for ERP
-
issue with the link between gl_code_combinations and ZX_ACCOUNTSSummary: I am creating a report to gather the taxes and all invoices related to this tax. Content (please ensure you mask any confidential information): I used the below…
-
How to create Custom ESS Job for a Schedule integration from FusionI am trying to create a Custom ESS job in Oracle fusion by creating report for a schedule integration. But not able trigger the integration with the Report. Please let m…Harsha Karanam 11 views 0 comments 0 points Started by Harsha Karanam Reporting and Analytics for ERP
-
Highlight Duplicate String ValuesSummary: Content (please ensure you mask any confidential information): In an OTBI analysis, I would like to highlight duplicate string values. Is this possible? We're u…
-
Disability CategorySummary: We are building a report that displays a summary of Disability Categories Specifically the "Workforce Management - Person Real Time" subject area - Person Disab…Mark_R 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
What table contains the AP invoice source distribution transaction line number details?I'm trying to build a BIP report that contains the AP invoice source distribution transaction line number details, as shown in the screenshot below. What BIP table conta…
-
How to add Year to date activity in financial reportSummary: We are creating a financial report where we want to include current period activity and year to date (accumulated activity). How do you suggest that we include …
-
BIP検索条件についてSummary: Could you please tell me how to specify multiple search conditions for BIP? Content (please ensure you mask any confidential information): In the search screen …
-
Need Cleared check report in Oracle fusion without reconciliation processSummary: Hi, The business is using check payment method and issuing checks and they are using cash account when they issue payments. So there is no reconciliation proces…
-
Purge User RequestsSummary: Purge User Requests Content (please ensure you mask any confidential information): There is a way to purge a specific request? I'd like to purge some requests f…Luca Nobili PWC 38 views 3 comments 0 points Most recent by Luca Nobili PWC Reporting and Analytics for ERP
-
Invoice Payments querySummary: Create New Invoice Payments Reports Content (please ensure you mask any confidential information):I would like to create a new report in Oracle Fusion ERP to qu…
-
Control report-level permissions during migrationSummary: We have a custom folder ("Folder A") with 4 roles assigned: Role A, Role B, Role C, and Role D. When a new report is migrated into this folder, it automatically…