My Oracle Support Banner

Error [Invalid Column Name] Occurs When Triggering a Price Guidance Analytic That Does Not Use 'Latest' as its Aggregate Type (Doc ID 2718877.1)

Last updated on OCTOBER 21, 2020

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 20 B Patch 3 and later
Information in this document applies to any platform.


On any transaction, when clicking a trigger action associated with a price guidance analytic with an attribute's Aggregate Type selected as anything other than 'Latest,' the following error displays:

Could not perform Action: <Trigger Action's Name>
Failed to calculate price guidance using analytics test. Root cause: Invalid column name.


 The environment was upgraded to version 20B or later.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.