Retail Merchandising System (MOSC)

MOSC Banner

Deletion of record from SIT_DETAIL

edited Jul 15, 2015 2:11PM in Retail Merchandising System (MOSC) 2 commentsAnswered

I created a scheduled item maintenance for my item list, the itemloc_link_id is 1, below are the details,

  • Active on  effective date 11-Jun-15
  • Inactive on effective date 13-Jun-15
  • Delete on effective date 15-Jun-15

After setting up as above, sit_detail table had 3 entries as 'A', 'I' & 'D" respectively. I run the sitmain job from 10-Jun-15 to 16-Jun-15, records with status 'A' & ' I' were removed but the entry for delete remains in the table. is it possible to have records completely removed from sit_detail for itemloc_link_id 1?

RMS Version 14

Thanks in advance!

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