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