Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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.
Tagged:
0