Category 129
Discussion List
-
How to use Starts With or Contains function in BI Report SQL QuerySummary: Is it possible to use Starts With or Contains function in BI Report SQL Query? If so, how? Content (required): Is it possible to use Starts With or Contains fun…Richard Nagle 260 views 2 comments 0 points Most recent by Richard Nagle Reporting and Analytics for ERP -
Query to retrieve entries using accounting period from and accounting period to parameterSummary: Query to retrieve entries using accounting period from and accounting period to parameter when both are optional Content (required): Version (include the versio…Abhilash K - Deloitte USI 17 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How can we secure/hide the Reports and Analytics Panel Tab on a given page?Summary: Requirement is to secure the Reports and Analytics Panel Tab on certain pages to certain roles or in one case hide it completely. How do we do so. Content (requ… -
How to apply font color conditionaly in BIP ExcelSummary: We are currently building an audit report in which changes should be highlighted. The report contains values before and after. If value after is different from …Guillaume SAVALL 32 views 2 comments 1 point Most recent by Guillaume SAVALL Reporting and Analytics for ERP
-
Error in accessing BICC URL ending fusion pod /biacmSummary: Hi Team, We are getting error while trying to access BICC using url - fusion POD /biacm. Anyone faced similar issue, so need help in resolution of same. ADF_FAC…raban 64 views 4 comments 0 points Most recent by SiddharthDang-Oracle Reporting and Analytics for ERP
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…Sharmava 264 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Can we add attachments using sandbox?Summary: We have a business requirement that the users wants to attach documents in the Supply Request Form. Can we add attachments '+' using sandbox? kindly guide us ho…Immanuel Abishek 34 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe… -
No access privilege for subject area errorSummary: User getting this error No access privilege for subject area when trying to access OTBI Reports using Order Management – Fulfillment Lines Real Time subject are…SakshiA 32 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Getting error in FRS reportSummary: Getting errors in the FRS report Content (required): Hi All, I moved one FRS report from TEST instance to PROD. When I try to run the report in PROD, I am getti…
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co…sailesh_cloudare 410 views 1 comment 2 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
Need help with querySummary: May I know what is wrong in this query Content (required): SELECT order_key, dfla.source_order_number, dfla.source_line_number, DFLA.ordered_qty using_requireme…kalyan gade 105 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Output Name is incorrect in Report Job HistorySummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the Schedule Report Job History screen inside file name bu…
-
How to use INSTRING function to retrieve string Position in OTBI Formulae column?Summary: How to use INSTRING function to retrieve string Position in OTBI Formulae column? Thanks, ImmanuelImmanuel Abishek 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to default System Date using Sandbox?Summary: We have one requirement that we need to default the system date in the Supply Request Form Content (required): We have one requirement that we need to default t…Immanuel Abishek 61 views 0 comments 0 points Started by Immanuel Abishek Reporting and Analytics for ERP
-
OTBI User sessions not shown in Manage sessionsSummary: Other user's OTBI sessions don't seem to be always passed through and visible in Admin>Manage sessions, even when using report with prefix set to: SET VARIABLE … -
naSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Is there an accounted equivalent to AMOUNT_DUE_ORIGINAL field of AR_PAYMENT_SCHEDULES_ALL table?Summary: We need a field that captures the accounted amount equivalent of the AMOUNT_DUE_ORIGINAL field from AR_PAYMENT_SCHEDULES_ALL table. Content (required): Hello, W…Kristelle 112 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Distributed Amount for direct report - cannot find field in analysisHello, This is the module compensation. Navigation --> Compensation>Act as proxy manager>Manage Budgets I am not able to retrieve the 48142.80 for the 11 direct reports …
-
Filter function in case statement in otbi columnIn my otbi analysis, I tried to add this formula in my column CASE WHEN "Compensation - Workforce Compensation Budgets Real Time"."Workforce Budget"."Published Worksheet…
-
Fusion to Datawarehouse mapping for reportingSummary: We are currently using Snowflake as out data warehouse product. We generate quite a few different reports from the data located there and this move to Oracle Fu…
-
How to hide parameters in csv output and change data formatHi All, I'd like to create a report which output type is csv. After the output file was generated, I found the parameters of report are included in the output file and o…
-
BIP - For payment methods used by customers against AR invoicesSummary: Content (required): Need to write a BIP to find payment methods used by customers against AR invoices. Facing difficulty in finding link between RA_CUSTOMER tab…Maheedhar_Atmakuru 31 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Source Table for Manage Common Options for Payables and Procurement:Summary: Need Help on Source Table for Manage Common Options for Payables and Procurement: Pls see below screenshot of the screen.. Content (required): Given the Busines…JSalarza 290 views 1 comment 0 points Most recent by Danieleeeeee-Oracle Reporting and Analytics for ERP
-
How to initialize session based on username in Oracle cloud BIP reportsSummary: How to initialize session based on username in Oracle cloud BIP reports. If a Service user is running a report and has to initialize the report based on a parti…
-
Need to Convert PDF from word and merging more than one PDF documentsHi, we are planning to use BI Publisher of Oracle analytics cloud to print customer invoice out of a custom tool being developed in VBCS. we have a requirement where the…
-
Suppress Rows - Zero not working in SmartviewSummary: I am trying to Suppress rows that have HSGETVALUE formulas in them for account member in Smartview report. When the account value is zero, the rows should be su…
-
How to preserve the single space character in the report?Summary: In the data model, LOOKUP_CODE has 'single character space' , and in the report the column content becomes a null value or it is automatically trimmed in the re…Maria Femia Bianzon 43 views 10 comments 0 points Most recent by Maria Femia Bianzon Reporting and Analytics for ERP
-
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…
-
Member Selection is not showing correct value in Smart View ReportSummary: We are building a Smart View report. We have one account segment named Facility which is BSV as well. Now when we select Facility from Member selection it is no…