My Oracle Support Banner

New Set_of_book_id Not Reflected in WEEK_DATA when Tsf_entity_id Changed for a Partner (Doc ID 2516518.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Merchandising System - Version 15.0.1 and later
Information in this document applies to any platform.


In Oracle Retail Price Management (RPM) 15.0.1, new set_of_book_id is not reflected in WEEK_DATA when tsf_entity_id is changed for a partner.

Steps to reproduce:
1. Create an External Partner with the tsf_entity_id = <TSF_ENTITY_ID1>, org_unit_id = <ORG_UNIT_ID1>.
2. The ledger will be created and in WEEK_DATA new lines will be generated with set_of_book_id  = <SET_OF_BOOK_ID1>. Also materialized view MV_LOC_SOB is refreshed.
3. After change the tsf_entity_id of the partner created to <TSF_ENTITY_ID2> and org_unit_id = <ORG_UNIT_ID2>.
4. No changes in the ledger. Week data will have always the old <SET_OF_BOOK_ID1> for current week and also for future ones.




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.