BI Publisher Reports
Discussion List
-
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…
-
Can we customize supplier Qualification invitation worklist notificationSummary: We have a requirement where we need to change the text in the notification body for the Supplier qualification. After creating the supplier, the user will initi…Vijay Bhaskar Koti 33 views 2 comments 0 points Most recent by Vijay Bhaskar Koti Supplier Qualification Management -
How to create UNSPSC reportsSummary How to create UNSPSC reportsContent We have client requirement to setup the UNSPSC codes structure along with the commodity (category) codes in Oracle Procuremen…
-
Unable to view Processed Orders by BuyersSummary: System is throwing an error while opening the analysis 'Processed Orders by Buyers' Content (required): Hi, when I am trying to open the analysis 'Processed Ord…
-
Report for Services not yet received similar to Goods received not invoiced reportSummary: Which Report for Services not yet received similar to Goods received not invoiced report is available in BI Analytics Content (required): Version (include the v…Michelle Reid 71 views 4 comments 0 points Most recent by Thinlay Nono Wangchuk Inventory Management
-
Tax Codes for requisition and purchase orders lines / distributionsSummary: I am trying to construct a sql query to pull back details of tax_codes used on purchase orders (draft) and requisitions (unapproved) at line / distribution leve…
-
Missing Blanket Purchase Agreement information in tableSummary Missing Blanket Purchase Agreement information in table PO_HEADERS_ALLContent Hello, The Blanket Purchase Agreement PDF Report that I am working needs to show th…
-
What is the database field/column for PO Charge Account?Summary: Our client would like the PO Charge account/distribution to appear on the PO PDF template. We did not find it in the seeded data model, which means we would nee…Farah Zekria 11 views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing -
why "View PDF" button disappears when a BPA change order pending for approval ?Summary: Content (please ensure you mask any confidential information): when search agreement and click change order no. (pending for approval), it shows the change orde…
-
we want to know the maximum characters length supported in the Purchase Order PDF ReportSummary: We are not able to find the maximum characters size that is supported in the PO PDF Report which is generated using RTF Template(PurchaseOrderLayout.rtf). Purch…
-
Custom Purchase Order layout only working when PO in 'Incomplete' statusSummary Custom Purchase Order layout only working when PO in 'Incomplete' statusContent Hi, we've created a custom PO layout and data model. We linked it to the business…
-
Can cost center manager view all PR/PO charge to the cost center?Summary: Content (required): Can cost center manager view all PR/PO charge to the cost center? Either by viewing on the web or from report? Version (include the version … -
What is the database table and column for the PO requestor field on the manual POSummary: We have created a PO manually without a PR and provided Requestor information. We would like to know where this information is stored in database, in which tabl…
-
How to list all changes made against a BPM rule in given time period?Summary: How to list all changes made against a BPM rule in given time period? we are referring to table POR_AMX_RULES but it doesn't have changes made against any condi…
-
Limit Purchase order draft pdf from going in approval mailsSummary: Requirement is to limit users/approvers from seeing the draft of PO PDF. though, final pdf should go to supplier when PO is in open state. Content (required): T…
-
PO attachment not shown via custom data sourceHI Team, Initial issue was: We are running PO BIP report where we added a new custom data set in the data model that uses the Oracle Content Server data source URL (FA_U…Kalpesh Salunke-Oracle 22 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Purchasing
-
how to pull PO Line level distribution accountSummary: how to pull PO Line level distribution account Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippe…