To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS roundingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Validate OTBI Table Access for User based on Item Class RulesSummary: We have assigned the group “HPSA_CHANGE_REQUESTER” to Item Class “IC_HPSA”. And then assigned the role “HPSA_CHANGE_REQUESTER” to some users in order to assure …
-
How to output html stored in database as formattedI have a table column zmm_notes specifically where a column for the note text can be stored as formatted text, so the html tags to format are stored in the database. Wha… -
Unable to select Manage Formats from the Report LayoutI need to be able to format a column on a custom BIP to HTML but in the report layout in edit mode, I am unable to select the Manage Formats. What could be the issue?
-
Unable to access Usage Metrics Drill-Through ReportSummary: Dear Concern, We have purchased cloud services through a resell/partner model (i.e. partner users) and now when searching found that some users are getting an e…
-
How to restrict users from using direct base tables in Data ModelWe have to provide certain users with Create Data Model access in BIP, but need to restrict them to usage of only certain tables or certain data in the tables. Do we hav…
-
Restricting Data retrieved by BIP report queryHi, We have requirement to restrict the data returned by BIP query based on Data Access Security setup on ERP Cloud. We find that we have concept of Secured List Views (…
-
How to update Data Time Zone offset in the Data Format tab of Column PropertiesSummary: OTBI report using Posting Date can be displayed in Sydney timezone but when it is used in a calculation in Edit Column Formula, it reverts back to UTC timezone.…
-
Generating Sheet name dynamically in excel from xml tag in rtf word with PublisherSummary: in publisher while creating an rtf in word for a multi tab excel is it possible to generate sheet name dynamically from source After loading xml, should be able…
-
Inquiry Regarding Dynamic User Inclusion in Report Emails via BurstingSummary: Hi Oracle Experts, We have received a request from our users to include the username of the individual executing a report in the email body after the "Thanks" s… -
Do we really need the ESS Administrator Role to run the Approval Groups Report ESS Job?Summary: We figured out two levels of security are required to run the "Approval Groups Report": Enable the user to Submit the Scheduled Process /oracle/apps/ess/financi…
-
OTBI Agent generating report errorSummary: I built a new agent and it is set up to run as another user with full permissions. For some reason, every time it processes at its scheduled time, it appears to…
-
BIP internal bank account table?Hi Guys When I search online I get told to use view CE_INTERNAL_BANK_ACCOUNTS_V to lookup field INTERNAL_BANK_ACCOUNT_ID out of table iby_pay_service_requests. However w…
-
Support Incremental is not enabling for BICC extractSummary: Hi Team, we are using application composer custom objects and looks like supports incremental is not getting enabled to this like it happen for seeded ones. Can…
-
How to Reset the BICC Extract To last run Date via APISummary: Hi Team, we have requirement to reset to the BICC extract to last run date based on any failures. Can some one please let me know if this is possible via any AP…
-
How to create a hyperlink to another sheet within same excel -BIP report Excel templateSummary: I am trying to create an Excel template in which there are 2 tabs. One will have budget control balance details and other sheet will have PO details. Expected f…
-
BICC PVO for POR_BROWSE_TREESSummary: Do we have a PVO available for the table POR_BROWSE_TREES? Content (please ensure you mask any confidential information): Version (include the version you are u…
-
Prevention of Custom Extension Field mismatch in regard to different Instances for BICCSummary: Since Custom extension fields may differ from Instance to Instance is there a way to prevent this on BICC Content (please ensure you mask any confidential infor…
-
Date and Timestamp Datatypes from metadata for PVOSummary: We are retrieving the columns details such as datatype, precision and scale using the following endpoint(REST API metadata). However, some columns are labeled a…
-
From address change to display company domain in BPM workflow shows as "External mail" in OutlookHow to configure the BI publisher—> Administration—> Delivery configuration for Email delivery of all workflow emails from Company domain. Currently I have added the Fro…
-
INV_ACCESSIBLE_ORGANIZATIONS_V View Not AccessibleThe INV_ACCESSIBLE_ORGANIZATIONS_V view that is used in our BI reports is previously accessible using other roles even without the Application Implementation Consultant …
-
How can I configure "All" prompts in BI PublisherSummary: Content (please ensure you mask any confidential information): I have a report with some parameters, I would like them to come with the default value "All" and,… -
How to change the measures in the Chart based on the Dashboard promptSummary: Content (please ensure you mask any confidential information): We have a scenario involving three types of costs: A, B, and C, which have been added as measures…
-
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…
-
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…
-
PL/SQL Query to ADD Month to a Period NameSummary: I have a scenario where a user will pass input period name. The query should return data of both the current period entered by the user and the previous period.…
-
How to add a header to the e-text outputSummary: By default the e-text layout output doesn't have column headers. We have a requirement to add the headers as well for the integration file with the third party.…
-
Why do scheduled reports with a daily frequency cannot be received on a weekend (Saturday & Sunday)?Summary: The business users created a schedule for the daily backup of a report, but the backup mail is being received only from Monday to Friday. Mail for Saturday and …
-
How to create a parent schedule for multiple schedule of one BI Publisher reportClient has created multiple schedule of one one BI Publisher report using different parameters ex-cost centres and different recipient in each schedule. Is it possible t…
-
How to get Amount in Words in Arabic language in excel template with Saudi currencySummary: I have total eg: 21113.75 and it should show in output arabic of 'Twenty-One Thousand One Hundred Thirteen Saudi Riyals And Seventy-Five Halala'. I am able to g…