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 rowsContent
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.