BI Publisher
Discussion List
-
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 55 views 2 comments 0 points Most recent by Nathan CCC 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…
-
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 12 views 2 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
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 45 views 3 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Which Oracle DB packages are provided in BIP datamodels?Summary: Hello, actually we are looking for an Oracle provided db package with a standard function to convert item weights between item_weight uom codes. I want to use t…Frank.Steinjan 94 views 5 comments 3 points Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
Need to fetch the amount( Debit - Credit) from XLA tablesSummary: Need to fetch the amount( Debit - Credit) from XLA tables Content (please ensure you mask any confidential information): We developed the query to fetch the amo…
-
Link between Cost Management, XLA and GL_Code_Combinations tables in FuisonSummary: Link between Cost Management, XLA and GL_Code_Combinations tables in Fuison Content (please ensure you mask any confidential information): We need to build the …
-
Bi Publish can't export get an error.Summary oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODms…Angela.Ahrens 72 views 5 comments 1 point Most recent by Ralph Aldrich Magno Reporting and Analytics for ERP
-
Drill Down from BI Publisher to another BI Publisher (Summary to Detail)Summary: Trying to navigate from a summary report to detailed report. I am following the documentation. This is the URL I am using.… -
Fusion ERP - Roles x Privileges ReportHi everyone, Do we have a report that lists all the privileges for all roles (including both predefined and custom roles) in Fusion ERP? Something like this: Role | Priv…Jorge Gutierre 44 views 4 comments 1 point Most recent by Jorge Gutierre Reporting and Analytics for ERP
-
possibility to build OTBI analytics report from Cash Management bank statement + Accounting dataSummary: Hi, would like to ask for any hint and help, if OTBI analytics tool is suitable to build report from Cash Management bank statement + Accounts from Primary and …
-
The following KFF segments has set up issues and needs to be resolved before BI extender can be runSummary: We are running: Import Oracle Fusion Data Extensions for Transactional Business Intelligence Output file shows this error: Why are we seeing these errors?. We a…Bo Tøpgaard 66 views 5 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Is there a way I can concatenate addresses in HZ_LOCATIONS?In EBS, you could call a package (hz_format_pub.format_address()) which would concatenate the address elements when passed the location_id as an argument respective to t…Innovate.Matt 43 views 2 comments 1 point Most recent by Innovate.Matt Reporting and Analytics for ERP
-
How to find Parameters passed for scheduled ESS jobSummary: ESS job 'Purge interface tables' was scheduled 4 years back for AP invoice, due to some issue we cancelled the schedule and now we want to find the parameters u…Nidhi Chhajed 3.1K views 28 comments 0 points Most recent by PaulaPraska Reporting and Analytics for ERP
-
Getting 403 Forbidden calling BI Pulisher service (ExternalReportWSSService) ?Summary: While calling BI Publisher soap service (ExternalReportWSSService) using JAVA API (jax-ws), we are getting 403 forbidden error. This was working fine earlier, Q…User_ZVJPC 45 views 1 comment 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Customize AP Check Print in FinancialsContent Hello all, I customised the template of the default AP Check Print and also attached my data model to it, yet it stills shows the seeded template when I print th… -
Sorting in eText templateSummary: We have a requirement to sort data based on a tag from XML using eText template Content (required): In eText we can sort based on tags but here we have to sort …
-
Is there a way to predefine calculations in oracle cloud ERP for FRS reportsMost of our Financial reports built using Oracle FRS Web studio are driven by calculations. Managing custom reports becoming more and more difficult whenever there is a …Priya Mandava 31 views 2 comments 0 points Most recent by Priya Mandava Reporting and Analytics for ERP -
How to join requisition and purchase order tablesI am using POR_REQUISITION_HEADERS_ALL and PO_HEADERS_ALL to get requisition data and related po data if present. But there is no join between given tables. Please sugge…
-
TIP: Dynamic deep links / drilldowns on BIP report. Relative deeplink path.Summary: You can use this trick to make your deeplinks working without instance hardcoding and make them working also on email templates and e.g. excel extracts. Content…alexey.shtrakhov 279 views 3 comments 3 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
I have the following error (PER-1531492) at Enterprise Resource Planning (ERP)The documentation shows me this description : “You cannot create a work measure record for the selected unit because future records exist for the same unit. Delete the f…
-
Query to get Contract Financial SummarySummary: Dear All, I'm need a report that gets data from the following table in the Contract Financial Summary. What are the oracle tables or Views to get this data from…Patrick Chrabieh 39 views 3 comments 2 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Link between XLA, FA and supplier detailsSummary: Link between XLA, FA and supplier details Content (please ensure you mask any confidential information): We have a requirement to fetch the XLA accounted DR, CR…
-
'Payables Invoices - Holds Real Time' subject area has been obsoleted from 19bSummary Payables Invoices Holds Information Reorganized in the Oracle Transactional Business Intelligence Subject AreasContent Hi All--> Payables Invoices Holds Informat…
-
Sql to reconcile Receivable Invoices' balances with their applied receiptsSo, I have constructed a sql query to look at Receivables balances using ra_customer_trx_all and ar_payment_schedules_all. I have another query which I tried to summaris…Robert of STAU 1K views 4 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
Is there a Supplier Open Balance Letter report in Fusion Payables?Summary: I need a report to list supplier's invoice amount, payment amount, discount amount, prepayment amount applied and remaining balance. Content (please ensure you …Dennis_0427-Oracle 73 views 2 comments 0 points Most recent by Sigrid B. Reporting and Analytics for ERP
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…Mayur Gangar 11 views 1 comment 0 points Most recent by Mayur Gangar Reporting and Analytics for ERP
-
Issues with Expense Report DFF's in BI Publisher?Summary: In our expense reports, we have several DFF's set up to pull information regarding miles travelled for airfare, car and rail. The fields show up in OTBI, but no… -
Issue during passing a parameter to OTBI analysis in Page Composer doesn't workIssue during passing a parameter to OTBI analysis in Page Composer doesn't work Description : I am trying to do page customization using the page composer for the "BPA C…Venkata Jagan Mohan Vendra 52 views 3 comments 0 points Most recent by Venkata Jagan Mohan Vendra Reporting and Analytics for ERP