BI Publisher
Discussion List
-
Varalakshmi 31 views 4 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Segment value Security tableSummary: Need a table that stores values stored in Segment Value Security (SVS) Rules. Content (required): Table fnd_object_instance_sets stores the value in FILTER colu… -
Joining Subledger data with GL dataI need to build a query which joins subledger data table, xla_ae_lines to gl_je_lines. I am attempting this through gl_sl_link_id but the performance is awful, is there …
-
Italian AR E-Invoicing ProgressivoInvio NumberHi, As per Italian reporting requirement we are developing Italian AR E-Invoicing report with XML output. We have a tag called 'ProgressivoInvio', as per the customer re…
-
Performance impact while using standard viewsSummary: Is there any performance impact while using the standard views (in a BIP report) listed by Oracle. For eg. using standard view PJF_PROJECTS_ALL_VL, instead of t…
-
How to get the IP address of OTBI to add to a SFTP whitelistI am trying to get my OTBI environments IP address so I can whitelist it on a SFTP site. I found documentation on all the IP address, but I don't know which server I am …NicolaosDerr 96 views 2 comments 0 points Most recent by NicolaosDerr Reporting and Analytics for ERP
-
BIP Global Level Function Data not getting included in output after bursting.Summary Aggregate functions data show's up at report level which are involved in GLOBAL Level functions, but the same Data attributes wont show up, if we burst the file.…Kishan Dhongadi 195 views 9 comments 1 point Most recent by HarshithDarla Reporting and Analytics for ERP
-
Unable to view the data in data model with lexical parameterSummary: Unable to view the data in data model with lexical parameter Content (please ensure you mask any confidential information): Hi, We are trying to create a BI rep…JithendraKCV 37 views 1 comment 0 points Most recent by JithendraKCV Reporting and Analytics for ERP
-
Generate blank BIP reportHi Team, We have a BIP report in Oracle fusion that has a bursting code. This works fine when there is data for report. However, if no data is returned by the underlying…Prabhjeet Kaur 338 views 5 comments 0 points Most recent by Cm Adil Ch Reporting and Analytics for ERP
-
How to extact segment 2 from code_Combination_description in my xml fileSummary: How to extact segment 2 from code_Combination_description in my xml file Content (please ensure you mask any confidential information): My xml stores the code c…
-
Using OR with IF statement in rtf template is not working as expectedSummary: Using OR with IF statement in rtf template is not working as expected Content (please ensure you mask any confidential information): I have a requirement for my…
-
How to go up from JELINE_ROW to CCID_S in my xml on my rtf templateSummary: Going up a level or two of my xml on my rtf template Content (please ensure you mask any confidential information): I have customised the Account Analysis rtf. …
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli98 983 views 12 comments 1 point Most recent by Nareshbabu Mallela Reporting and Analytics for ERP
-
Sql Query to get data security applied on Chart of AccountsHello, I need an sql query to get my user's data security on the chart of accounts values. Thanks,
-
Cash to General Ledger Reconciliation ReportSummary Cash to General Ledger Reconciliation BI ReportContent Hi Friends, Did anybody Customized " Cash to General Ledger Reconciliation Report" or developed new report…OraFusionworld 113 views 4 comments 0 points Most recent by Vicky Adwani Reporting and Analytics for ERP
-
How to archive entire catalog (Shared and Users)?Summary: With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T o… -
R23 ERP OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 ERP OTBI subject areas to database tables mapping spreadsheets, R23 SCM OTBI subject areas to database tables mapping spreadsheets and …Mike.Myers.CDIPRODUCTS.COM 155 views 1 comment 0 points Most recent by Mike.Myers.CDIPRODUCTS.COM Reporting and Analytics for ERP
-
How to find latest record in table PJO_PLAN_VERSIONS_B for projectSummary: Hi Team, I want to know how to find the most recent record in PJO_PLAN_VERSIONS_VL as version_number is same for all 3 rows. Regards Nidhi... Content (required)…Nidhi Chhajed 278 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
SQL query to fetch Purchase Requisition Audit History using BI ReportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Revathi I 54 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Issue with OTBI Subject Area "Installed Base - Meter Based Asset Usage Real Time"Summary: Our issue is with the OTBI subject area called “Installed Base – Meter Based Asset Usage Real Time”. We can’t figure out how to exclude the canceled readings fr…Ajeez K-Oracle 23 views 2 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
how to create pivot table in a BIP report ?I am creating a work in progress report using BIP. I have projects with costs and revenue distributed on months. how can i get an output like this image. does anyone hav…Omran Zeaiter 217 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
date masking reverting date back a daySummary: We have customized the AP invoice approval report to add fields needed. Content (please ensure you mask any confidential information): Issue is that the date in… -
A report that tracks user access activity historySummary A report for security that tracks user login history what data or module was touchedContent Does anyone know how/where I can get this information together? This …Kimberly Nguyen 286 views 18 comments 0 points Most recent by Mayur_P Reporting and Analytics for ERP
-
Performance issueSummary AR | Performance issue with ra_cust_trx_line_gl_dist_all tableContent Hi All, Table ra_cust_trx_line_gl_dist_all is taking long time to run query when we use gl_…Sudha KOVURU 56 views 5 comments 3 points Most recent by SujithRajan Reporting and Analytics for ERP -
Report output name incorrect when downloading scheduled job outputs after upgrade to 23DSummary: We scheduled reports and when downloading it is generating name with % instead of space , but when republished it gives correct name for output file after upgra…Abhilash K - Deloitte USI 21 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
ESS Job vs BIPSummary: ESS Job vs BIP Content (required): Assuming we don't have any dependent list of values, is there any strong/security reason we should use ESS Job on top of the …Vinay Gharge 552 views 2 comments 0 points Most recent by User_8FGMM Reporting and Analytics for ERP
-
How to get customer AddressType from background tableSummary: When I enter the url below in browser, I can get AddressType, I need to build a data model and get similar info for a customer. https:///crmRestApi/resources/11…
-
In which table I can find readable names from HZ_CUSTOMER_PROFILES_F.STANDARD_TERMS?Summary: I would like to get readable names from HZ_CUSTOMER_PROFILES_F.STANDARD_TERMS, how can it achieve it? In link HZ_CUSTOMER_PROFILES_F, it shows STANDARD_TERMS is…boeingdream 213 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…Omran Zeaiter 1K views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to get output character set in ANSI for etext templateSummary: In Oracle etext template is set to "iso-8859-1", what value we need to provide to change it to ASCI. Content (required): Version (include the version you are u…SireeshaJaladi 470 views 2 comments 1 point Most recent by Yves Chanel Reporting and Analytics for ERP