BI Publisher Reports
Discussion List
-
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… -
The Client is asking to build a report based on the bypass Approval transactions of the BPM workflowSummary: The Client is asking to build a report based on the bypass Approval transactions of the BPM workflow. (without Approval). Content (required): we need to build t… -
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 …
-
Need to display transaction details present under Review Production Transaction History ScreenSummary: I Need to display all the transaction details present under Review Production Transaction History Screen. Please let me know the table that stores Production Tr…
-
Is there any report to identify which users have been logged in past month?Summary: Is there any Audit report or OTBI report which would enable us to Identify which users have been logged in in past 1 months? Content (please ensure you mask any…
-
How to modify the alignment in the PO Terms and condition setupSummary: Term and condition pulling from the purchasing setup in PO PDF report but We needs to do the alignment changes as per the business requirement. Please let us kn…Thanigainathan R 11 views 2 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for SCM
-
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…Sushan Peiris 545 views 7 comments 1 point Most recent by Vrinda Mittal Reporting and Analytics for SCM -
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 41 views 2 comments 0 points Most recent by Vijay Bhaskar Koti Supplier Qualification Management -
E-Signature Data Model can't be modified to add LotAttributeDFF (Is there an alternative solution?)Summary: Our customer uses E-Signatures for the following in line transaction types: *Inventory Lot Update *Miscellaneous Transaction *Quality Inspection Disposition *Wo…Federico Elicetche 1 view 1 comment 0 points Most recent by Lynn Warneka-Oracle_inactive Inventory Management -
Vendor return reportSummary Availability of vendor return reportContent We would like to a printable template (like PO's) for returning items to vendors. We have got the confirmation of Ora…User_2025-01-28-02-43-26-951 67 views 3 comments 1 point Most recent by CaioMSMancini Inventory Management -
How to configure Process Payment Request to trigger custom DM for Disbursement Payment File Format?Summary: We have created a custom Data model and added custom template to Disbursement Payment File Format. Please help us to configure the Process Payment Request to tr…
-
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… -
planned service provider in transportation intelligenceHello can you please advise if there is a Planned Carrier (Planned Servprov) column in Transportation Intelligence or I am overlooking it? we are calculating a PTA % but…TatianaS 1 view 1 comment 0 points Most recent by Islam Bahgat-Oracle Reporting and Analytics for SCM
-
Configure setup for customizing seeded report "Award Approval Notification Report"Summary: We need to customize this seeded report "Award Approval Notification Report". We have made the changes as per the process but the Award approval notification is… -
Need a query to fetch Negotiation TemplateSummary: Hello, I'm trying to build a report to get the Negotiation Template names but I'm unable to find the table nor subject-area to do so. Can somebody help please? …
-
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…
-
how to add a fiscal document status field in OTBISummary: Hi, we need to add the field fiscal document status from shipping forms to OTBI, there is a away to do this? Content (please ensure you mask any confidential in…Alex Pagliarini - Ninecon 1 view 1 comment 0 points Most recent by Vignesh Rajendhiran-Oracle Inventory Management -
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…
-
How to cancel scheduled reports?Summary Steps to cancel the scheduled custom reportContent Hi All, Can somebody please help me with the navigation to cancel the scheduled custom reports in Cloud? Thank…MAHESH TALWADE 43 views 4 comments 0 points Most recent by Erica Williams Reporting and Analytics for SCM
-
Pick Slip Report ESS Job not sending Attachment for adhoc email address with Bursting enabledSummary: We have enabled bursting for Pick Slip Report ESS job but when trying to pass adhoc email address while submitting the ESS job, only Bursting proces is working …