Business Intelligence
Discussion List
-
What is the Rest API to read and update Assessment level Descriptive Flex fields?Summary: We have descriptive flex fields configured at the Assessment Level (POQ_ASSESSMENTS) in Supplier Qualification. We need the REST API to read and update one of t…Anirban Nandy 61 views 3 comments 1 point Most recent by Asit Rout-Oracle Supplier Qualification Management -
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made … -
LAST_UPDATE_DATE incorrect for PO_DISTRIBUTIONS_ALL - Creates issue for BICCC incremental loadsSummary: Has anyone faced th issue where the LAST_UPDATE_DATE is not being updated for PO_DISTRIBUTIONS_ALL/PurchasingDocumentDistributionExtractPVO even when the data i…Jahnavi-Oracle 21 views 2 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for SCM -
How can we automate our authorized signersSummary: We have a list of authorized signers that are allowed to sign contracts for each of our legal entities. Is there a way to systematically load a list of these na…Shannon Gruber 31 views 2 comments 0 points Most recent by Andreea Gel-Support-Oracle Enterprise Contracts -
need a query to fetch negotiation response details with price break informationSummary: Need a sql query to pull negotiation response details with price break information Content (please ensure you mask any confidential information): Version (inclu…SoumyaMukherjee03 422 views 1 comment 0 points Most recent by SoumyaMukherjee03 Reporting and Analytics for SCM
-
Supplier Negotiation PDF Report Table of Content Font changeWe would like to change the font for table of content in Supplier negotiation PDF. When we select TOC in RTF template and changed font to Calibri and uploaded the RTF in…
-
Need help locating "Trading Partner ID" fieldSummary: Need help locating "Trading Partner ID" field, to include in either BIP or OTBI reports. Content (required): Need help locating "Trading Partner ID" field, to i…Andrew_Schmitz 231 views 6 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM -
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t…Sunil Dabekar 230 views 3 comments 0 points Most recent by Viswanath-Oracle Reporting and Analytics for SCM -
How to enable line of business users to view purchase order informationSummary How to enable line of business users to view purchase order informationContent Business Case Line of business (LOB) users need to view purchase order details wit… -
how to join Subscriptions management and service requestSummary: Hi Experts, We have a requirement to get subscription headers details and SR line details in a report .I could not find appropriate join ,I tried to join asset_…
-
Migrate custom objects/page created via application composerSummary Need steps to migrate custom objects/page created via application composer (in a sandboxContent Hi Everyone, We need steps to migrate custom objects/page created… -
OTBIWe are working on OTBI in report and anlytics in Fusion, and in that there is a requirement to create below reports through OTBI analysis. PR cycle time Rate of emergenc…Priya Ranjan Jamuar 31 views 2 comments 0 points Most recent by Priya Ranjan Jamuar Reporting and Analytics for SCM
-
Display Item number with and without Part numbers and Manufacturer in Custom Onhand Inventory ReportSummary: The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers…
-
Contract Approvers comments on the approval notificationSummary: Want to either have a field of approver comments from approval notification on history tab or to get the table name which stores this info Content (please ensur…
-
Subscription PATCH Call not working for updating a value at subscription levelSummary: Unable to update value of attribute "XX_OSS_RemainingChillers_c" via REST API both via groovy. Getting error " Invocation of service URL used in connection fail…
-
How to modify Deliverables Sub templateHi, How can I modify the existing Deliverables Sub Template that can be found in Shared Folder/Enterprise Contracts/Transformation Template? I'm checking if I can add ad…lawrenzxce13 41 views 2 comments 0 points Most recent by Andreea Gel-Support-Oracle Enterprise Contracts
-
We are not getting correct data in status column in Enterprise Contracts -Contracts Real TimeSummary: We are not getting correct data in status column in Enterprise Contracts -Contracts Real Time, few contracts even though they are active its showing pending Acc…
-
Procurement DashboardSummary Out of Box Procurement Dashboard in Oracle Procurement CloudContent Hi Experts, I am looking for the Procurement Dashboard (out of the box (Update 20A)), have se…
-
Syntax for Item validationSummary: Syntax for Item validation during creation Content (please ensure you mask any confidential information): Version (include the version you are using, if applica… -
how to add dff to subject areaSummary: We are using some DFF's in Transaction History under Inventory and DFF and enable the same for reporting. There is no DFF's are available under this subject are… -
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 3 views 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…