Data Table
Discussion List
-
Identifying the FTP upload errorsSummary: We are designing the FTP setup to load a large data set into the custom data tables and would want to understand if there is any possibility to notify the group… -
What is the Maximum numbers of rows in data table in CPQWe have a requirement where we are trying to put 7.5 million records as initial load in Oracle CPQ data tables and incremental data will be uploaded periodically. When t…Gautam Patil 26 views 2 comments 0 points Most recent by Rashmi Sinha- Support-Oracle Configure Price Quote
-
can we mask CPQ data table column to keep data confidential from other user who has access to tableWe have requirement for Federal customer we wanted to mask the data from CPQ transaction, to do that we have suggested to maintain the federal account details with mask …
-
Oracle CPQ Integration with SharePointCan Oracle CPQ Read Holiday Lists Directly from SharePoint Excel Files? We have a requirement to reference an Excel file stored in a SharePoint location, which contains …
-
Oracle CPQ Data table validationsOracle CPQ Data Table Validation Currently, Oracle CPQ data tables are manually updated by users. In one of our use cases, we require a Boolean column to be consistently…
-
Multiple rows insert in CPQ Data TablesSummary: Multiple rows insert in CPQ Data Tables Content (please ensure you mask any confidential information): I would like to insert multiple records at once using bmq…
-
Are there any limit of volume for the csv file in data table?Summary: I want to know the limit of line and volume for the csv file in data table. Content (please ensure you mask any confidential information): Version (include the …Ayami Fujita-Oracle 21 views 1 comment 0 points Most recent by Girish Kumar Reddy-Support-Oracle Configure Price Quote
-
Can we copy and Paste Row in CPQ data table?Summary: User need to always click on + icon and add all the column values manually. Else the need to Export and them Import whole file to add few rows. We need to know …Vaibhav_Shrivastava 12 views 1 comment 0 points Most recent by Dillon Witt-Support-Oracle Configure Price Quote
-
How long before files uploaded to FTP are reflected in the Data TablesContent (please ensure you mask any confidential information): I am trying to use CPQ's standard functionality to store a file on an FTP server and upload it to a Data T…Yusuke Shibuya -Oracle 31 views 1 comment 0 points Most recent by Denesh Kumar Configure Price Quote
-
How to setup user access to edit certain CPQ tables?Hello - We are looking to allow certain users through the use of groups to be able to edit data within certain tables. It appears that this capability is available in CP…
-
Synchronize Data Table Rows REST APII am currently using the /rest/v18/adminCustom{tableName}/actions/synchronize endpoint via Postman to update rows in a data table. Is it possible to upload a CSV file so…Poonkuzhali 42 views 3 comments 0 points Most recent by Ellen Beres, CPQ Product Mgmt-Oracle Configure Price Quote
-
File Size Limits for ImportSummary: I would like to understand the maximum and optimal limits for the number of records and the file size supported by the Data Table Import REST API ({{baseUrl}}/d…
-
Adding multiple rows in datatable using REST APISummary: As SOAP v1 is getting deprecated we are converting our SOAP API code to REST API. We have one SOAP API that inserts multiple rows into datatable. Is there any R…
-
Can we automate CPQ Datatable export/import between CPQ instancesWe have a usecase from the customer's team where a team of people updates datatable in CPQ non-production instance and production instance. Need automation/scheduler to …
-
Import Data Tables REST APISummary: {{baseUrl}}/datatables/actions/import API I'm trying to find out if it supports updating rows in a data table by sending only a subset of columns, rather than t…Poonkuzhali 22 views 1 comment 0 points Most recent by Girish Kumar Reddy-Support-Oracle Configure Price Quote
-
How to use multi select attribute an update in BMQL.Summary: We want to push the value of a multi select attribute into a data table using BMQL. Content (please ensure you mask any confidential information): results = bmq…
-
How to restrict migration capability without affecting the global search in datatablesSummary: If a user is created with admin access but not migration capability, they are not able to do a global search on the tables to see where all a SKU is referenced …SirishaR 52 views 7 comments 0 points Most recent by Dillon Witt-Support-Oracle Configure Price Quote
-
Maximum Number of files we can upload in SFTPSummary: For integration we need to upload 132 data table files together via SFTP to be loaded in CPQ, We want to know if it is possible to put all 132 files on the SFTP…
-
Sometimes our data tables get this orange symbols over the icons, what does this mean?Summary: Every now and then we get this orange symbol that displays over our data tables. It seems to come and go but it CPQ will put this on all the tables, not just th…
-
data table - how to put a condition on a row based on the value of an attribute in another rowSummary: how to put a condition on a row based on the value of an attribute in another row Content (please ensure you mask any confidential information): Hello, I have a…
-
Live Data Table Updates - Can't omit a columnSummary: We have a Live Data Table that receives regular updates via an automated file import task (push to CPQ's SFTP, it triggers an automated file import). This data …
-
I want cpq cloud data table export to go to two different target directoryHi, I want to export data table using Data Table Export Scheduler to export 2 data tables. There is already one data table is being scheduled to export. But I want to ex…Subburaj 21 views 1 comment 0 points Most recent by Derek John Dillon- Support-Oracle Configure Price Quote
-
Can we export Data table data using DataCube Integration?Summary: We are having some data in CPQ Data Table. Can we export this table to FTP folder or a database using DataCube integration? Content (please ensure you mask any …
-
innerElementCountThreshold error faced on updating Data tableSummary: Hi, We are updating one of our instance data table columns with some data through an action and we are facing below errors on the SOAP API call to update the CP…UpadhyayStuti 2 views 2 comments 0 points Most recent by Girish Kumar Reddy-Support-Oracle Configure Price Quote
-
column can be dynamic in single select picklist attribute?Hi Team, Description:There is one SSPL attribute where column names are listed out base on selected column, that column values need to show in another SSPL attribute fro…
-
Any REST API similar to criteria query of Delete API of CPQ Data TablesSummary: Hi, We are amid of a major optimization and as part of SOAP to REST conversions of all the data table API calls, we also want to optimize the delete call we are…
-
I want to create a data table for all products with todays list price and selling priceSummary: I want to create a data table for all products with todays list price and selling price so that I can export the records from this data table to an sftp server.…
-
how hard is to create a column last_update_date in CPQ Data table and default to current datehow hard is to create a column last_update_date in CPQ Data table and default to current date so that we can pull only recently changed rows from a data table. Please le…
-
how to insert rows in a cpq data table by using bmql in batch mode to run once every daySummary: Where to write the bmql code and how to trigger it every day to run so that it can insert rows in data table. Content (please ensure you mask any confidential i…
-
Is it possible to Update a Data Table using a commerce action?Summary: I would like to ask if there is a way to be able to update a data table using a commerce action/BML triggered by a button? For context, We have "prices" data ta…