BI Publisher Reports
Discussion List
-
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 … -
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… -
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
-
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…
-
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… -
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…
-
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…
-
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… -
how to find the table name of rules applied to a negotiation like restrict to invited suppliersSummary:how to find the table name of rules applied to a negotiation like restrict to invited suppliers Content (please ensure you mask any confidential information): We…
-
Customer requires a quantity based blanket purchase agreement at header (commodity centric business)Summary: Looking for a solution to track BPAs where the deliverable is gross weight is spread (not-equally/not known) across multiple items. Need to be able to track the…
-
Need to know in which table the Draft Status of Purchase order is foundHi All, Could anyone please tell where can i find the table for Draft Status of Purchase Order if possible please provide the SQL query for Draft Status Navigation Path …
-
Segment values of Charge Account Description are not getting generated properly.Summary: How to achieve the complete value of segments of charge account description in PO notification report. Content (please ensure you mask any confidential informat…
-
Purchase Document Email ReportSummary: We customized Purchase Document Email Report template for PO as per process requirement. After that we modified small change in content of the template. However…
-
Purchase Order PDF reportSummary Auto genarated page numberContent Hello People, We are facing issue with PO PDF/ BPA PDF templates, where we are getting page numbers at bottom footer. We alread… -
How do I find the value set for ReqLineDimension.requesterIdSummary: Can anyone help me find where the Requester ID values are located on Oracle Cloud - highlighted in screenshot above. I am trying to confirm the name of the pers… -
SQL How to identify when a supplier in Oracle is changed from inactive to active ?Summary: SQL How to identify when a supplier in Oracle is changed from inactive to active ? Content (required): Procurement user needs a way to identify when a supplier …
-
In PO PDF Output, new line should always be in next page, if whole line does not fit in current pageSummary: We customized Purchase Order PDF Report. But we want new line should always be in the next page if whole line doesn't fit in the current page but not able to ac…