BI Publisher Reports
Discussion List
-
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 265 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 41 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_inactive 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…
-
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.8K 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… -
Unable to print pick splip to a printerSummary: Print Pick Slip report is ending in error while running with Printer as an output. Below are the details of error message from ESS jobs: Document delivery faile… -
do you know which table store the records of attached Contracts page Details in fusion?Summary: do you know which table store the records of attached Screen Details in fusion. Content (please ensure you mask any confidential information): Version (include …B.Anil 11 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Dynamic logo is not working in Disbursement Separate Remittance Advice FormatsHi Team, We have the requirement to display the dynamic logo on "Disbursement Separate Remittance Advice Formats" report and we have made the required customization in t…
-
Do we have data model or report for online messages in Sourcing.Summary: We have a requirement in which all the online message of Negotiations of specific buyers will be listed. The current printable page functionality provides outpu…
-
SQL Query to get PO Change and Approval HistoryI am building an audit report to get a clear view of the PO Changes and Approval History. There is not much that I can find and the query I am using does not seem to be …
-
What the impact after setup Receiving expense destination Budgetary Control Enabled = YesSummary: What the impact after set Receiving expense destination Budgetary Control Enabled = Yes Content (please ensure you mask any confidential information): Due to we…
-
Which table contains all the details of a negotiation rounds?Summary: I need to create a report with details of all rounds of a negotiation. such negotioan number , line, supplier , round-1 price, round-2 price, round 3 price, awa…
-
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…
-
How to identify the Fusion Cloud user, how he/she has login through (REST API/OIC/URL)Summary: We used FND_Session table to identify the user, who has been logged in to cloud. but this does not tell about, how the user has been logged in. Manually( URL lo…
-
Review Receipt Accounting Distributions Details OTBI ReportSummary How to pull OTBI data for details shown in Review Receipt Accounting Distributions user interfaceContent Does anyone know how to pull Review Receipt Accounting D…
-
Error in Email notification-FYI: Document (Purchase Order) XXXXXXXX (Requisition XXXXXX) ImplementedSummary: We found with the help of Oracle support team that this issue can be resolved by creating a custom role. But that solution works only if the custom role has the… -
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