Category 129
Discussion List
- 
             How to create Account Range parameter?Summary: Standard ESS job - Supplier Balance Aging Report, has a parameter 'Account Range'. How to define the parameter for a custom ESS job? Content (required): Standar… How to create Account Range parameter?Summary: Standard ESS job - Supplier Balance Aging Report, has a parameter 'Account Range'. How to define the parameter for a custom ESS job? Content (required): Standar…
- 
             Adding Days to DayNameI am trying to calculate the end of a weekly cycle. I have a column with day names and another column with the number of days to add. For example, adding 3 days to Monda… Adding Days to DayNameI am trying to calculate the end of a weekly cycle. I have a column with day names and another column with the number of days to add. For example, adding 3 days to Monda…
- 
             BICC Extract Schedules vs Job SchedulesSummary: Hi, I would like to create a pipe line between BICC and data warehouse to extract Financial Data I wonder what the difference and use case is for one or the oth…Daniel Sobotka 24 views 2 comments 0 points Most recent by Goutham PPM Reporting and Analytics for ERP BICC Extract Schedules vs Job SchedulesSummary: Hi, I would like to create a pipe line between BICC and data warehouse to extract Financial Data I wonder what the difference and use case is for one or the oth…Daniel Sobotka 24 views 2 comments 0 points Most recent by Goutham PPM Reporting and Analytics for ERP
- 
             Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various …Helle Hennings-Oracle 552 views 12 comments 14 points Most recent by Jose Carlos Amaral Flinco Financial Management Resource Center Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various …Helle Hennings-Oracle 552 views 12 comments 14 points Most recent by Jose Carlos Amaral Flinco Financial Management Resource Center
- 
             Account Analysis for Contra Account Standard Report - CustomizationHi , I have copy this standad report to my custom location . Now i want to add two more columns in this report. 1- Transaction Number ( Which is comming from subledger i…Jasir133341 134 views 2 comments 0 points Most recent by Nasir Iqbal Reporting and Analytics for ERP Account Analysis for Contra Account Standard Report - CustomizationHi , I have copy this standad report to my custom location . Now i want to add two more columns in this report. 1- Transaction Number ( Which is comming from subledger i…Jasir133341 134 views 2 comments 0 points Most recent by Nasir Iqbal Reporting and Analytics for ERP
- 
             R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …Noelle Bartlam-Oracle 6.3K views 24 comments 5 points Most recent by Prosenjeet Bit Reporting and Analytics for ERP R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …Noelle Bartlam-Oracle 6.3K views 24 comments 5 points Most recent by Prosenjeet Bit Reporting and Analytics for ERP
- 
             'Create Accounting for Assets' Custom ESS Job for Draft Accounting Mode only.Summary: How to create custom 'Create Accounting for Assets' ESS job where Accounting mode parameter must be - Draft only..? Content (please ensure you mask any confiden…Annpurna Swami 153 views 6 comments 0 points Most recent by Hasan Hasan Reporting and Analytics for ERP 'Create Accounting for Assets' Custom ESS Job for Draft Accounting Mode only.Summary: How to create custom 'Create Accounting for Assets' ESS job where Accounting mode parameter must be - Draft only..? Content (please ensure you mask any confiden…Annpurna Swami 153 views 6 comments 0 points Most recent by Hasan Hasan Reporting and Analytics for ERP
- 
             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… 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…
- 
             Rows repeating with different values though it's not available in the Front end under Customer SiteSummary: Hi, We have developed an OTBI report using Receivables - Customer Real Time and Receivables - Customer Account Site Tax Profile Real Time and it is repeating a …Rahul Kumar Gupta.-Oracle 21 views 2 comments 1 point Most recent by Daniel S.-Oracle Receivables & Collections Rows repeating with different values though it's not available in the Front end under Customer SiteSummary: Hi, We have developed an OTBI report using Receivables - Customer Real Time and Receivables - Customer Account Site Tax Profile Real Time and it is repeating a …Rahul Kumar Gupta.-Oracle 21 views 2 comments 1 point Most recent by Daniel S.-Oracle Receivables & Collections
- 
             General Ledger Balances Real Time OTBI not fetching Cost center values from COASummary: I am using General Ledger Balances Real Time Subject Area to extract all COA value set values and i am able to derive all COA values except for Cost center, Onc…TCG 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP General Ledger Balances Real Time OTBI not fetching Cost center values from COASummary: I am using General Ledger Balances Real Time Subject Area to extract all COA value set values and i am able to derive all COA values except for Cost center, Onc…TCG 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
- 
             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 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 954 views 3 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 954 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
- 
             Best Practice for Monitoring Performance and Resolving Issues?Hello, We are experiencing recurring times of slowness in our system and want to better monitor the performance to potentially troubleshoot this problem. When users repo…Alex Cavanaugh 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP Best Practice for Monitoring Performance and Resolving Issues?Hello, We are experiencing recurring times of slowness in our system and want to better monitor the performance to potentially troubleshoot this problem. When users repo…Alex Cavanaugh 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
- 
             how to enable incremental value schedule standard report in oracle fusionSummary: how to enable incremental value option while scheduling standard report Report : Payable trial Balance reportMohammed Masoodhu Hashir 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP how to enable incremental value schedule standard report in oracle fusionSummary: how to enable incremental value option while scheduling standard report Report : Payable trial Balance reportMohammed Masoodhu Hashir 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
- 
             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 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 103 views 3 comments 0 points Most recent by Rich Merkel 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 103 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… 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… 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… 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 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 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 91 views 1 comment 0 points Most recent by Daniel S.-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 91 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 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 482 views 2 comments 0 points Most recent by Harshali Shirgannavar-Support-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 482 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 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 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… 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 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 202 views 7 comments 1 point Most recent by Steven Woods Reporting and Analytics for ERP 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 202 views 7 comments 1 point Most recent by Steven Woods Reporting and Analytics for ERP