Retail Merchandising System (MOSC)

MOSC Banner

Concept of Purge in RWMS

edited Jul 9, 2013 1:15AM in Retail Merchandising System (MOSC) 3 commentsAnswered
Hi Team,

Please help with the concept of Purge in RWMS.

In Oracle Knowledge base I found the below.

What are the tables purged using purge_rwms_tables.ksh and how can purging be configured?
 In Oracle Retail Warehouse Management System (RWMS) release 13.2, new functionality was introduced with purge_rwms_tables.ksh, giving users the ability to set purges by table names and their retention periods.

The shell script calls the PURGE_RWMS_TABLES package, which looks at the data set up in PURGE_TABLE_SETUP table.

To purge data, set the PURGE_TABLE_SETUP.table_name, PURGE_TABLE_SETUP.aging_date_column and PURGE_TABLE_SETUP.retention_period with PURGE_TABLE_SETUP.purge_ind = 'Y'.

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