BI Publisher Reports
Discussion List
-
-
Notification for Negotiation ClosedSummary: There does not seem to be a notification to the Owner of the RFQ (at least) if a Negotiation has reached its close date. Content (required): Hi, We were testing… -
what are the extraction limits of the finder field in online reports?Summary: I need to know the character limit that can be sent to Bi Publisher Content (please ensure you mask any confidential information): I'm trying to extract the inf…Mari 31 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
Reminder to suppliers with pending deliveries?Summary: Is there any scheduled process that sends a reminder to suppliers, on a weekly basis, with pending deliveries? Content (please ensure you mask any confidential …
-
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…
-
Procurement contractSummary: Hi, We need to create a custom report in the Oracle procurement contract where can we fetch the front-end data - Monthly wise Please suggest the contract tables… -
BIP Excel output removing zeros from decimalSummary: BIP Excel output removing zeros from decimal Content (please ensure you mask any confidential information): I have a BIP Data Model and Report with Excel (.xls)…KDR 11 views 4 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM
-
Award Negotiation ExportContent Hello, Can we edit Award By Spreadsheet. Is there any report for this? If yes, where we can find the data model for this export. Thanks, Nishanth -
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…
-
Need Tables for Cost Transactions Depletion Layer DetailsSummary: I'm looking for tables for Cost Transactions Depletion Layer Details as in the screenshot below. Content (please ensure you mask any confidential information): …Kunal Verma 245 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
PO change order - What Table Does Store Amount Changed Field ValueHi, In the po change order, I am trying to find the amount changed field value. Could you please suggest if anyone knows .
-
Scheduling the seeded "Purchase Order Report" to run for every two hoursSummary: Can the seeded "Purchase Order Report" be scheduled to run for every two hours so that it picks all PO's that are either created/updated in those two hour time …
-
Report from purchase to paymentSummary: Is there any comprehensive report with information from the request to the payment? That is, for each request line, indicating the PO, its status, invoicing, pa…
-
BUDGET_CONTROL_ENABLED_FLAG field is not available in the Purchase Order Data modelSummary: BUDGET_CONTROL_ENABLED_FLAG field is not available in the Purchase Order Data model Content (please ensure you mask any confidential information): Version (incl…
-
Additional Information (DFF) from Text Attachment not appearing on POSince the last Quarterly Update, we are experiencing an attachment related issue with purchasing documents. Additional purchasing information captured in Descriptive Fle…
-
SQL for Approved requisitions not generating PO'sSummary: SQL for Approved requisitions not generating PO's Content (please ensure you mask any confidential information): Hello Will you please share with me any SQL to …Cesar Saveedra 43 views 3 comments 0 points Most recent by Ivan Pena-Oracle Self Service Procurement
-
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
-
Please tell me the logic for calculating line item tax amount on POSummary: When creating BI, I need to understand the logic of each item value. In particular, I didn't know whether taxes were multiplied by LIST_PRICE, UNIT_PRICE by the…
-
Audit Report for Purchase Order ApprovalsSummary We are looking for a report which would show approval history for purchase ordersContent Hi All, We have built approval rules which span 2 to 10 levels. As part …
-
We want to provide a deep link in email to supplier for purchase order acknowledgementSummary: We want to provide a deep link in email to suppliers for purchase order acknowledgement so that supplier can click on the URL and PO acknowledgement page opens …
-
How can we archive all FYI email triggered to buyers when PO got approved?Summmary As per the standard functionality, buyers used to receive FYI email along with attachments when PO got approved. How can we archive those emails? Content (pleas…
-
how can we edit Supplier Negotiation report, it doesn't have Data ModelSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Where can I find the list of all seeded reports (OTBI and BIP) provided by OracleSummary: Where can I find the list of all seeded reports (OTBI and BIP) provided by Oracle for Procurement and Contracts? Content (required): Where can I find the list o…Asutosh Mishra 3.6K views 5 comments 0 points Most recent by SharathBiz Reporting and Analytics for SCM
-
Unable to find the table names where recent activity of negotiation work area are stored.We are trying to derive recent activities that are shown in Negotiation work area to reach number of activities performed on particular negotiation and their details in …
-
Granting access to PO OTBI reports based on requisition BUSummary: We have multiple requisition BUs(hotels) under one procurement business unit. Each hotel controllers now need to see a report of all their department heads POs …
-
The file was not downloaded or was not downloaded correctly (Change Order 7 only)Summary: Purchase Order PDF for change order 7 cannot be downloaded Content (please ensure you mask any confidential information): NOT an access/role issue. All users in… -
SQL Query Tax Rate of purchase Order At line levelDear All, I'm currently encountering an issue while attempting to query the tax of a purchase order at the line level. Upon inspection, I've noticed that the fields "tax…
-
PO_ACTION_HISTORY delayWe have an integration that utilizes the PO_ACTION_HISTORY table. We found, though, this table is delayed by minutes in getting populated. It's causing issues with POs n…