Category 129
Discussion List
-
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 415 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
How to create data control name while registering ESS jobHi, We have requirement to modify default parameters of the seeded ESS Job. Parameters controls by the "Data Control Name" . Is there any feasibility to create a new "da…
-
How to hide "set ownership of this item" from properties option in Report and Analytics ?We have a requirement where business is asking to hide "set ownership of this item" for users with specific roles. we tried to hide from "Manage Privileges" but some how…
-
Request for audit report for the changes done on BPM Worklist - FinGlJournalApprovalSummary: I am looking for a audit report for the changes done on BPM Worklist FinGlJournalApproval. We noticed some of the rules has been disabled by some user and we ne…VAS-475620 12 views 1 comment 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
I am not able to see few terminated PPRs in iby_pay_service_requests tableSummary: Some of the terminated PPRs in the iby_pay_service_requests table are not visible to me. Does this table lack any security or data access? Despite the fact that…Lakshmi Bandlamudi 2 views 2 comments 2 points Most recent by Mohanasindhu Dhiraviyam Reporting and Analytics for ERP
-
Customize Printable Expense ReportSummary & Content: Need details for the other VOs and the attribute list similar to what was provided for PrintableReportVO and PrintableExpenseVO in the Oracle Ddocumen…Upendra Nayak 93 views 3 comments 0 points Most recent by User_QPZXD Reporting and Analytics for ERP
-
Item number field is not reflected in the Procurement Requisitions Real Time subject areaI used the Procurement Requisitions Real Time subject area in OTBI to build a report. There is just one field in the underlying source data that is not reflected in the …Walter L Gess 12 views 2 comments 0 points Most recent by Walter L Gess Reporting and Analytics for ERP
-
Question about Infolet on ERPHi Team, Our client is currently undergoing a process to revalidate user privileges. During this process, we observed that simply accessing the pages and viewing the Inf…Oscar Chahestian-Oracle 25 views 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting and Analytics for ERP
-
Processing Emails from CustomersSummary: I am looking for ideas on how other customers handle email communications from their customers after implementing Oracle Fusion. Content (please ensure you mask…
-
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…
-
Call back event for ESS-Jobset at OICSummary: Hi , We have a requirement where we are trying are to send multiple bulk export of data(AP,AR,GL) using a custom ESS job set. In that there is call back event i…
-
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 …User_2025-03-07-05-28-28-079 62 views 10 comments 0 points Most recent by Choudhary Punit Reporting and Analytics for ERP
-
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…Voladri Saikiran 32 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
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…Dinesh R 1 view 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
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…Eva Mirzoyan 100 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
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 …Luca Nobili PWC 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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 …Sridhar Gupta Yerram-Oracle 3 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
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…Harshal Kailas Desale 35 views 5 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
U.S 1099 Payment ReportHi, We had requirement to add below columns to U.S 1099 Payment Report. Vendor Type of TIN ( E/S) Vendor Recipient Address 1 Vendor Recipient Address 2 Vendor Recipient …Ismail Sherief 2 views 0 comments 0 points Started by Ismail Sherief Payables, Payments & Cash Management
-
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…
-
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…
-
Otbi report to compare budget revenue, baseline cost to project funded amountI am triying to create a report to ocmpare project planned cost, budget revenue against the funded amount in contracts module by combining Project Finacial plan with Pro…
-
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, …Gurvinder Singh Gill 72 views 3 comments 2 points Most recent by Sai Sunkara Reporting and Analytics for ERP
-
Combining Procurement Subject Areas for Enhanced AnalysisI am currently attempting to combine two subject areas, namely Procurement - Requisitions Real Time and Procurement - Purchasing Real Time, for a comprehensive analysis.…
-
Is it possible to implement a parameter refresh function when the parameter is in date format at BIPSummary: Is it possible to implement a parameter refresh function when the parameter is in date format, like a text parameter? Content: Hi, In the SQL for the parameter …M Watanabe 11 views 1 comment 0 points Most recent by CristinaV1-Oracle Payables, Payments & Cash Management
-
Are XPath functions fn:tokenize, fn:matches, and fn:replace are not supported by Oraclee?Summary: Hi, I am new to XSLT development, As part for customer requirement I have used tokenize function for looping. But PPR formatting is failing because of this. Err…Tejeswar J E 5 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
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…