Business Intelligence
Discussion List
-
query to get program name and program code in supplier channel managementIn Procurement, we have supplier channel management. Under this, we have manage supplier programs,. I need few details like program code, program name etc from this scre… -
Query Supplier Site Payment TermsSummary: Content (please ensure you mask any confidential information): Does anyone know what the SQL query is to pull the payment terms associated at the supplier site …
-
How to know what are the data accesses and priviliges needed to view a table from a BI reportSummary: I would like to know how I can relate permissions, data access, and privileges necessary to view a table. For example, I would like to know what permissions are…
-
Which column from REVISIONS table needs to be mapped to Document ID of Content server dataset?My goal is to read contents of file in UCM and append it to PO PDF. Currently, I am using DID column from REVISIONS table and mapping it to Document ID of Content server…
-
need a query to get the unit price of subscription invoiceSummary: need a query to get the unit price of subscription invoice Content (please ensure you mask any confidential information): Version (include the version you are u…Sai Divya Kolachana 21 views 4 comments 0 points Most recent by Sai Divya Kolachana Subscription Management
-
Perform Bulk Export feature in Enterprise ContractSummary: We have a requirement of exporting contract attachment in bulk, I read some oracle support note, it looks like as per this Bulk Export Contract Attachments (Doc…Sam Samaddar 12 views 1 comment 0 points Most recent by Alexandra Rabaea-Support-Oracle Enterprise Contracts
-
After a change order is created, is there a table where previous versions of taxes are stored?We are trying to create a report for when a change order is created in the Purchase Order (PO) to change the tax and it gets approved. We want to see what the tax is aft… -
Error on the The contract owner role ID during the creation contractSummary: Hi , during the creation contract , I have the error : This error appeared right after i saved the setup i made on the party role, linked to the type of contrac…Michela A. Morgillo 32 views 1 comment 0 points Most recent by Andrei Ursachel-Support-Oracle Enterprise Contracts -
how to Setting Up an Automated Contract Lines Descriptive Flexfield based on Contract Type?Summary: Hi , I added a new Context with the Sensitive Segments in the Contract Lines Descriptive Flexfields: But , after the deploy these flexfields don't visible on th…Michela A. Morgillo 11 views 1 comment 0 points Most recent by Anil Fogat-Oracle Enterprise Contracts
-
Approval history (Pending and Approved) report for ContractsDear All, We are looking to get approval history for approved and pending contract approvals. I am trying to use the below table but could not get the proper output as I…
-
The contract don't visible the flexfields added on the contract lineSummary: Hi , I added the flexfields on the Descriptive Flexfields :contract lines . But after deploy , these flexfields they are not present in the contract lines. How …Michela A. Morgillo 41 views 3 comments 0 points Most recent by Daniel Bossier-Oracle Enterprise Contracts
-
Subscription metrics in the prebuilt reportSummary: Could you please guide me on where I can locate the prebuilt reports for subscription metrics? It would be helpful if you could provide the documentation and a … -
Data on Site Address level of Transaction Tax is not being reflected on ZX_PARTY_TAX_PROFILEHello, We are trying to create a Supplier report with both Profile and Address level details. Two of the fields we need to fetch in the report are PROCESS_FOR_APPLICABIL…
-
Remaining un invoiced customer contract line QTY (Item based)Summary: I have created contract line type (item based) and insert an item, Qty and unit price, I created event item based and insert qty and unit price as contract line…Ahmed Mahrous Mohamed 11 views 2 comments 0 points Most recent by Ahmed Mahrous Mohamed Enterprise Contracts
-
Can we create multiple custom subscription preview templatesSummary: In Subscription Management, when you open a subscription and you look at it in the Summary - Overview page, you can use the Actions menu and select Preview. Thi…Shahul 11 views 1 comment 0 points Most recent by Andrei Tapu-Support-Oracle Subscription Management
-
How to set up Autoapprove rule in ContractsApproval in BPM?Summary: Hi , I set up the rule in ContractsApproval on the BPM. The rule must Autoapprove the enterprise contract , in attachment the screenshot: But it doesn't work, h…Michela A. Morgillo 45 views 10 comments 0 points Most recent by Alexandra Rabaea-Support-Oracle Enterprise Contracts
-
How do I see the Flexfield Contract headers created in the enterprise contract overview?Summary: Hi , I have insert the new flexfield Contract headers for the enterprise contract overview, but after the deploy I don't see these flexfields. In attachment the…Michela A. Morgillo 11 views 3 comments 0 points Most recent by Ed Gomez-Support-Oracle Enterprise Contracts
-
Do we need to apply any localization patch for 24B upgrdationSummary: Do we need to apply any localization patch for 24B upgrdation Content (please ensure you mask any confidential information): Version (include the version you ar… -
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