Business Intelligence
Discussion List
-
Product Development Change Order Audit history reportSummary: Need sql or database tables to generate Change Order Audit history report Content (required): As of today, there is no decent Audit history report of change ord…Ankit.Mahajan 21 views 1 comment 0 points Most recent by Carlos Benassi Reporting and Analytics for SCM -
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 …
-
how to use a bind parameter in Supplier address DFF?Summary: We have a requirement to populate a DFF at Supplier address level with consecutive numbers increasing by 1 everytime a new address is created. For eg for Suppli…
-
How to stop Multiple email notification to supplier.We have requirement to send 1st notification to supplier for OSP PO but afterwords if any change on promised delivery date of OSP purchase order then those notification …
-
Finding interface values in final tablesHello everyone, can anyone help me? I'm having trouble identifying some fields that are loaded into the interface table to inventory transactions (INV_TRANSACTIONS_INTER…Ivan Torres NTTDATA 22 views 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management
-
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…
-
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 -
SQL for InterProject ContractsWe need to build 2 reports for InterProject Contracts and we need to know the relevant tables that can help us fetch the data - 1st Report: InterProject Contract Statuse…imranmoham 21 views 1 comment 0 points Most recent by Andrei Tapu-Support-Oracle Enterprise Contracts
-
BIP/RTF approval notifications customization best practicesSummary: I am wondering what all needs to be done to test a custom BIP/RTF approval notification. Content (please ensure you mask any confidential information): After de… -
Customize Supplier Contract Print Preview templateSummary: We need to print Legal Entity and Legal Entity Address in the Supplier Contract Print Preview template. I am aware the source data for this report is coming fro…
-
parameters required to run Contract Approval Report?Summary: We are customizing the contract approval notifications and would like to run the report to test the output, but the parameters are many and nonsensical. Content…
-
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 -
BIP RTF approval notifications add version descriptionSummary: I am attempting to edit the DM to include the version description for approval notifications using the new BIP/RTF approvals for contracts. Content (please ensu…
-
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… -
how to join Subscriptions management subject area and installed base subject areaSummary: Content (please ensure you mask any confidential information): how to join Subscriptions management subject area and installed base subject area We are trying t…Cnayyar-Oracle 12 views 1 comment 0 points Most recent by Nilesh Deshpande-Oracle Subscription Management
-
Which tables stores details of Import Activities created in Import Management Work Area?Hi, We are creating contracts using Import Management and we have a requirement to indeitify and extract all contract which are created from a perticular import activity… -
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 3 views 1 comment 0 points Most recent by Islam Bahgat-Oracle Reporting and Analytics for SCM
-
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 change PO title in BPM work list?Summary: In BPM work list, po approval comes as 'Approve Purchase Order 85000' we want a way to update the title like 'Approve 'BU NAME' Purchase order 85000' Content (p…
-
Subscription OTBI Subject Area- missing product_net_priceSummary: Need to bring the product_net_price for a subscription product in OTBI report using the Subscription Management realtime subject area Content (please ensure you… -
subscriptionwe need to add Entity initials in subscription reference number. currently its a number without having the Legal Entity value.Akhila.Allagadda 31 views 3 comments 0 points Most recent by Ofelia Vez-Support-Oracle Subscription Management
-
Corresponding PVO in BICC through which we can load the Fusion tablesSummary: Hi Team, We are trying to load the data from BICC PVO to below Fusion tables related to Purchase Orders using the Business Intelligence Cloud Connector. But we …
-
Contract ApprovalSummary: Contract Approval Based on Amount Content (please ensure you mask any confidential information): We are defining approval rule for Contract Approval based on Am…Priya Ranjan Jamuar 31 views 2 comments 0 points Most recent by Priya Ranjan Jamuar Enterprise Contracts
-
The notes entered in Contract Notes tab in Oracle, are they reportable via OTBI?Summary: The notes entered in the Contract Notes tab in Oracle, are they reportable via OTBI? Content (required): The Notes entered in the Notes tab in Oracle Contracts,…
-
Output for ESS job 'Import Requisitions' not visible to userWhen user is submitting ESS job 'Import Requisitions', he is not getting report output to view. Which role is required to view ESS job report output.
-
Need all Standard OTBI reports for Subscription ManagementSummary: We are currently looking for all Subscription Management Out of the Box Reports. However, not able to find it. So, requesting your kind coopeartion in this matt…Buzz_123456 31 views 1 comment 0 points Most recent by Claudiu Mindruta-Support-Oracle Subscription Management