Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12.1.1 upgrade - ame0047.sql taking long time

edited Feb 12, 2013 3:38PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered

Hi,
Upgrade to R12.1.1 issue.

There is a step in the R12.1.1 upgrade named ame0047.sql. It updates the table ame_temp_transactions. It takes close to an hour at our site. There are over 36 million rows in this table after the upgrade.

Can you identify the source of this table. If we need this much data, would it be possible to convert this worker to do parallel updates?

------------------------------------------------------------------------------------------------
Support found the following

This is a new table in R12.
AME_TEMP_TRANSACTIONS - This table holds information related to transactions processed by AME.

Ref: Oracle Approvals Management Engine Release Notes, Release 12.1.1 (

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

EBS LCM 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