Category 129
Discussion List
-
Query To Find Label Name For Each Node ValueSummary: Dear All, I need a Query to extract Label Name for each Node Value. Content (please ensure you mask any confidential information): Dear All, I need a Query to e…Elisa Riz 81 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Can we triggle process in OTBI dashboard?Summary: Can we triggle process in OTBI dashboard? Content (please ensure you mask any confidential information): For example, can we triggle "Create Accounting" process…YiwenYang 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Do we have BICC PVOs for ERP’s Audit logs?The client has enabled Audit in the ERP Cloud as per regulatory requirement. I would like to understand if we got these audit logs in PVO's for BICC extraction. Can you …Keerthana Rajagopal-Oracle 32 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
how to calculate BEG_BALANCE_CR for QTD in glSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…User_L7QIF 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Can we hide the OTBI Seeded Folder list in the shared folder?Summary: Is it possible to hide the OTBI seeded folder list in the shared folder and will just only show the custom folder? Content (please ensure you mask any confident…Altagracia Javier 53 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
It is possible to include the CX module in the OTBI?Summary: It is possible to include the CX Module in the OTBI even if CX have a separate UI from the Oracle? Content (please ensure you mask any confidential information)…Altagracia Javier 21 views 3 comments 0 points Most recent by Altagracia Javier Reporting and Analytics for ERP
-
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…Swapnil Kashid 1 view 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
SQL query to get transaction date on statement lin, joining CE_BAT_TRANSFERS with CE_STATEMENT_LINESI'm trying to create a query where I want to find the transaction date of an Internal Bank Transfer. The goal is to create a report which is used for reconciliation of b… -
How can we merge multiple OTBI report lines into one lineWe are building one report which contains project wise team member details. As per the requirement, we should have one line in the report for each project displaying eac…Sanket.Kakde 465 views 7 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Can I change bip:AUTHOR on a saved BI report?Summary: Is it possible to change the bip:AUTHOR value on a saved BI report? Content (required): I want to make some reports public that I've exported to a .CATALOG file…JimCC 83 views 5 comments 0 points Most recent by Shanmugaraja_Karunamoorthy Reporting and Analytics for ERP
-
Oracle Social Network Cloud Service (OSN)Summary: Oracle Social Network Cloud Service (OSN) Content (please ensure you mask any confidential information): With oracle retire the Oracle Social Network Cloud Serv…
-
Is there a size limit to extract data from Fusion ERP?Summary: We will extract data out from Fusion ERP using BIP, BICC to Data warehouse. Is there a data limit? Will Oracle charge for outbound (egress) traffic? Content (pl…Jie Shen 151 views 3 comments 0 points Most recent by Madhavi Godbole Reporting and Analytics for ERP
-
Generate file name at runtime with respect to parametersSummary: I want to get Report's output where i want to generate name of output report with respect to User Input Parameters against the same Bi Publisher rtf Report. Con…
-
Need OTBI to bring the newest site only (Latest creation DateSummary: I created an OTBI report for Supplier and Supplier Sites. I need to enhance the report to bring only one site for 1099 purpuses. The site needs to be the one wh…Pablo Schenquerman 41 views 6 comments 0 points Most recent by Pablo Schenquerman Reporting and Analytics for ERP
-
How to get row count from PVOs in BICC?Summary: We have been asked to verify that the # of rows we have pulled out of Oracle via BICC is correct. When we attempt to do a COUNT(*) against some PVOs, we are get… -
How to get data for Audit Reasons column in OTBI like the Expense Auditor Dashboard ?Summary: We are working on a custom dashboard for Expense auditors and one of the fields requested in 'Audit Reasons'. The subject area 'Expense- Expense Transactions Re… -
Custom BIP Report Dynamic Column IssuesSummary: The requirement is to print the output in below format: For each period, there should be a row and corresponding value in dynamically generated column. Ex.- For…
-
BI Excel Template missing formula when data generatedSummary: I've created a BI Excel template based on a DM and the requirement is to have certain columns color coded in the end of the report and also have a formula field…KrishnakumarPathipati 31 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Invoices Paid on timeSummary: Hi Business is trying to generate the invoices paid on time report in Fusion Cloud Not able to trace the seeded / standard report for the same. Can you please g…SaurabhSinghal26 61 views 6 comments 0 points Most recent by Prateek Bajpai Reporting and Analytics for ERP
-
retrieve latest entry from table OKC_K_HEADERS_TLSummary: I am trying to get only the entry that has the most recent creation date from this table. Content (please ensure you mask any confidential information): Creatio… -
Identifying Underlying Queries for SmartLOV/ VOs In BI PublisherSummary: Content (please ensure you mask any confidential information): Hi experts, Would any of you know how to identify the underlying query for a view object in BI Pu…
-
Adding a custom report to DOR screenSummary: Adding a custom report to DOR screen and need the report to fetch data related to current employee but the report fetches null. Content (please ensure you mask …Salma Mohamed Salem 11 views 0 comments 0 points Started by Salma Mohamed Salem Reporting and Analytics for ERP
-
Etext template output file(.txt) is unable to print Arabic language in sequenceSummary: We have custom Etext template under disbursement payment file formats. In that Supplier name is required to show in Arabic language in output file. for testing …SireeshaJaladi 41 views 2 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Oracle EBS - invalid SessionSummary: Oracle EBS - invalid Session Content (please ensure you mask any confidential information): How can this be resolved fndgfm.jsp error : The current session is i…
-
Is it possible to generate barcode for space in BIP fusion?Summary: Is it possible to generate barcode for space in BIP fusion? Content (please ensure you mask any confidential information): We've already setup BIP barcode font …Lucy.liu 42 views 3 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
How to filter and sum positive or negative value only in FRS reportSummary: To see if FRS report could filter value of positive or negative and do summation against it. Content (required): We would like to know is there a way to filter …Chow Ka Ming Jason-Oracle 81 views 1 comment 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
BIP report historySummary: I have a requirement to pull the BI reports from Report history for failed runs. Do we have any table to pull the BIP report data based on date range. Content (…
-
OTBI Analysis - General Ledger - Journal Real Time : No output after MigrationHi, I have migrated OTBI report to one of the demo environment but I am not getting any data in the output. There are no filters in the report and I have validated that …Karun Jain-Oracle 1 view 1 comment 0 points Most recent by Karun Jain-Oracle Reporting and Analytics for ERP
-
RTF template to xls report with blank rows due to conditional regionHi All I created a rtf template which need to output as a xls file. After it generated, it shows some blank rows due to the conditional region in ref template. xls outpu…
-
DTD and Index file for Germany tax reportingWe have a Legal Entities registered in Germany and we have to submit data to German tax authority. For this, I have followed the note id Oracle Fusion Cloud ERP: Germany…