Data Table
Discussion List
-
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 11 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 1 view 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
-
Table Driven Attribute Values in ConfigSummary: We are looking to control the definition of attributes and logic between attributes via data tables. Content (please ensure you mask any confidential informatio…
-
Rec Items rule is not getting fired.?We use advanced Recommended Item Rule to get the parts. The Recommended Item is working in Debugger, but not working on Model Configuration page.in debuggers we are gett…
-
how consulting data of datatables CPQ from external platformSummary: I need to obtain data from 2 CPQ tables by crossing the data. Content (please ensure you mask any confidential information): It is required to obtain data from …
-
Change the default selection for "Data with Delimiter" when importing a data tableSummary: Is there a way to change the default selection for "Data with Delimiter" when importing a data table to "MS Excel .csv format". All the Oracle documentation say…
-
How can I get the parts id in oracle cpq, when the parts is exported to csv ?In Oracle CPQ, I need parts csv export with part id. I am not able to export the parts to csv with part id. Thanks in Advance Surendra Kumar R
-
There's an automatic data table backup recurring?Summary: Data Table Backup Content (please ensure you mask any confidential information): Hi, there's an recurring data tables backup planned? From online help I see: Or…Domenico V 51 views 5 comments 0 points Most recent by Emmanuel Zambrano-Support-Oracle Configure Price Quote -
Is there a way to convert an attribute from a Single Select Menu to a Dynamic Menu?Summary: We have several attributes set as single select menus that should really be dynamic menus. Is there a way to convert the attribute to a dynamic menu without nee… -
CPQ | Return to Sales Cloud | Update Link to go to the Digital Sales OpportunitySummary: Hi @Everyone, Hope everyone is doing well! Related: CPQ - Fusion sales Integration Question: We have Return to sales Action button which is currently integrated…Amartya Pushp 21 views 1 comment 0 points Most recent by Sushmita Singh-Support-Oracle Configure Price Quote
-
CPQ Model upload through 3rd party IntegrationSummary: CPQ Model upload through 3rd party Integration Content (please ensure you mask any confidential information): Version (include the version you are using, if app…
-
Provide CPQ users access to data filtered based on a column value in data tablesSummary: We're looking to provide users access to data filtered based on a column value in data tables, so that a user can only access that filtered data and don't have …
-
Readonly access to screens in CPQ homepageSummary: We would like to have readonly access to all screens on CPQ home page to restrict editable access to all users in our higher instances. Currently we have show/h…
-
Data Table User Friendly Functionality PossibilitiesHi Everyone, I had a questions to see if the data table functionality can be expanded. I reached out to Support and they asked me to open a question here. 1. Is there a …
-
Is there a way to ignore duplicates when filtering in the data table in CPQ?Summary: Is there any way to ignore duplicates while we are filtering the data table in CPQ? Content (please ensure you mask any confidential information): Is there any …Dhileeban 11 views 1 comment 0 points Most recent by Dillon Witt-Support-Oracle Configure Price Quote
-
In data table, if we are storing Dates in a column, how can we provide validation for its Format ?Summary: In Data table we are actually storing dates to specify the validity of a record, but as multiple users upload the data, we want to ensure that if any user tries…Nilkant Sandipan Ingale 11 views 2 comments 0 points Most recent by bla-Oracle Configure Price Quote
-
how to automatically archieve the Data from DATA TABLE every monthSummary: Content (please ensure you mask any confidential information): Client is using one table which will be having Prices infromation for parts which will keep getti…
-
Can we restrict Deleting the records in data tables Edit AccessSummary: When providing access to multiple users, we would like to give them the ability to just add new records/ update the existing but not delete the records in table…Sravani3027 21 views 1 comment 0 points Most recent by Abdulquadri-Dauda-Support-Oracle Configure Price Quote
-
Automatically update a datatable from parts dbSummary: We have a parts integration from part master system. however this is loading the data into the CPQ Parts db. We would like to have a replica of this CPQ parts D…
-
Can we add >, < or = with a integer value in config variable value column in BOM item mapping table?Summary: Can we establish a row in BOM item map table where we can use config Variable name along with config value having any values after a ">" or "
-
How can we filter a product attribute based on a previous selection?Summary: Set Up a filter for a Product cart attribute Content (required): Hello, we would like to set up a filter for one of our attributes used during Product configura…
-
Is there any other way apart from Bulk Services download for Parts dataSummary: Is there any other way apart from Bulk Services download for Parts data, it takes more than 8 hours to download it Content (required): Is there any other way ap…
-
Can we use BMQL query where condition using case insensitive text comparing Data table column text?Summary: In Oracle CPQ cloud we have some data in data table column that has in different cases. so is it possible to query using bmql irrespective of the case of text a…
-
Get table row ID in CSV ExportSummary: When we get a table using REST API, we see a id for each row. Is it possible to get it in CSV export? I want to delete table data but my table does not have nat…