Business Intelligence
Discussion List
-
Procurement PRC DashboardI am looking for the Procurement Dashboard, have seen it in the Oracle demo environment. I am looking to enable it in our environment however I can't find any documentat… -
How to create an Inventory On Hand Balance report using OTBISummary On Hand Inventory Balance report using Oracle Transactional Business IntelligenceContent We've had some requests on how to put together an Inventory On Hand Bala…Lynn Warneka-Oracle_inactive 382 views 3 comments 5 points Most recent by Ankit.K Inventory Management -
How to Customize the Supplier Audit Report ?Summary: How to Customize the Supplier Audit Report ? Content (please ensure you mask any confidential information): Hello I did one Supplier Bank Account Change and aft… -
Is it possible to extract attachment type text field retrieving from Purchase AgreementsSummary: We have a requirement to extract text type field details from BPA line level to another system through BIP/API for integration?If yes please provide the table n…
-
BICC Public VO for PO Distributions DFFsHi Team, Do we have any Public VO where PO Distributions DFFs fields are available? The Purchasing Document Distribution PVO 'FscmTopModelAM.PrcExtractAM.PoBiccExtractAM…
-
How to use same PVO for full extract as well as incremental for different schedules in BICC?Summary: Hi Folks We have a requirement where we need to use same PVO for both full load and incremental load is this possible, if yes how can we do it?? Content (please…
-
Error on opening View PDF`Summary: Error on opening View PDF for a change order in Pending Approval status Content (please ensure you mask any confidential information): Error on opening View PDF…
-
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 51 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…
-
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,…