BI Publisher
Discussion List
-
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 44 views 5 comments 0 points Most recent by Maalavica Reporting and Analytics for SCM -
Does anybody know why fields are not available to be shown on template for data modelSummary: Does anybody know why the data model may be correctly reading my 2 fields (source_document_id, txn_qty) but they are not listed in fields available in current d…
-
Inventory Transaction Detail BIP Report-30 Columns-Item with Serial Control Enabled-65K LimitationSummary: Hi Everyone, We have a requirement from business to build BIP report for the Inventory transactions which they track manually at present. There are around 30 co…
-
Import Error BICC JobsSummary: Hello Team, we are getting an error when importing the BICC Jobs from UAT to PROD and it is erroring with attached error. Tried manual creation and it is workin…
-
Parameter is not passing correctly to integration via HTTP(XML feed)summary: Hi I am trying to call integration using BIP with data model HTTP (XML) feed but it seems parameter is not going correctly in integration and getting one error …
-
Invoke REST endpoint Integration in BIP report BurstingSummary: HI Is it possible to invoke Integration BIP report bursting? if yes then please give information integration configuration ? Content (please ensure you mask any…
-
Conversion UOM columns From and To Code from INV_UOM_CLASS_CONVERSIONS Showing Interchanged ValuesHi, I have observed an interchanged outputs in column- FROM_UOM_CODE, TO_UOM_CODE in table INV_UOM_CLASS_CONVERSIONS. What could've been the cause of this? Regards, Mika
-
Where is Source Reference stored in the Review Completed Txns screen?Summary: In the Review Completed Transactions screen we have a ‘Source Reference’ column. I am unable to understand where this is stored in the sql base tables. Content …
-
Which Oracle table is used to store the valueProduct Line Description under Product Line InformationSummary: Hi @everyone Can anyone have any idea that which Oracle table is used to store the exact value of below Product Line Information in the backend and how it shoul… -
Bursting Customer Statement Report on basis of legal entity of the Business UnitSummary: We want to generate customer statement reports on basis of legal entity of the Business Unit. We are making change in the statement data set by adding the legal…
-
Adding Attachments to Extensible Work Order Traveler ReportSummary: We have a requirement to customize the Work Order Traveler report and hence were thinking we can use the 'Extensible Work Order Traveler Report'. But when we tr…Deepthi Suravaram 141 views 20 comments 0 points Most recent by Sumit Patil Reporting and Analytics for SCM
-
SQL Query to fetch Configure Negotiation Award Outbound Service in oracle fusionSummary: Content (please ensure you mask any confidential information): We required table to get the columns in the screenshot Version (include the version you are using…Chintan_KRishna973102 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Which SQL table stores the Transfer Order Receipt Distribution Journal EntriesSummary: I am aiming to write a report that joins the 'journal entry account' - pictured below, all the way to the INV_TRANSFER_ORDER_LINES table using source document n…MichaelV823 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Seeking guidance on SQL querySummary: Hello, can someone please advise how to transform this query in order to return only records where a combination of (esib.item_number, hp.party_name, and pltl.l…MichaelV823 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Audit Cancelled Reqs that were tied to an open Purchase Order at time of cancellationSummary: Is there a way we can write a query/check an audit file that contains history of all requisitions that were cancelled that were already tied to an open Purchase…MichaelV823 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…
-
Query to get Item Class Change HistoryHi, Recently, some items in OC PLM had their class names changed, and I need to write a query to retrieve both the old item class name and the new item class name. I att…Ramsha Zameer 41 views 4 comments 0 points Most recent by Shamsul_Wzd Reporting and Analytics for SCM -
Some users can not export pdf report when click view pdf button on PO or agreement screen.Summary: We are currently facing an issue in the production environment related to the "View PDF" functionality on the Purchase Order and Agreement screens. When certain…Ahmed Abdelhamid 44 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
What tables/views are related to REST API /itemUnitOfMeasureConversionsSummary: I need to confirm the data is being retrieved without exception, so I would like to create a report of the same data that the API should be fetching. Content (p…
-
Automating AGIS Invoices creation processHi Team We are trying to automate AGIS Invoices creation.OIC triggers the Transfer Intercompany Transactions to receivables.And after its trigerred we have created the B…
-
Seeking guidance on LISTAGG() functionSummary: Hello, could someone please guide on why listagg() is not working in the following query: Content (please ensure you mask any confidential information): Hello, …
-
How to undo LTR Direction that impact Data Model and Reporting BI AnalyticSummary: Hi everyone, I'm seeking help. Has anyone ever used the 'Force LTR Direction' option in an RFT template? I clicked it by mistake and can't undo it Content (plea…User_VJWD5 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 22 views 2 comments 1 point Most recent by ravikiran goda-Oracle Reporting and Analytics for SCM
-
Bursting Query errors outSummary: Report generated output in XML, but the bursting query errors out Content (please ensure you mask any confidential information): Waiting Time: 0.5 seconds Data …SukumarKondaveti 33 views 7 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 1.5K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Print Receivables transaction ReportHi team, We have requirement where for Germany we have to print AR invoice report in german and english language both. But when we run the schedule process 'Print Receiv…vikram khengare 11 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
How to get Node name and description from Manage Account Hierarchies: Specify NodesSummary: I need to get this value for a report, someone knows in which table this information is? Content (please ensure you mask any confidential information): Version …Diego Zegarra 23 views 1 comment 7 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany -
Tables for Audit Report Page Details that are under Tools Tab in UI PageSummary: We need to build a BI report that extracts the Audit Report Details under Tools tab as Shown in below image. Could anyone please suggest the tables that have th…Chandana Priya-Oracle 31 views 5 comments 0 points Most recent by Melissa Goodrich Reporting and Analytics for SCM
-
OTBI report to pull purchase order issued from each punchout and catalogSummary: OTBI report to pull purchase order issued from each punchout and catalog Content (please ensure you mask any confidential information): Hi Team, We have require…Nidhi Chhajed 11 views 2 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for SCM
-
Merge PO header attachment pdf and BIP report in Oracle Fusion.Hi Team, I have a requirement to merge multiple PDFs into a single PDF. Specifically, when clicking the View PDF button on the PO page, a BIP report is generated. Simult…