BI Publisher Reports
Discussion List
-
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):
-
Need help locating "Trading Partner ID" fieldSummary: Need help locating "Trading Partner ID" field, to include in either BIP or OTBI reports. Content (required): Need help locating "Trading Partner ID" field, to i…Andrew_Schmitz 43 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDMSummary: Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDM Content (required): Is there any possibility to update the Sales Order…Pandiyan 26 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for SCM
-
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 12 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 2 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 42 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 126 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 2 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…Yogesh Nemchand 29 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 24 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 48 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):
-
How to configure Process Payment Request to trigger custom DM for Disbursement Payment File Format?Summary: We have created a custom Data model and added custom template to Disbursement Payment File Format. Please help us to configure the Process Payment Request to tr…
-
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 15 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 14 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Need to send standard GL Trial Balance Report output to ftp server directorySummary: Customer has a requirement that the standard GL Trial Balcne report output will be uploaded directly to ftp server directory. There will be seperate file for in…
-
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):
-
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 2 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 3 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…User_HAXNL 2 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
In oracle fusion which table locations nameDear , Can anybody guide me in oracle fusion which table have location name. i tried to find but i cant. Kindly check the attached pic i need these column in table where…Mirza_Adeel 909 views 3 comments 0 points Most recent by Mirza_Adeel 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 4 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 2 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…User_HAXNL 2 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 4 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 3 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM