Oracle Metalink has created a very good note on how to use commerce transaction data in Configuration rules.
How To Query Transaction Data from Commerce Into a Configuration Rule (Doc ID 1660743.1)
But it has one important not-so-highlighted point which can be very useful for debugging purpose in Configuration rule. If you want to debug such kind of rule, you can specify your transaction id in context parameters key/value pair as below and it will set this transaction in context for your bmql query.
bsId=3489815
Some snippet from above metalink note:
To test the code in the debugger, get a transaction ID from an existing quote first. Then in the debuggers Context Parameters:field, enter the following key=value pair:
bsId = (your transactionID)
Example query code from metalink note. Here quote_process is a commerce process variable name.
How To Query Transaction Data from Commerce Into a Configuration Rule (Doc ID 1660743.1)
But it has one important not-so-highlighted point which can be very useful for debugging purpose in Configuration rule. If you want to debug such kind of rule, you can specify your transaction id in context parameters key/value pair as below and it will set this transaction in context for your bmql query.
bsId=3489815
Some snippet from above metalink note:
To test the code in the debugger, get a transaction ID from an existing quote first. Then in the debuggers Context Parameters:field, enter the following key=value pair:
bsId = (your transactionID)
Example query code from metalink note. Here quote_process is a commerce process variable name.
ret = "";
records = bmql("select quoteNumber_quote, quoteDescription_quote from commerce.quote_process");
print records;
for record in records {
ret = ret + get (record, "quoteDescription_quote") + " " + get(record, "quoteNumber_quote") + "|^|";
}
records = bmql("select _group_sequence_number from commerce.line_process");
for record in records {
print "_group_sequence_number: " + get(record, "_group_sequence_number");
}
return ret;
print records;
for record in records {
ret = ret + get (record, "quoteDescription_quote") + " " + get(record, "quoteNumber_quote") + "|^|";
}
records = bmql("select _group_sequence_number from commerce.line_process");
for record in records {
print "_group_sequence_number: " + get(record, "_group_sequence_number");
}
return ret;