Demantra Solutions - EBS (MOSC)

MOSC Banner

SALES_DATE in SALES_DATA is different from the date in T_SRC_SALES_TMPL after upgrade

edited Jul 21, 2015 10:00AM in Demantra Solutions - EBS (MOSC) 3 commentsAnswered

After upgrade of business modeler from Weekly to Monthly, we are noticing that the SALES_DATE.SALES_DATA is different from the date we collect form the shipment and booking history.

Example our fiscal month is 5/3/2015  and when we collect the shipment/booking history using the standard collection from EBS the date is 5/3/2015..however when we do a EP_FULL_DOWNLOAD there is no errors but the data in the sales_data is showing 5/1/2015 ( Gregorian dates) for these combinations.

I saw the FROM_DATE in the mdp_matrix for the combination is also showing 5/1/2015.

Question:-

1) We had truncated the data in the SALES_DATA before model was upgraded. Do we need to also delete the mdp_matrix (except the default combination) before we recollect the history ?

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

EBS Demantra Tags

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