BI Publisher Reports
Discussion List
-
How to Query the Available to Transact quantity of an Item in an inventorySummary: Have to fetch the Available to Transact quantity in BIP report. -
Need to give access to run OTBI purchasing reportsSummary: We were having a issue where a user is not able to run any OTBI reports created under custom/procurement/purchasing. We don't want to give any purchasing role/a… -
Invoking REST API/SOAP in BIP for Fetching available to reserve and available to transactHi Team, We need to retrieve available to reserve and available to transact , but we've observed discrepancies when querying through SQL. Our goal is to achieve this via…Lokesh P 32 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to include the substitute information in the Receipt Traveler Report?Hello, How to modify the "Receipt Traveler" report to include a new field to show if an item was received as a substitute? For example I am receiving ItemA which can be …
-
Not seeing 'Create Infotiles' button in sandbox and edit pagesSummary: Not seeing 'Create Infotiles' button in sandbox and edit pages Content (please ensure you mask any confidential information): Created a sandbox 'Page Template C…Viswanadham Sighakolli 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
How to create a custom parameter in "Receipt Traveler Report"There was an error rendering this rich post.Aline Teixeira 31 views 1 comment 0 points Most recent by Kavita Yetakuri-Oracle Inventory Management
-
Find link between sourcing scoring teams and evaluation stageSummary: Hello, I want the table name or query which stores the link or data of evaluation stage column with scoring team .i am attaching the screenshort below: Content … -
cost organization- inventorySummary: we are trying to build BIP inventory report, we need to add “Cost Organization”? is there any way ? For example in the case of PTO “Valuation Unit” the “Cost Or…
-
How to create automatic receipts for expense items ?Summary: How to create receipts automatically for expense items ? Content (required): There is a requirement to create automatic receipts for expense items ? Without Sup…Cesar Saveedra 171 views 6 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Inventory Management
-
Request for Details and References of INV_MO_PICK_SLIP PackageSummary: Please provide details of the INV_MO_PICK_SLIP package, including the specification and package body. Additionally, provide references to the packages used with…
-
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 22 views 1 comment 0 points Most recent by Sai Karthik Reporting and Analytics for SCM
-
Tables/View for Item and Asset Category to PO categoriesSummary: Tables/View for Item and Asset Category to PO categories Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to y…
-
Which table having PO's Ordered, Total Tax, Total detailsSummary: Which table having PO's Ordered, Total Tax, Total details Content (please ensure you mask any confidential information): Hi Experts, Would like to seek for your…
-
What is the key column for joining FND_BPM_TASK_B and PO_HEADERS_ARCHIVE_ALL?Summary: What is the key column for joining FND_BPM_TASK_B and PO_HEADERS_ARCHIVE_ALL? Content (please ensure you mask any confidential information): Hi Experts, I found…
-
On-hand quantity on a historical dateContent We have a requirement where we need to get the inventory on-hand quantities of items by day @ 11:59:59pm since Jan 1, 2021. Is there a standard report that can b…User_2025-02-11-12-16-08-273 679 views 3 comments 2 points Most recent by Becca Edwards Inventory Management -
Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIPSummary Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIP Report?Content I want to know if there any specific way in w…Renuka Soneja-154959 39 views 3 comments 2 points Most recent by User_KMKTM Reporting and Analytics for SCM -
Can't create dynamic hyper link in PO approval notification template.Summary: I am trying to create a hyper link that takes the po number () in the po approval template and pass it to a parameter in another custom report I created . That'…KirolosMagdy 31 views 1 comment 0 points Most recent by KirolosMagdy Reporting and Analytics for ERP
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 1.2K views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM -
LAST_UPDATE_DATE in PO_LINES_ARCHIVE_ALL is not updated when new change order is appliedSummary: LAST_UPDATE_DATE in PO_LINES_ARCHIVE_ALL is not updated when new change order is applied Content (please ensure you mask any confidential information): When a c…
-
How to create report future "approver details" of requisitions in "Pending Approval Status*Summary: Customer requests a report listing future approver details of requisitions with “Pending approval” status. Content (required): The intent is to answer questions…
-
Some users are not able to Download Custom PO PDFSummary: Some users are not able to Download the PO PDF and clicking View PDF. User have PO Buyer role but still not able to download. Below is the error: "The file was …
-
PO Work Confirmation report with Invoice detailsSummary: PO Work Confirmation report with Invoice details Content (please ensure you mask any confidential information): Can someone help me provide a sample report cata…