Upgrading From 11.5.10.2 to R12.1.3 and SQL Script jl8469071c.sql Has Been Running for More Than 7 H
VPC Team member opened this thread for the customer.
We are in the process of upgrading from 11.5.10.2 to R12.1.3 and currently the R12.1.3 patch is in progress and it struck at jl8469071c.sql for almost 7 hours. We looked at the sql and when run below sql's it doesn't return any data
SELECT /*+ ROWID(xte) */ xte.application_id, xte.entity_id
FROM xla_transaction_entities xte
WHERE xte.entity_code = 'JL_BR_AR_COLL_DOC_OCCS';
select count(*) from XLA_EVENTS xlae where xlae.created_by = -2005 and xlae.last_updated_by = -2005;
Regards,
Murali
We are in the process of upgrading from 11.5.10.2 to R12.1.3 and currently the R12.1.3 patch is in progress and it struck at jl8469071c.sql for almost 7 hours. We looked at the sql and when run below sql's it doesn't return any data
SELECT /*+ ROWID(xte) */ xte.application_id, xte.entity_id
FROM xla_transaction_entities xte
WHERE xte.entity_code = 'JL_BR_AR_COLL_DOC_OCCS';
select count(*) from XLA_EVENTS xlae where xlae.created_by = -2005 and xlae.last_updated_by = -2005;
Regards,
Murali
Tagged:
0