You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need details of the sources of columns of MSC_EXCEPTION_DETAILS

Received Response
42
Views
7
Comments

Summary:

Need details of the sources of columns of MSC_EXCEPTION_DETAILS

Content (required):

We need to create a report on Planning Exception details and in the Tables and Views for SCM (oracle.com) for MSC_EXCEPTION_DETAILS we found there are a lot of generic type columns NUMBER1 .. NUMBER8, DATE1 .. DATE6, CHAR1 .. CHAR2 and written "This column indicates a number/date/string used in the exception. The value stored depends on the exception type."

So to create the report we need the exact sources for those columns for each exception type so that for each exception type we can join the proper table.column with this generic columns of MSC_EXCEPTION_DETAILS to get the full data that is displayed in fron-end for Planning exception details.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!