Technology Stack - EBS (MOSC)

MOSC Banner

Can we drop APPS_TS_SUMMARY tablespace and generate the data again (using adadmin, concurrent progra

edited May 17, 2016 5:05AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hi,

We lost one datafile from APPS_TS_SUMMARY tablespace and we do not have backup for it.

As per the documentation it stores summary information like Materailzed view and MaterailzedView log etc.

Can we drop APPS_TS_SUMMARY tablespace and generate the data again (using adadmin, concurrent program, plsql etc.)

I found, for example, there are two tables in this tablespace.

1.PA_PROJECT_ACCUM_BUDGETS , which can be populated by "PRC: Update Project Summary Amounts"

2.AP_LIABILITY_BALANCE, which can be populated by "Insert_AP_Liability_Balance"

Please suggest.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center