Thursday, August 30, 2012

Cannot Query an Upgraded Invoice Batch with Type QUICKDEFAULT

After upgrade to Oracle 12.1.3, user could not query certain invoice batch. We found that INVOICE_TYPE_LOOKUP_CODE for those batches was QUICKDEFAULT. I checked the LOOKUP_TYPE "INVOICE TYPE" and found that LOOKUP_CODE 'QUICKDEFAULT" has been end dated. So i searched metalink and found metalink note [ID 1340964.1]. We created SR as per metalink note advice and Oracle gave following sql to fix the issue

UPDATE ap_batches_all
SET invoice_type_lookup_code = 'STANDARD'
WHERE batch_id IN
SELECT batch_id
FROM backup_batch); 

The above statement has syntax error

No comments:

Post a Comment