Business Intelligence
Discussion List
-
How to retrieve data from Item 'History' tabSummary: I need to extract data from Item 'History' tab, like which Field(s) are Updated/Inserted with Old and New values and Date of action. If anyone having such sampl… -
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… -
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…
-
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…
-
Clarification on “Use Original Receipt Date” Behavior for Allocation and Issue TransactionsWe would like to confirm the product specification regarding the “Use Original Receipt Date” option in Inventory Organization Parameters. When the “Use Original Receipt …HIROYUKI_RAYWOOD-Oracle 1 view 0 comments 0 points Started by HIROYUKI_RAYWOOD-Oracle Inventory Management
-
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…
-
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 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 2 views 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration