OTBI
Discussion List
-
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
-
We cannot download PO Pdf for all POs in Bulk. How can we download all POs pdf in one shotSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 23D Code Snippet (add any code snippe…
-
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 …
-
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…
-
Is there a way to Deep Link the master contract on a PO or CPA?Summary: Currently, at the header level of CPA/PO - the master contract is just a preview of the PDF and not exactly a link back into the contract itself. Is there a dee… -
Is it possible to change the subject/content of the email sent out to requestors on a PO?Summary: Currently, once a PO is implemented, the requestor on the PO lines will be notified via bell icon and email notification. Is it possible to update the email con…
-
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…
-
How can we get agreement amount changed in OTBI?Summary: We are trying to get Agreement amount changed from original document to the latest Revision History Content (please ensure you mask any confidential information…
-
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… -
is there any subject area to fetch Procurement Agents details like actionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Unable to download Purchase Orders via Oracle Visual builderSummary: Content (required): error message received The requested resource could not be found. (VBAFE-00107) The remote server returned an error: (404) Not Found. Please…
-
User should have Inquire access for one Bu and Transactional access for other BuSummary: User should have both Inquiry and Transactional role for one business unit but they should have only inquiry access for another business unit. For example user …
-
SCM – PRC: Finally Close POs Using Oracle Integration, 20 August 2020, 9 a.m PT - Submit QuestionsContent Submit your questions for the SCM – PRC: Finally Close POs Using Oracle Integration session to have them answered during the live event. Post your questions by p…
-
Receipt Adjustments ReportHi, Please let me know if we have any report to see Receipt Adjustments (Return To Vendor and corrections transactions) by REQ or PO (something like Receipt Adjustments …
-
How to add List of values via SQL for a Oracle BIEE ReportsSummary: We have developed a OTBI report with 90 fields and added some parameters to it. Due to limitations the report is fetch 25K records only so user requested us to …Lalitha Rani Seeram-Oracle 40 views 0 comments 0 points Started by Lalitha Rani Seeram-Oracle BI Publisher Learning Center
-
Some users cannot see infolet tab pages under AnalyticsSummary: Under Analytics, Although some users can see a few infolets, why are they not able to see infolet tab pages like General Accounting Infolets, Service Infolets, …
-
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 13 views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
How to fix the incorrect sorting of Purchasing documents?Summary: When going to manage agreements, our clients like to do a massive search of all of their agreements. Upon doing so, they like to sort the agreement numbers asce…
-
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…
-
Need to view who created and updated transactions.Summary: Content (required): In my organization, we want to find a way to view and analysis to know which user created or updated certain transactions such as AP Invoice…
-
List of standard Out of the box reports available for ProcurementSummary: List of standard Out of the box reports available for Procurement Content (required): Hello Experts, Please let me if any standard out of the box (Pre-built/rea…
-
Procurement - Procure to Pay Real TimeSummary Procurement - Procure to Pay Real Time not displaying the Receipt Numbers created against the POsContent Hi, We would like to create an OTBI report using the Pro…
-
Need Deeplinks for Requisition and InvoiceSummary: When trying to use the Requisition deeplink in OTBI analysis report, it's not opening the Requisition view details page. View Requisition Details (PURCHASE_REQU…Arunima Pandey 24 views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
Is there any standard report for GRN return ordersSummary: We need a report with GRN return orders with debit and credit records. Content (required): We need a report with GRN return orders with debit and credit records…
-
How to use distinct in the DFF value set querySummary: We have a requirement to add Line Manager DFF in the requisition line DFF for approval purpose. To get the unique values i am trying to use the Distinct functio… -
Does anyone have a sql to pull historic PO approvals/workflows?We have an audit request to provide the approval workflow for a change order last year. Since workflows are purged 30 days after completion, I cannot view this in ERP di… -
Deeplinks - How to use the return variable ?Summary: Deeplinks - How to use the return variable ? Content (required): Hello, I use this deeplink : ../fscmUI/faces/deeplink?objType=PURCHASE_ORDER_APUSER&objKey=poHe…
-
source table for last acceptable promised dateSummary: Unable to find details of last acceptable promised date (change from data) for PO schedule line . Content We have a requirement to present last acceptable promi… -
History of Requisition/ Negotiation view or download of attachment?Summary: Is there a way to get a history of a Requisition or Negotiation of the users who viewed the transaction or who downloaded a attachment of the requisition or neg…