BI Publisher Reports
Discussion List
-
CREATE MISCELLANEOUS ISSUE AND RECEIPT BIP REPORTSummary: Hello experts, our client has a requirement to display Miscellaneous Issues through a BIP report, so we need the Oracle Fusion table names that store this infor… -
we have some queries in Landed cost related, Please give the clarification for below question?Summary: we have some queries in Landed cost related, Please give the clarification for below question? User wrongly create landed cost for a PO(663), we updated the cos…
-
Getting null response from erpintegration when making get callSummary: We are trying to fetch the process id detail from this integration, document does say that this operation is supported however we are getting null repsonse. Con…
-
gl_date in rcv_shipment_headerSummary: gl_date column in rcv_shipment_header Table Content (please ensure you mask any confidential information): Currently we have gl_date as blank in rcv_shipment_he…Akancha Sinha 11 views 1 comment 0 points Most recent by Arun Yadav - Support-Oracle Inventory Management -
Can we customize the Inventory BIP reports grid and save the view for the user?Summary: Need the ability to customize the grid and query, then save the layout so it is available as a favorite layout. Content (required): Version (include the version…Hrishikesh Dahane 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How can I modify the Electronic Record for Inventory Miscellaneous Transaction Report?Summary: I need to add the Reference and Reason field to the RTF Template so that the approving user can make an informed decision without calling the user requesting th…
-
How to get subinventory and AvailableToTransact Qty of an item in an Org using webservice/BI reportSummary: Need to fetch Sub Inventory along with Available To Transact quantity of an item in an Org using webservice/BI report Content (please ensure you mask any confid…
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…
-
Cycle countSummary: Unable to find base table for BU association and vendor details for the Inventory Cycle Count Import template. Content (please ensure you mask any confidential …
-
How to get Miscellaneous Transaction Serial Numbers range if the serial numbers are consequetive?Summary: I have some report requirement to get the transaction serial numbers as: serial_from, serial_to, and range. The only source table I have is the serial number on…
-
Oracle SCM reportsWe are implementing Oracle Inventory, Cost accounting, receiving and product management. Would like to now existing reports from the application and OTBI. please can you…
-
Is there any option to run sql for bulk data export (Inventory movement, Sales Order details etc)Hi, Is there any option to run sql for bulk data export (Inventory movement, Sales Order details etc) for one year. We are using reports but it is not working due to tim…
-
query for inbound quantitySummary: From which table we can fetch inbound and receiving quantity coming up in inventory management->manage item quantities
-
Can we create 2 User Defined Dependent List of Values for ESS Job Parameter?Summary: Need to create an ESS job for a BIP report and a parameter will get autopopulated based on value we select for other ESS Parameter on which the parameter is dep…User_U3NQ3 132 views 14 comments 1 point Most recent by Prasanth Senthivel-Oracle Inventory Management
-
Oracle fusion database table for Context based DFF segment API namesSummary: We need to extract API names of context based serial numbers DFF attributes from database table. However, we can't figure the appropriate table which holds thes…
-
Deep link for lines to be PutAwaySummary: I have one report that allows all the receipt lines to be PutAway. I would like to click on Receipt Number and then the window of the PutAway will be open using…Giuseppe Galluzzo 51 views 4 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
Not able to find backing Requisition number field for Transfer Order in OTBISummary: Not able to find backing Requisition number field for Transfer Order in OTBI Content (please ensure you mask any confidential information): We are creating an O…Akancha Sinha 21 views 1 comment 0 points Most recent by Akancha Sinha Reporting and Analytics for SCM
-
STOC REPORTIs there a standard report that shows stock by organization, subinventory, locator and lot and other similar things? The Manage Item Quantities query does not allow expo…
-
Is shipment Hyperlink is possible in BIP reports.Summary: In the BIP report, Once the user clicks on the shipment number it should take to inventory Manage shipment page in display mode. Please confirm . .Content (plea…KOTTHURI ASHOKBABU 21 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Inventory Management
-
Which tables have review completed transaction data?Summary Hello , I want to know that which table have review completed transactions data . if any have query and know the table name please guide me. Kindly check the att…
-
E-Signature Data Model can't be modified to add LotAttributeDFF (Is there an alternative solution?)Summary: Our customer uses E-Signatures for the following in line transaction types: *Inventory Lot Update *Miscellaneous Transaction *Quality Inspection Disposition *Wo…Federico Elicetche 1 view 1 comment 0 points Most recent by Lynn Warneka-Oracle Inventory Management -
Vendor return reportSummary Availability of vendor return reportContent We would like to a printable template (like PO's) for returning items to vendors. We have got the confirmation of Ora…
-
how to add a fiscal document status field in OTBISummary: Hi, we need to add the field fiscal document status from shipping forms to OTBI, there is a away to do this? Content (please ensure you mask any confidential in…Alex Pagliarini - Ninecon 2 views 1 comment 0 points Most recent by Vignesh Rajendhiran-Oracle Inventory Management -
Print Receipt traveler report is not triggeringSummary: when we are creating expense destination receipts the Print Receipt traveler report is not triggering. For inventory destination receipts was triggering automat…KOTTHURI ASHOKBABU 11 views 1 comment 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
Pick Slip Report ESS Job not sending Attachment for adhoc email address with Bursting enabledSummary: We have enabled bursting for Pick Slip Report ESS job but when trying to pass adhoc email address while submitting the ESS job, only Bursting proces is working …
-
Movement Request line - Status and status date history information tableSummary: In the Movement Request line, we can find status and status date information in INV_TXN_REQUEST_LINES. If there is a change in status from approved to closed, w…Guthi Mallikarjun 312 views 1 comment 0 points Most recent by Hari Kurra-Oracle Inventory Management
-
Query to get the all the items and instrumental serial numbers.Summary: Content (required): need a query to get the all the items and instrumental serial numbers. Is there any thing like product_type='INST'? Version (include the ver…Guthi Mallikarjun 291 views 2 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Inventory Management
-
What is the Subject area can use to get Movement Request CountSummary: We need to get How many movement request are raised against specific inventory organization through the dashboard. We crated OTBI Using Costing- Cost Accounting…Navindu Amarasinghe 191 views 2 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management -
How to Identify dashboard reports / infolets from Oracle Fusion UI ScreenSummary: Identify dashboard reports / infolets from Oracle Fusion UI Screen Content (required): Hi, I have a requirement to identify the dashboard reports / infolets fro… -
Any confirmation or fix for translation and default layout for Period Inventory Valuation Report?Summary: Period Inventory Valuation Report - Translation & Template Issues (City Of Montréal) Content (required): Hello We did observe some issues with the Period Invent…