Demantra Solutions - EBS (MOSC)

MOSC Banner

DM_SITE_CODE issue

edited May 1, 2019 5:01AM in Demantra Solutions - EBS (MOSC) 7 commentsAnswered

The DM_SITE_CODE in the “Sales Staging Table” (actually the
error version at this point) is not the correct structure and therefore all the
sales are erroring out when that data looks for a “match” in the Location
Table.

In the location table, you can see the correct structure in
the “DM_SITE_CODE” column – number/colon/number.  The next screen shot
shows the same data in the “T_EP_SITE” table (may or may not be the source for
the Sales Table process).  The structure and data match.

The 2rd screen shot is from the “Sales data error

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center