Business Intelligence
Discussion List
-
PROCUREMENT CONTRACT REPORT CREATIONSummary: 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…Ranganathan Siva 1 view 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to find the length of a viewIntObjectSummary: How to find the length of a viewIntObject. Below is the code snippet. Need to find how many records this has returned, so we can avoid the while loop since the …Neelesh Varma 21 views 1 comment 0 points Most recent by Claudiu Mindruta-Support-Oracle Subscription Management -
Users with Purchase Analysis role have access to Supplier Subject areaSummary: Business wants users to have access to Procurement - Purchasing Real time subject area in OTBI. But granting the Purchase Analysis duty role enables access to S…
-
Can we have serial and parallel approval rule for same stage in Requisition Approval RuleCurrently as per Business Requirements, we have multiple BU's wherein in one particular BU the approval flow is serially and for other BU the approval flow is parallely.…
-
Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Neha Aishwarya 11 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
OTBI subject area for complex PO work confirmation dataCan someone help me identify the subject area in OTBI for work confirmation reporting? -
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 -
Looking for Requisition FYI notification Data model and report (ReqStatusFYI notification)Summary: We are interested in knowing if there is a data model or report available for the ReqStatusFYI notification. Due to the fact that we presently have the data mod…Shashikanth Kumar P-Oracle 104 views 1 comment 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement
-
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 42 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…