Category 129
Discussion List
-
How to remove Contract Template PDF Cover Page?Summary: How are we able to completely remove/delete the cover page on the contract template PDF page? We were able to remove the signature lines on the last page but ha… -
-
Create Rules XML File for BI Extender Automation - NO LOVwhen i run Create Rules XML File for BI Extender Automation program, its not showing in any LOV in parameter, role is already assigned to user What could be reason ?Sandeep Nihalani 113 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Inventory valuation Report (As of Date) - DepericatedWe had Oracle delivered Inventory valuation Report which used to run by parameter as of date. We were using it extensively. Unfortunately Oracle has depreciated this rep…Oracletechnofunctional 198 views 4 comments 0 points Most recent by Adarsh.Kumar Reporting and Analytics for ERP
-
Custom FolderSummary: We have created a folder named "Reports " - it is not in the custom folder - will this folder be preserved when doing an upgrade or do we need to put all custom…Vinayak Walse-Oracle 61 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
HFRS - How to generate Date Format for a report Dimension - Accounting Period on report HeaderSummary: We have a requirement where the HFRS Report header needs date format of the Accounting Period. Content: Our Accounting Period Format is MMM-YY and this is a Dim…Shefali Lakhani 129 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
General journals - transaction IDSummary: Hi all - within OTBI is anyone able to let me know where I can find a transaction ID or a global GL transaction number or similar? I'm trying to add it into an …Christopher McDermott 23 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
OTBI reports: The currency symbol always defaults to dollar $ symbolSummary: We have always used 'User's Preferred Currency' for the Currency symbol under 'Data Formatting' in OTBI reports. We are rolling out reports to EMEA and APAC use…VivekKandasamy-Oracle 55 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Oracle Analytics Cloud (OACS) Training for a BeginnerSummary: Oracle Analytics Cloud Training for a Beginner Content (please ensure you mask any confidential information): Hello, Can anyone recommend training or resources …Lola Kassim 34 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
formatting currency through DM or RTF?Summary: when customizing a DM and RTF, I need to format the currency into $****,****.XX format. Content (please ensure you mask any confidential information): Should I … -
Image in BI Publisher template spills into attachment when sent to e-mail outputSummary: Image in BI Publisher template spills into attachment when sent to e-mail output Content (please ensure you mask any confidential information): In BI Publisher …Robert of STAU 42 views 7 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Need to convert string into hash valueHi, I need to convert 'AKEBSTEST-700(2.1)' string into hash value i.e '561956564' using sql or Plsql. Is any function we can use to convert this value.vikram khengare 32 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Transactions coming from external systemsHi We are defining lets say a tax rate 20% and not mentioning whether its inclusive or exclusive at the setup level. If transactions are coming from interfaces, is their…
-
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 83 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 22 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 29 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 55 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 22 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 431 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 86 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 147 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 43 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…