Business Intelligence
Discussion List
-
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 2 views 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…
-
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 12 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…
-
Table name or column name for fetching expense item totalSummary: Table name or column name for fetching expense item total Content (please ensure you mask any confidential information): Hi Team, we are trying to fetch the exp…Suresh Manchukonda 21 views 4 comments 0 points Most recent by Suresh Manchukonda Supplier Qualification Management
-
Request for Standard API/SOAP Service to Extract Subscription Billing Data with Complex FilteringWe are currently using a custom BIP report to extract Subscription, Product, and Bill Line data required for downstream invoicing and reconciliation processes. This repo…MouliK_Dell 31 views 3 comments 0 points Most recent by Arturo Macias-Support-Oracle Subscription Management
-
is it possible to update purchasing sitein purchase agreement using rest api/soapwe want to update purchasing site and order locally fields using rest/soap. Navigation: Purchase agreement - Manage Agreement - notes and attachment - controls
-
What is table structure of fa_fusion_soainfra.wftaskhistory?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Bursting Query errors outSummary: Report generated output in XML, but the bursting query errors out Content (please ensure you mask any confidential information): Waiting Time: 0.5 seconds Data …SukumarKondaveti 71 views 7 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 2.4K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM