OTBI
Discussion List
-
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 38 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 12 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 21 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…
-
Query to get blanket purchase agreements and all their detailsSummary: I can't find a query to get the Blanket Purchase Agreements for oracle cloud fusion report. Content (required): I need to get the Blanket Purchase Agreements in…
-
What subject area has access to PO Contract Terms Deliverables?Summary: Content (required): We would like to create a report that summarizes all PO contract terms deliverables and their status. Is there any subject area that would h…Joana Falcao 35 views 1 comment 0 points Most recent by Ed Gomez-Support-Oracle Enterprise Contracts -
Need Table or Subject area with "Assessable Value"Summary: We need to retrieve the information that is on column "Assessable Value" on the PO Lines. Content (required): Cannot find "Assessable Value" on any OTBI Subject…
-
Are there downloadable dashboards for Supply Chain Management modules?Summary: I am looking for downloadable dashboards like the ones created by Caroline Gladwin (please refer to link: OTBI Sample Dashboards - 1. How to Install and Configu…
-
OTBI Reports for BPA or CPA ?Summary: Role requiered to create either a BPA or CPA ? Content (required): Hello I would like to setup either a BPA or CPA , I think the process is 1.-Create a BPA or C…
-
Looking for Entity Relationship Diagrams (ERD) for Procurement modulesSummary: Looking for Entity Relationship Diagrams (ERD) for Procurement models Content (required): Hi, At times we need to use Database tables to find the information we…
-
Subject Area for PO Variance and PO Accrual?Summary: We are generating a PO report, and are looking to include the PO Charge, Variance, and Accrual accounts that are on each line. Subject areas seem to only show t…
-
Can user view reports on approval routing based on purchase categories?Summary: Users want to see reports on approval routing based on purchase categories. Content (required): Version (include the version you are using, if applicable): Code…