apps.ecx_transactions synonym changes after database 11g upgrade
VPC Team member opened this thread on behalf of the customer.
We recently upgraded our eBusiness Suit database from 10.2.0.4 to 11.2.0.3 with PSU 13343438. We noticed the synonym ecx_transactions in apps schema is now point to ecx.ecx_transactions table; in 10.2.0.4 database, it points to ecx.ecx_transactions_b table, we wonder which patch caused this change? Since we have pkg referencing it, can we change it back without causing any other problems? the upgrade note we followed is 1058763.1.
The difference between pre and post describe of ecx_transactions_b and a review of the sql that built it follows.
PRE
We recently upgraded our eBusiness Suit database from 10.2.0.4 to 11.2.0.3 with PSU 13343438. We noticed the synonym ecx_transactions in apps schema is now point to ecx.ecx_transactions table; in 10.2.0.4 database, it points to ecx.ecx_transactions_b table, we wonder which patch caused this change? Since we have pkg referencing it, can we change it back without causing any other problems? the upgrade note we followed is 1058763.1.
The difference between pre and post describe of ecx_transactions_b and a review of the sql that built it follows.
PRE
Tagged:
0