Value Chain Planning - EBS (MOSC)

MOSC Banner

Why Archive Plan Summary inserts records in MSC_ITEM_INVENTORY_F table as order date on Sat and Sun

Why Archive Plan Summary inserts records in MSC_ITEM_INVENTORY_F table as order date on Sat and Sun .

We are facing issue in BI reporting , that we can see Safety Stock quantity on Saturday and Sunday only.

After archiving ASCP Plan data , then running Archive Plan Summary request , inserts data into MSC_Item_Inventory_F table.

SS calculated on Days bucket.

for E.g.

SS on

MON --- 150000

TUE --- 150000

WED--- 150000

THU--- 150000

FRI--- 150000


We observed that data has inserted with order date only on saturday and sunday. two records each day SS.

SAT---- 150000

SAT---- 150000

SAT---- 150000

SAT---- 150000

SAT---- 150000

SUN--- 150000

SUN--- 150000

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center