BI Publisher Reports
Discussion List
-
Interconnect Oracle fusion and Azure databasesSummary: We seek information to interconnect Oracle Application Fusion and Microsoft Azure databases. We need step by step process to connect these databases. Content (r…Sravana Pydimarry 32 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
Transaction Date (Parameter "param.p_date") shows up as prior day date for user but not for meSummary: Hello Forum-mates: A BI SCM report "Transaction Date" Parameter "param.p_date" expression is only showing prior date for the customer in accounting but whenever… -
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
Is there a way to dynamically update the column header names on reports when Name = Months?We have a report that displays monthly data with the Months as Column Headers. Currently, as a workaround, row 1 is displayed as Month 1, Month 2, etc. and row 2 is mont…
-
How to extract BOM explosion report for multiple items at one go?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
How to add the Supplier Site Attribute information to the Requisition PDF ReportSummary: I want to add the Attribute Information from the Supplier Site to the Requisition PDF Report. Based on the attachment from Doc ID 2595071.1 (RequistionPDF Attri…Hendra_innopia 32 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for SCM
-
work order fetch based on asset number and asset work center nameSummary: Hi Experts I want to create a BIP report to fetch work orders with parameters asset number, asset work center name, item number and work order work center name.…Sharmava 12 views 1 comment 0 points Most recent by Aravindan Sankaramurthy -Oracle Reporting and Analytics for SCM
-
PO Change order History TableSummary SQL/Table to fetch Purchase order change historyContent Hi, Can anyone please help me with the back end table/SQL to get the purchase order change history. I was…Sahil Makhiza 1.2K views 7 comments 0 points Most recent by Anjana Das-Oracle Reporting and Analytics for SCM
-
REST API services feature for Oracle BI PublisherSummary: We are trying to access BI report through rest API. When we try the Oracle BI Publisher REST resources using the following URL structure https://:/xmlpserver/se…Kannan Ranganathan 519 views 7 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
In which table we can find reference type for costingDear , Can anyone tell me which table i can find Costing reference type i cant find these check picture for reference ThanksMirza_Adeel 12 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
Need to get a report for PO's where we can filter by BU'sSummary Need to get a report for PO's where we can filter by BU'sContent Hello, Grateful if you can help on how to get a list of all GRN's for Received Shipments for a S…User_2025-02-05-12-20-44-163 37 views 5 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM -
How to schedule a job which will autogenerate a report on monthly basisSummary: We have a business requirement where we need to create a job that will automatically schedule and fetch the data from previous month on the first week of every …Gauri Lande 42 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
Is it possible to create new/custom infolets ?Content Is it possible to create new/custom infolets ? Version 19CCaio Zioli-Oracle 98 views 5 comments 0 points Most recent by Manishsrf7 Reporting and Analytics for SCM -
Is there a Rest API to fetch report (OBIEEE reports)Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Customising Purchase Order Data ModelSummary: How to customise the purchase order data model Content (required): The Line.NOTE_TO_VENDOR column appears in the PdfArchivePurchaseOrderLine dataset but not the…
-
Can we use decode or if-else in excel templateSummary: Hi Team, Can we use decode or if-else in excel template for BI report. If yes. can you please share sample example. Regards Nidhi... Content (required): Version…Nidhi Chhajed 174 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for SCM
-
Request to share solution to display SO Header attachment URL on BIP report output and download itSummary: We have a requirement to build a custom BIP report in Oracle Cloud ERP (SCM Module). If there is any attachment at Sales Order Header Level, then we want to get…Amit Sutar 51 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Report services are not working post 22A upgradeSummary: REST services related to OTBI are failing in the system which worked fine until the 22A upgrade. Content (required): One of them is 'runDataModel' which we use …Goutham.Manthri 21 views 1 comment 0 points Most recent by Goutham.Manthri Reporting and Analytics for SCM
-
In oracle fusion which table have Item Threshold QtyDear , I need item Threshold qty but i cant find a table in which they have. Could you please guide me where it is? For reference i attached a picture also ThanksMirza_Adeel 22 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM
-
How to run a customised seeded bip report from the Report and Analytics folder/catalog folder.Summary: Greetings, Team — Is there a way to make the 'Open' hyperlink button enabled for a customised BIP Report? We customised the PO PDF Report for two different clie…Sameer Malhotra 2 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
Convert DATE from UTC to EST in RTF template pdf ReportSummary: Hi All, I have created PDF report using RTF template, in backend I am using BI analysis and SQL queries in data model. There are many date fields in the report …Saurabh Muthiyan 416 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for SCM
-
Replicate Data in FusionSummary: We are looking for a tool or an app that can help us extract data from Oracle Fusion (Financials/SCM). Content (required): We currently create BIP reports to ex…sanjam1130 12 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
The BIP Catalog page search box is inoperable.Summary: I've been looking into it for a long time, but I've never figured out why the BIP catalog page search box doesn't work. I tried the same thing in multiple insta…Sameer Malhotra 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
OTBI/BIP catalog refresh/modified dateHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …Swapnil Kashid 93 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
How to print Current User name and time in RTF PDF reportSummary: Hi All, I am creating pdf report using Data Model and RTF template. I want to print current user who is running report and time when he ran the report in final …Saurabh Muthiyan 187 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
Ability to run BI report from Isupplier portalContent Hi Experts, We have built one custom report related supplier performance in BI. Requirement is Suppliers should be able to access the reports in iSupplier Portal…Venkatesh Periketi 35 views 2 comments 4 points Most recent by Sahil Makhiza Reporting and Analytics for SCM -
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 22 views 1 comment 0 points Most recent by Kelly Cooper-Oracle Reporting and Analytics for SCM
-
BI Publisher Report Parameters Performance IssuesContent Hi, We have created a report with 15 LOV parameters such as Business Unit, Supplier, Location based parameters, GL Tree based parameters, Buyer, Currency and GL …user10645928 6 views 1 comment 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM -
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…Fabricio Reis 83 views 1 comment 0 points Most recent by Fabricio Reis Reporting and Analytics for SCM
-
need query to get link between grants-->awards-->projects to gl_code_combination tableSummary need query to get link between grants-->awards-->projects -->project budgets-->working versions-->period accounts to gl_code_combination tableContent need query …User_2025-02-11-22-16-56-998 1.3K views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM