Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

CA_EMAIL_STG record

edited May 12, 2020 1:36PM in Enterprise Service Automation (ESA) - PSFT (MOSC) 2 commentsAnswered ✓

Hi,

It has come to our attention that record (table) CA_EMAIL_STG has close to 200k rows in our system. Trying to get some information about when this record gets populated but very little is available in PeopleBooks. Looking at the documents available in My Oracle Support it looks like in 2 cases some discrepancies in that record have been seen as the cause of poor performance when processing contracts amendments and the record should be clear after amendment completes.

Questions:

1. In what circumstances/ processes record CA+EMAIL_STG gets in use/populated

2. Are we safe to delete all the current data (rows) in that record assuming that they are there as a result of the issues in the past? We are in 9.2. Image 34.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center