Business Intelligence
Discussion List
-
Attribute fields/columns are missing in PVO PurchasingDocumentLineExtractPVOSummary: Attribute fields/columns are missing in the PVO. We need to extract a field in the PO Lines called "Sustainability Purchases". We presume this is one of the Att… -
How to increase the size of attachmentSummary: Business requirement is to add a video in a negotiation that would at least be 7.5 GB in size. I tried in the profile option (FND_FILE_UPLOAD_MAX_SIZE) to chang…RogerAlbelar 41 views 1 comment 0 points Most recent by Ed Gomez-Support-Oracle Subscription Management -
The meaning of "Out of scope for V1" mentioned in documentation of OKC_K_HEADERS_ALL_B table schemaHi, Can anyone explain the meaning of "Out of scope for V1" mentioned in documentation of contract header table OKC_K_HEADERS_ALL_B schema? For example, for column ORIG_… -
Which criteria (OTBI Subject Area) need to create a report for identify slow moving itemSummary: Which criteria (OTBI Subject Area) need to create a report for identify slow moving item Content (please ensure you mask any confidential information): How to i… -
Feasibility to have a notification for internal user that supplier has been createdSummary Feasibility to have a notification for internal user that a supplier has been successfully createdContent Hello experts! We have a scenario that internal user wi…Jennica M Pedro 45 views 3 comments 1 point Most recent by RenganathanVenkatesan Supplier Qualification Management -
Find duplicate customer/org. tax registration numbers ReportSummary: I need to create a datamodel with SQL so I can create reports that helps me find customer/org. duplicate registration number (TAX) So I can see what customers I… -
How does data get into OSS_BI_SNAPSHOTSSummary: How does data get into OSS_BI_SNAPSHOTS or the other snapshot tables? Is there any ESS job needed to be run? Content (please ensure you mask any confidential in…Debanjan Dey 21 views 2 comments 0 points Most recent by Ed Gomez-Support-Oracle Subscription Management -
BICC Extracts: how can i find out what attributes are used for each of the fields in the data storesI am looking to find out what attributes are used for each of the fields extracted within our BICC Extract data. Our data reporting teams need to understand if a field i…Tracy Collins 1 view 1 comment 1 point Most recent by Prabha.R Oracle-Oracle Reporting and Analytics for SCM -
How to get data access for a specific user through the REST APISummary: Through the REST API, we need to obtain from a given user which BUs are granted and what roles are assigned. We need to retrieve these details depending on the … -
Can we set PO printout to be opened in browser instead of downloading to local ?Summary: By default setting, when clicking "View PDF", the file is downloaded to local automatically. Is there any setting I can perform such that the file would not be … -
Count for User Created WatchlistsCan a count be enabled for user created watch list? Users are creating saved searches in the Process Requisition lines task screen in the purchase order Module to manage… -
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 52 views 5 comments 0 points Most recent by Maalavica Reporting and Analytics for SCM -
PO PVO data stores does not have DFF attribute columns, what correct data store to use?Summary: Hi all, We are extracting data using extract data stores for Procurement and we have some values needed that are from PO header DFF columns, but the data stores… -
Oracle table name to fetch all Supplier Profile Change Request DetailsSummary: We have requirement to build report with below columns. 1. Supplier name 2. Supplier account number. 3. Date of account update- Initiated 4. Account update- Dat… -
On Hand Quantity of Item In purchase order and Purchase RequisitionSummary: Hello, We have a requirement where the client wants to see the on-hand quantity of the item in the purchase order and purchase requisition line for any items or… -
Data glitch for Draft contractsHi Team, We have tested a scenario by amending an existing contract, which creates a draft version, and we have deleted the draft contract & verified the Backend tables,… -
Inconsistent Branding Image on RTF and downloaded versionSummary:Hi Team, I am attaching the offer letter template and the image shared by the customer could you please add to the front page and guide me on how it was added. A… -
How to enable line of business users to search and view purchase agreements informationSummary: Content (please ensure you mask any confidential information): Customer is asking for how non procurement agents can search for POs, Agreements and Suppliers. T… -
Report to get the users who has who has enabled the Multi Factor authentication(MFA)Summary: HI, we want to know is there a way to retrive the number of users who's MFA has been enabled ? From IDCS side and Fusion side as well. Content (please ensure yo… -
How to set up Page number in the rtf file to start at page 3 skipping the first 2 pagesSummary: We need to have the page number in the offer letter PDF file to start at Page 3. Tried editing the rtf file and set up the Page number to start at 3 but upon ch… -
Which table stores the audit information of subscription bill linesSummary: Hi, We are currently updating the Usage Quantity field on a daily basis at the bill line level. We need to generate a report that shows usage for a specific mon…Mahendravarma Kopanathi 11 views 1 comment 0 points Most recent by Anil Fogat-Oracle Subscription Management -
Article Text Alignment is not showing as "Justify" in Contract Print Preview reportSummary: Customize the EC Terms Preview report from the BI Catalog > Enterprise Contract > Contract Terms Printing > Contract Terms Download and Preview Report. Go the C…Snehashis_Santra 13 views 1 comment 0 points Most recent by Aravinth Arunachalam-Oracle Enterprise Contracts -
OTBI Analysis report not fetching value type as 'Text'Summary: How to fetch text based value in OTBI Analysis report. Content (please ensure you mask any confidential information): Developed an OTBI report to display suppli… -
Not able to Expand Contract Header Detail in Enterprise Contract OTBI Subject AreaWe tried in multiple instances but the columns under Contract Header Detail is not expanding, it is loading but not showing up the fields under Contract Header Detail.Navkar Jain-Oracle 1 view 1 comment 0 points Most recent by Aravinth Arunachalam-Oracle Enterprise Contracts -
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…