Oracle Learning Planning Prices -> Any alternates to get previous history from 'wlf_plan_records_f' — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

edited Jan 28, 2021 10:13PM in Reporting and Analytics for HCM 2 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!