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
-
Unable to find PVOs related to MSC(Planning Table)Summary: Hello, We need PVOs for following(Fusion) tables in BICC, as we couldn't find these in Data Lineage Sheet. If anyone has any idea on how to get those or any doc… -
Need to report all journals and subledger activity (drilled data) on one reportSummary Currect reproting only allows reporting by one source at a time, need to see all for one account in single reprot.Version Fusion Cloud 20D -
Permission Error When Trying to Migration BIP Reports between DEV and SAT environmentsSummary: We've setup a pipeline in VBS and are using a job to migrate data models and bip reports from one region to another and running into a permissions error on our … -
with clause subquery and function together and usage of bind variableSummary: Hi Team, I am facing an error as "ORA-17003: Invalid column index". I am using functions(with clause) and I have to get the value from the BIP report parameter.… -
When Scheduling a Bursting Report, the Parameters in trigger are Not Loading on the Schedule TabI have a BI Publisher data model that accepts a :from_date parameter and includes bursting logic. To handle the "no data found" scenario during bursting, I created a tri…
-
How to default a Prompts selection in OTBI dashboard from Lookup code based on logged in UsernameWould like to reach out to you on how to set the default value of a Prompt with a value from lookup code which is related to the logged in User name. We have an Analysis…
-
Is it possible to split a concatenated segment (accounting combination) in an OTBI reportSummary: I am trying to split the concatenated accounting combination into different columns, each column should be displaying a segment separately Content (please ensur… -
How do you delete BICC UCM filesSummary: For data security, once the UCM files have been generated and the data has transferred to destination using BICC, how do we get the UCM content deleted. Content… -
Plsql procedure from a Saas Report or Saas page?Summary: Invoking pl-sql procedure from SaaS Report or through a SaaS link on a page Content (please ensure you mask any confidential information): We haven't OIC. We'd …
-
oracle.xdo.xdoexception: java.net.malformedurlexception: unknown protocol: xdoxslHi, We are facing an issue with a particular user for BI Publisher report where we have a sub template. However, When I run the report, I don't see any issues from my en…
-
How to control the scheduled BIP report Output based on Row CountRequirement : BIP report schedule daily - which is configured to send an email - base don the configured emails. Is it possible to control sending an email based on the …
-
Need guidance on Malaysia specific localizationWe are looking for information regarding Malaysia localization changes that have been implemented from reporting perspective. What are the possible changes we need to ca… -
Oracle Fusion Financials Localization for MalaysiaSummary Oracle Fusion Financials Localization for MalaysiaContent Hello all, Is there an Oracle Fusion Financials Localization for Malaysiawhite paper document? I am loo… -
ERP Cloud implementation using Agile methodologySummary ERP Cloud implementation using Agile methodologyContent Good Morning everyone, Has anyone done ERP Cloud implementation using Agile methodology ? Any feedback/le…
-
How to customize standard OTBI ReportSummary: How to customize standard OTBI Report Content (please ensure you mask any confidential information): I need to customize one of the standard OTBI reports in Fus…
-
Cost Center from subject area "Payables Invoices - Transactions Real Time"Content Hi. I'm struggling to figure out how to find the field, where I can see the cost center, outside the concatenated segment... Whenever I use the Cost center descr… -
BI table for AR transaction approvalHi Team, Please help to get table that stores AR transaction approval History. I am not able to find any dedicated table like AP Invoices (AP_INV_APRVL_HIST_ALL). Also t…
-
BI Report Pulled Into a Dashboard Displays the Parameters in TEST Environment but not PRODIn our Production environment I pulled a report into a dashboard and I can’t view the report parameters when I open the dashboard. However, when I create this report and… -
Unwanted Linefeed characters getting returned in eText outputSummary: Linefeed characters getting returned in eText output Content (please ensure you mask any confidential information): I am having an issue where there is both Lin…
-
SQL Query to extract all details related to data roles and security profiles designedSummary: Need an SQL query for creating a data model and subsequent BIP report, to extract the details of all the data roles and also the security profiles like Person, …
-
Need help : Looking for table with 'Alternate Account Owner Name'Hello, I'm currently working on a report related to customer bank accounts, and I would appreciate your support. Does anyone know which table and column store the "Alter…
-
Need to pull FND attacements in BI Report- ERP CloudContent Hi Team, In Oracle Subscription Management (OSM) module, where while creating a subscription the user will attach a file(excel/word/….) with certain information(…
-
How to save an OTBI report into Reports and Analystics Favorites of Job Managers role in ERPI have developed some OTBI and BIP reports and I would like to centrally save this report in the Reports and Analystics Favorites for list of users / role. (Instead of e…
-
How to delete page entry which are created using structure toolSummary: How to delete page entry which are created using structure tool Content (please ensure you mask any confidential information): Hi All, We created page entry(Rep…
-
How to hide parameters in scheduled process ?Hi, we want to hide some parameters that we don't populate in a scheduled process. For example, we want to hide source locator and destination locator from "Print moveme…
-
Please advise how to create a scheduled report of all administrators of the oracle application?Summary: IT would like a monthly report of all administrators of the oracle fusion application. The Scheduled Process report, User Role Membership Report, contains data …
-
Method to Bulk Retrieve and Review Job DefinitionsSummary: Method to Bulk Retrieve and Review Job Definitions Content (please ensure you mask any confidential information): Task Name: "Manage Enterprise Scheduler Job De…
-
OTBI Custom Report Scheduling -- Date Parameter IncrementSummary How to increment date parameter to run with sysdate for Scheduled OTBI reportContent OTBI Custom Report has PO Date which is a parameter with in between operator…
-
Scheduled Report increment dateSummary CAn we schedule a report with incremented date?Content Some reports require a date parameter. In EBS, there is a way so that a scheduled report’s date parameter …
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…