Process Manufacturing - EBS (MOSC)

MOSC Banner

Difference between GMD_RESULT and GMD_SPEC_RESULT table

edited Jun 9, 2011 9:29PM in Process Manufacturing - EBS (MOSC) 1 commentAnswered
Hi,

Can you anyone answer following questions.

1) What is difference between GMD_RESULT and GMD_SPEC_RESULT ?

2) Does system insert record in GMD_SPEC_RESULT for every record inserted into GMD_RESULT table ?

3) Which are other tables linked to GMD_SPEC_RESULT ?

4) Only link between GMD_RESULT and GMD_SPEC_RESULT is result_id but there is no index on result_id column of GMD_SPEC_RESULT table ? Is there any specific reason Oracle did provide the index ?

5) Can we create Index on result_id column of GMD_SPEC_RESULT ?

 

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 Process Mfg 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