Category 129
Discussion List
-
Applying a date filter on a PVO extractSummary: As we have been using ERP, some of our PVO tables are getting quite large, while the data extracts normally have less than 1 million rows in them, the PECSV val…Dave Kekish 43 views 1 comment 1 point Most recent by Alexandru Burcea-Oracle Reporting and Analytics for ERP -
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.…SuniChacko 350 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
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…
-
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…
-
How to unmerge the cells when the rtf template is exported to Excel ?Summary: We have a report requirement that rtf template is exported as an excel output report, but the issues are the rows are getting merged in excel Output. Content (r…Abhhishek42 455 views 7 comments 0 points Most recent by Ralph Aldrich Magno Reporting and Analytics for ERP
-
PO Column for Receipt Accounting Source in Oracle Fusion. Which role or privilege needs to be added?Summary: PO Column for Receipt Accounting Source in Custom Account Analysis Report in Oracle Fusion. Which role or privilege needs to be added? Content (please ensure yo…
-
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…Priya_Ananda 31 views 1 comment 1 point Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
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 …Czarina Morales 51 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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 …Czarina Morales 21 views 3 comments 1 point Most recent by Czarina Morales Reporting and Analytics for ERP
-
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…Kasthuri.S 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
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,… -
Can I change the date format in the BI Publisher data model to 'DD/MON/YYYY'?Summary: In the Fusion, publisher reporting → data model→ SQL Query "select to_char(to_date('12/09/2024','DD/MM/YYYY'),'DD/MON/YYYY') from dual;". It always returns 12/0…Amanda H5KKO 719 views 4 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
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.…Nitin Gupta_322 31 views 2 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP
-
How to add 2 columns in group by in Excel templateSummary: Need to add 2 columns in Group by expression in EXCEL template Content (please ensure you mask any confidential information): below condition is working for 1 c…Thanigainathan R 143 views 2 comments 0 points Most recent by User_6NK6Y Reporting and Analytics for ERP
-
Want to embed only bip report output and not the header sectionSummary: Hi Experts I want to embed below bip report in the supplier page but i could see that when i embed the bip page the header containing web page, home, catalog,fa…mudassirsOrc-Oracle 11 views 5 comments 1 point Most recent by Aishwarya1990 Reporting and Analytics for ERP
-
Inquiry AP ReportSummary: Is there a Payables report that I can run that provides a clean listing of invoices as of a specific date that make up the balances shown on the Payables Trial …
-
UNSPSC Code HierarchyDoes there exist within ERP a full listing of available UNSPSC codes and its potential hierarchy? I am assuming this data is available within ERP but I can't see it if i…
-
Receivables Concatenated Segment is not showing updated account in OTBI report.Summary: Hi, We have an OTBI report using Receivables - Transactions Real Time wherein we have added 'Receivables Concatenated Segment' column but it is showing the Reve…Rahul Kumar Gupta.-Oracle 23 views 0 comments 1 point Started by Rahul Kumar Gupta.-Oracle Receivables & Collections -
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 31 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
No Data Found when Other Users run BIPSummary: I created a simple vendor report with BIP. I can run it fine and see the data such as vendor name, number, address, etc. I have another user, Employee B, who on…
-
how to use SQL to create otbiI have Created an sql query for BI report , but I want to convert it to OTBI analysis is there any way to achieve this ?Mohamed Abdelbar 63 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to create a dashboard for a cash control budgetSummary: This document provides an overview of how to install and use the Cash Control Dashboard Content (please ensure you mask any confidential information): The Cash …Teresa McGoldrick-Oracle 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
sql query to fetch sales order(export order) related details from oracle fusionhow to get delivery mode(FOB,DDP etc), Exporter(To ship) address,fumigation status(YES/NO) and type of certificate required for a sales order export compliance from orac…
-
PVO DetailSummary: Im trying to get the detail of what this PVO is including (HcmTopModelAnalyticsGlobalAM.HcmRecSrcTrackingAM.SourceTrackingViewAllPVO ) , is there a good documen…
-
Query to get all item attachments in OTBISummary: I need a query to get all item attachments (images and documents) in OTBI. Also it's necessary to show item number associated to the attachments. I ask which it…
-
how to add multi line text using interface text in sandbox in oracle fusion applicationReplace multi line text using interface text in sandbox in oracle fusion application. output: Expectation: it should print 2 lines with a line gap i. Attach supporting d…Pooja K-Oracle 11 views 2 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to schedule an OTBI report to run for a subset of the full OTBI report?Summary: I have an OTBI report I created that lists all active Projects, the assigned project managers and total budgeted amount. The full report with all project manger… -
Inconsistent running time of BIP reportsHello Everyone, We have an existing Custom BI Report that we are monitoring, running this report thru Scheduled Jobs 10 times to check how long this report run. Sometime…Michael_B 51 views 3 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
OTBI AP invoice report for approver, approval action date, payment dateSummary: We tried to build one, but the payment date is coming in incorrectly where it says it was paid before the invoice was even created. Anyone successfully build su…Alex Glose 1 view 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
What tablle gives the solicitation response historyI am looking for data under analyze →view response history on the solictation page