Oracle Learning Planning Prices -> Any alternates to get previous history from 'wlf_plan_records_f'

Summary

wlf_plan_records_f - does not keep date-tracked rows

Content

Hello,

Can anyone please help?

At the moment, the OLC table 'wlf_plan_records_f' does not keep date-tracked entries for the pricing rules IDs and whenever there is a change in pricing rules table 'wlf_pricing_rules_f', the corresponding pricing_rule_id overrides in wlf_plan_records_f table. It restricts to get a snapshot of prices as on a particular date with status of 'Draft'.

The standard joins are : wlf_plan_records_f.pricing_rule_id = v14668wlf_pricing_rules_f.pricing_rule_id

Are there any other ways to join wlf_plan_records_f table to get a snapshot of previous prices? Attached a screenshot if it helps.