Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

How does FND_PRODUCT_INSTALLATIONS get populated for custom schema registered

edited Dec 17, 2014 10:08PM in Database Install/Upgrade/Opatch (MOSC) 2 commentsAnswered

Hello All,


Used Alert Manager = > System = > Installations to add a custom schema.

Noticed that fields "Product Version", "Tablespace", "Index Tablespace" and "Temporary Tablespace" are not populated.

How are these values supposed to be populated?

Only noticed today since we were troubleshooting the fact that some of our custom schemas do not have stats gathered on them (hence the notes I followed). We have registered custom schemas twice during the lifetime of the system - first on 11i n 2010, and second on R12 earlier in 2014. The custom schemas in 2014 were not getting stats gathered, so I followed the notes and registered one custom schema using  Alert Manager. This fixed the stats gathering issue, but I noticed that not all fields are populated in FND_PRODUCT_INSTALLATIONS, and I am not sure whether they are

Tagged:

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

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