Get Started with Redwood: Oracle Cloud SCM and Purchasing
BI Publisher
Discussion List
-
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 64 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 42 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 259 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 33 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
-
Recommended properties/parameters for an image to be used in RTF template of BI PublisherHello Oracle Experts, We are working on with updating the template for PO print to add logo/images. As such, may we know if there are any recommended properties for the …marc.joed.de.guzman 15 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Nees SQL query to get the transaction status of Intercompany transactionsHi team, I'm creating a BIP report to extract intercompany transactions and related details. I need to join 'AP_INVOICES_ALL' or 'XLA_AE_LINES' table to 'FUN_TRX_HEADERS…Tharushi Sathsarani 497 views 2 comments 0 points Most recent by Lakshmi Alagappan-Oracle Reporting and Analytics for ERP
-
EGP_EXPLOSIONS_V loads nothing, component tables do.Content Hi. I'm querying the view EGP_EXPLOSIONS_V and loads nothing. I queried its individual tables and DO load data: * egp_system_items_b_v * egp_structures_b B, * eg…User_2025-02-07-06-48-26-537 48 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
System Accounts from per_usersSummary How to identify system accounts like FUSION_APPS_SEARCH_APPID from per_usersContent Hi Is there a way to query and get a list of system accounts like FUSION_APPS…Manish Mohan-96908 54 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…