Retail Merchandising System (MOSC)

MOSC Banner

ReSA Totals and Rules data migration

edited Jun 1, 2015 10:48AM in Retail Merchandising System (MOSC) 5 commentsAnswered ✓

Hi,

I need to migrate the totals and rules from one environment to another. How would I do that. The steps which I followed are as below.

1. Created a total in Source environment and extracted the data related to that total from the following tables.

SA_TOTAL_HEAD

SA_TOTAL_LOC_TRAIT

SA_TOTAL_RESTRICTIONS

SA_TOTAL_USAGE

SA_VR_HEAD

SA_VR_LINKS

SA_VR_PARMS

SA_VR_REALM

SA_COMB_TOTAL

SA_REALM

SA_PARM

2. Uploaded the data into the same tables in the destination environment.( Only thing I had to change was the realmID

After this I did total/audit through store day summary screen in GUI and I got the expected value popluated in the totals screen and my totals worked fine.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center