Business Intelligence
Discussion List
-
Notification email to Procurement Manager on pending requisitions and purchase ordersSummary: We have a requirement to send the list of Requisitions pending approval as a weekly email notification with few details such as ( Requisition Number Requester N… -
Multiple matching rows for a row of type:TradingPartnerItemRelationshipI am trying to create Trading partner Item relationship in oracle fusion using REST service '/fscmRestApi/resources/11.13.18.05/tradingPartnerItemRelationships' but gett…
-
Use order date for order pricing not available in OTBI subject areaSummary: Looking for 'Use order date for order pricing' flag in OTBI Analysis Content (please ensure you mask any confidential information): We have recently enabled fea…
-
Query to See the Approver Name on Whom a PO is Pending For ApprovalSummary Query to See the Approver Name on Whom a PO is Pending For ApprovalContent Most of the time we get an SR with requirement to see or extract on which approval lev…
-
Do you need FDI to create new KPIs in new Purchasing icon?Summary: Hi Oracle community, I am following this link regarding the new Purchasing Icon application on the Procurement tab on the Oracle Fusion Homepage Link: https://d…
-
Do you need FDI to create new KPIs in new Purchasing icon?Summary: Hi Oracle community, I am following this link regarding the new Purchasing Icon application on the Procurement tab on the Oracle Fusion Homepage Link: https://d…
-
how to restrict the employee to not request more than 2 requests for non catalog learning in VBSSummary: I Tried by this code and put it in action chain then associated with event listeners using vb enter but nothing happened define([ 'vb/action/actionChain', 'vb/a…
-
What tables will provide the Supplier Name and Tax Registration Number housed on Supplier Address?Summary: We house supplier VAT registration numbers under Supplier Address within Transaction Tax > Tax Registrations > Registration Number. What tables can be used to r…Dawn Tilson 1.2K views 5 comments 0 points Most recent by Radhika Agarwal Sundarlal Supplier Management
-
Oracle table name to fetch all Supplier Profile Change Request DetailsSummary: We have requirement to build report with below columns. 1. Supplier name 2. Supplier account number. 3. Date of account update- Initiated 4. Account update- Dat…
-
Oracle OTBI report for Award Negotiation (Award by Spreadsheet)Summary:What is the seeded Oracle OTBI report which equates to the on-line Award Negotiation (Award by Spreadsheet) Spreadhseet Content (please ensure you mask any confi…
-
Which privilege will allow to view PO and BPA information without license triggerSummary: Please let us know Which privilege will allow to view PO and BPA information without license trigger. We had a custom procurement inquiry role having PO_VIEW_PU…
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…
-
How to get the RTF tag name for Supplier contractSummary: How to get the RTF tag name for Supplier contract. Currently, I am customizing Supplier Contract seeded report. In the report, I want the role to be mapped. How…
-
Tables related to Associated Collaboration Documents under Supplier Site-General Tab.Summary: Hi, May i know the tables related to Associated Collaboration Documents under Supplier Site-General Tab, i order to create BIP report. Content (please ensure yo…
-
Clarification on Future Support for External Data Sources in BI Publisher for SaaS to OICIntegrationDear Oracle Community, We have a requirement to utilize the external data source configuration feature in Oracle Fusion Applications BI Publisher to establish connectivi…ReddyBashaShaik 31 views 0 comments 0 points Started by ReddyBashaShaik Reporting and Analytics for SCM
-
ORA-00932: inconsistent datatypes: expected - got CLOBSummary: I am building an audit report for supplier contract. I am attaching the query in the ticket. In the oldvalue session, when I am using note_txt column from ZMM_N…
-
MSC_SYSTEM_ITEMS table missing in BICC PVOHi CCC, I have a requirement to extract the MSC_SYSTEM_ITEMS table from BICC PVO. But, when I browsed through the BICC PVO documentation, I couldn't find it. Am I missin…VishnupriyaSelvakumar 1 view 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration
-
Need to Get a field from Subscription Tables OSS_PRODUCTSSummary: I need to Get a field from Subscription Tables, we are able to see a field 'Term' in front end at product level in subscription also we can see the field in the…Satyam Shandilya 41 views 3 comments 0 points Most recent by Siva Sankar Manne Subscription Management
-
Unable to find POZ_SPEND_AUTH_REQUESTS is raised for which multiple BUSummary: Hi Team, We are trying to build a SQL query to get the spend authrozied pending approval request along with BU details, table - POZ_SPEND_AUTH_REQUESTS provide …