Category 129
Discussion List
-
How to duplicate a DashboardI need to duplicate and modify an out of the box dashboard: CIP Account Analysis. How do I duplicate it and save it, when I try to do so, I am unable to edit components.erpexpert03 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Period Name parameterSummary: Hi , I am currently working on report which is filters using period_name. when i select single month(period_name), the data looks promising. when multiple perio…Praveen_Chouhan 91 views 3 comments 0 points Most recent by Rich Merkel 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…
-
Deeplink for AR_TRANSACTION in REVIEW modeSummary: Need to view a transaction detail in Review mode Content (please ensure you mask any confidential information): Hi everyone, I noticed that when I open a comple…
-
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 11 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 11 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…Koteshwar Tippani 81 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
Is there any report to fetch either approved or approved invoices but not bothSummary: I need to know whether report or from front end to fetch the details of invoice status whether approved or not without giving AP inquiry role to all the clients…Sri Pallavi 1 view 1 comment 1 point Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
How can I find AP invoices Approvals by user and approval group details in Fusion cloud?Summary: To identify the Invoice is approved user or approval group and which Rules hitting by the BPM Content (please ensure you mask any confidential information): To …Harish Pati 443 views 2 comments 0 points Most recent by Harshali Shirgannavar-Support-Oracle Payables, Payments & Cash Management
-
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 81 views 1 comment 0 points Most recent by CristinaV1-Oracle General Ledger & Intercompany -
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…NancyR_Bravo 2 views 2 comments 0 points Most recent by NancyR_Bravo Reporting and Analytics for ERP -
Otbi analysis filter for budget date greater than creation dateSummary: We are looking for advice on the most effective way to set up an analysis that lists all requisitions that have a budget date of more than 30 days from their cr…
-
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…
-
How to schedule an OTBI report to generate monthly with dynamic prompt?Summary: We have an OTBI report that contains a datetime prompt. I'd like to schedule the OTBI report to run each month and have the datetime prompt automatically popula…Steven Woods 186 views 7 comments 1 point Most recent by Steven Woods Reporting and Analytics for ERP
-
Cannot Deliver More Than 75K Lines to an OTBI reportSummary: Hi, The customer needs to extract data from an OTBI report with more than 75,000 rows. How can we change this limit, which is already pre-set in the report? Cur…Silas Henrique Silva 196 views 2 comments 0 points Most recent by Silas Henrique Silva Reporting and Analytics for ERP
-
Migration of FRS reports from one server to anotherSummary: Hello, I want to migrate my FRS reports from test to production server. After archieve and unarchieve, I changed my database connection as well but it didn't wo…Ayub 22 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
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 11 views 1 comment 1 point Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
HCM OTBI Report on all absences with a future or missing end dateSummary: Our IT dept are having a hard time identifying logins that are due for auto deletion due to inactivity but that actually need to be kept open (eg those on long …KerryanneLee 11 views 3 comments 0 points Most recent by KerryanneLee 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 341 views 1 comment 0 points Most recent by Lee Eslick-Huff 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 21 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 3 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
Unable to see requests run by service account.Summary:Unable to see requests run by service account. We have few service users defined through which we run some scheduled jobs. Recently we have created new service a…Niraj Kumar 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to find indexes really used in OTBI - Subject Areas ?Summary: How to find indexes really used in OTBI - Subject Areas ? The document R13_23D_FIN_OTBI_database_mapping_with ViewObjects.xlsx doesn't give really indexes used …LaurentDup 31 views 1 comment 0 points Most recent by Cristian Bilibou-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…Sushmitha G 231 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Customizing Accrual Reconciliation report and status is Retrying when running ess jobSummary: Customizing Accrual Reconciliation report and create a new custom ESS job by copying standard ESS job but when running it then the status is Retrying Standard E…MANOJVERMA090908 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 31 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM