Business Intelligence
Discussion List
-
Unable to see active business classification lookups in the OTBISummary: We need to see all our active supplier business classification lookups in the OTBI, But we were able to see few of them, When i check in the metalink found the … -
what are the extraction limits of the finder field in online reports?Summary: I need to know the character limit that can be sent to Bi Publisher Content (please ensure you mask any confidential information): I'm trying to extract the inf…Mari 31 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
Procurement contractSummary: Hi, We need to create a custom report in the Oracle procurement contract where can we fetch the front-end data - Monthly wise Please suggest the contract tables… -
Award Negotiation ExportContent Hello, Can we edit Award By Spreadsheet. Is there any report for this? If yes, where we can find the data model for this export. Thanks, Nishanth -
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 41 views 3 comments 0 points Most recent by Ivan Pena-Oracle Self Service Procurement
-
in which table is offset tax column present at supplier address levelSummary: I need to add a column including an information about 'offset tax' set-up into the Rep028 Supplier Data Attributes Report. From which table and column can I use…
-
How to use Opty Revenue fields in Contract Table template?Hi, I've downloaded the ECMTableVarFileSub.rtf to make some changes. In this file, we have the table called ChildRevenueTableTemplate. How can I use this table in my Con… -
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 …
-
Unable to find database tables for Manage Terms and Conditions SetupHi Team We have the requirement to use the terms and conditions created under manage terms and conditions setup but not able to find out the related table or lookup. ple…PradeepkumarsharmaGX 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
Custom Contract layout TemplateSummary: Hello I ahve created a custom layout for contract printing in Custom folder , alongwith the data model. But the custom layout doesnt show up in the 'Contract La…
-
23D Configure Contract Approval no longer displaying rejection reasons to contract submittersSummary: We have customized the contract approval notifications, but it appears as though the same notifications are used for approvals and rejections. Content (please e… -
Query for extracting documents attached to the contractSomeone knows the query or tables for extracting documents attached to the contract?
-
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…
-
What is the VO corresponding to the sourcing Table PON_BID_PO_NUMBERSSummary: Sourcing VO name is required to identify the awarded negotiation specific purchasing document (PO / Agreement) details. What is the VO corresponding to the sour…
-
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 23 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 21 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…
-
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…