BI Publisher
Discussion List
-
Table to get Task Details from Strategy assigned to customerSummary Table to get Task Details from Strategy assigned to customerContent Hello, We are unable to find the table to get Task Details from Strategy assigned to customer…Vinay Gharge 83 views 2 comments 0 points Most recent by Praveen Gollu-Oracle Reporting and Analytics for ERP -
็How to custom Trial Balance ReportSummary: How to custom Trial Balance Report by adding Filter Conditions accounting segment in Trial Balance Report Content (please ensure you mask any confidential infor…
-
Unable to generate consolidated output for Create Customer Statement Report.Summary: We have a requirement to customize and enable consolidated output for Create Customer Statement Report. Although we have activated the feature to display consol…
-
GL_FRC_REPORTS_B and Custom Folder and Report ListSummary GL_FRC_REPORTS_B is not listing all the reports that are created or modified; Should we run a process to populate the table or does the data in the table gets po…
-
Automating BI Catalog archivingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…G8rNtn 21 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to submit BIP Report in oracle fusion with soap webserviceSummary: How to submit BIP report in fusion with soap Webservice https:///xmlpserver/services/ExternalReportWSSService In this soap webservice need sample payload forsub…Srinivas B 87 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Ljava.lang.Object; is passed when multiple values are seleted in parameter in oracle BIP reportSummary: Hi Everyone, We have created a custom BIP report that will trigger the OIC integration from the Data model. We are passing a few parameters to the report. One o…
-
BI Publisher report parameters do not workSummary: Requisition Header Description based parameter is not working Content (please ensure you mask any confidential information): I have created a BIP report for Req…
-
Embedding Dashboard onto Tile - Application Role list incompleteSummary: Hi all, I am embedding some BIP reports onto tiles and have a couple of questions regarding the application roles in this step - This list is incomplete e.g. Ac…Ian.Gooderham 13 views 1 comment 1 point Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
How to correctly add the Bad bedt attribut to the report data model querySELECT hp.PARTY_NAME AS "Customer_name", rcta.TRX_DATE AS "TRANSACTION_Date", rcta.TRX_NUMBER AS "TRANSACTION_NB", fabuv.BU_NAME AS "Business_unit", rcta.INTERFACE_HEADE…Omran Zeaiter 12 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Dunning Letter Format in Peppel 3.0 FormatHi, We have new requirement for our client need to send Dunning Letters in Peppel 3.0 Format. Can you please let us know do we have Oracle standard functionality dunning…
-
24C New BIP report Journal and Transaction Details Report not availableSummary: In the 24C there is a new BIP report 'Journal and Transaction Details Report'. We are now looking at all the new futures in our dedicated demo environment. We d…AnnelizeHenskens 70 views 1 comment 0 points Most recent by CristinaV1-Oracle General Ledger & Intercompany
-
How to create data control name while registering ESS jobHi, We have requirement to modify default parameters of the seeded ESS Job. Parameters controls by the "Data Control Name" . Is there any feasibility to create a new "da…VNMA 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
BIP Local Solutions reports do not print Natural Account descriptions in selected local languageSummary: Predefined Latin America Local Cloud Solution (LALCS) BIP reports do not print Natural Account Descriptions in translated language - Spanish. Content (please en… -
How to configure an additional Input parameter in Account Analysis Report XLAAARPTHello, We have a requirement to add additional department type Input parameter as a filter in BI Account Analysis Report XLAAARPT. This report is being run through the E…
-
Display days of a week in order using rtf templateI have a rtf template which is using days of week to display receipt totals for each day for different entities I am using pivot table to display data weekday vs entity …Ninad Joshi 12 views 1 comment 1 point Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Approval History - AP Invoice Account Coding Workflow Notification CustomizationSummary: We need to customize "AP Invoice Account Coding Workflow Notification" to display approval history using SQL Query. In BPM Workflow notification we can see the …Surya Chandaka 43 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
In Event Triggers: Alternative solution for passing multiple values into a single parameterIn event triggers, I need to pass a multiple values to a single parameter and upon research I realized that oracle does not provide such feature. I need a alternative so…navya Nallamotu 13 views 0 comments 0 points Started by navya Nallamotu Reporting and Analytics for ERP
-
Fixed Asset Register report is not working when you select a date in the past like OCT 2023.Summary: Fixed Asset Register report is not working when you select a date in the past like OCT 2023. it only returns the current Open period after running depreciation.…
-
Budget Transactions - Original Estimate / Revised Estimate - where are the tables??Summary: I am looking for the Oracle transactional tables that are posted to when creating budgets (not control budgets but 'reporting' budgets and not balances but tran…Robert of STAU 22 views 4 comments 0 points Most recent by Robert of STAU General Ledger & Intercompany
-
Get Recipients from the Analysis as Task Owners from Project Subject AreaSummary: Cannot set dynamic recipients of an email with analysis. The standard functionality should be available using an Agent. The agent was setup for an analysis done…Dejan Begovic 1 view 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS are interiam tablesSummary: AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS are interiam tables. Content (please ensure you mask any confidential information): We are looking actual ba…
-
Need Outstanding Check Report in Oracle fusionSummary: Hello, We are looking for a report that shows payments that were issued but have not cleared the bank account yet. Is there any report already available in Orac…
-
Issue Number formating causing reporting issuesDear All, The format of numbers in the purchase order standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the da…George Mattar 32 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
how to exclude not applicable journey tasksHow would we exclude tasks that have been 'Marked not applicable'? I seartched the PER_ALLOCATED_TASKS and PER_ALLOCATED_CHECKLIST tables and could not find the field th…
-
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… -
YTD balance (ending balance) for each source, category and accountHi, We have a requirement to develop a BI report to fetch YTD balance for each source & category. In this case , I cannot retrieve YTD balance from the gl_balances as th…
-
Audit Report for Oracle backup Log in Oracle fusionSummary: Hello, We are looking for report where the Oracle system backs up all data, libraries, applications, and user profiles daily/on a regular basis. Is there any re…
-
Reconciliation Report using Supporting Reference segmentsWe have a reporting requirement to track a transaction (together with natural account) from GL to subledgers. A DFF is created at Journal header level to capture 'Transa…Kalyani-Oracle 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Pivot using Mulitiple groupsSummary: I have a requirement to have supplier response and prices details based on the items. Suppliers, Response and its prices should be in Pivot format. We are unabl…