Data Table
Discussion List
-
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 23 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 15 views 1 comment 0 points Most recent by Dillon Witt-Support-Oracle Configure Price Quote
-
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…
-
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 33 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 46 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 51 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 25 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 3 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…
-
Data Table Details - Upload LogsSummary: In what version was the Details tab on Data Tables introduced to Oracle CPQ? And, did the Release Notes indicate how this would change the overall site upload l…JFelberg 13 views 1 comment 0 points Most recent by Ganesan Viswanathan -Support-Oracle Configure Price Quote
-
Is there a way to capture who changed and what changed in user data table (audit)Summary: I know you can look at admin logs to determine who updated a User Data table and when it was changed, but is there a way to get more granular than that so that …Carol Schiffler 2 views 1 comment 0 points Most recent by Adrian-Support-Oracle Configure Price Quote
-
Import error - Record is incorrect because it has more or less data than the column countSummary: I am trying to import and modify existing data into a live data table in CPQ I have exported the data from the table And then only entered the value in one colu…
-
Generate DB sequence in CPQWe have a requirement to generate a unique ID for a class of products, this ID is selected from a predefined range and a checksum is concatenated at the end. To avoid du…
-
Concurrent CPQ Data Table Access problemSummary: We have a requirement where a same CPQ data table can be update through multiple sources mentioned below. Integration though OIC. CPQ inbuilt data table section…Atul Singh AV 21 views 1 comment 0 points Most recent by Emmanuel Zambrano-Support-Oracle Configure Price Quote