payables invoice batches showing no invoices in R12 v 12.1.1
hi all,
upon upgrading from 12.0.0 to 12.1.1, we suddenly encountered this technical problem in the invoice workbench screen wherein from the invoice batch screen, selecting 1 then click invoices button will show the list of invoices for that batch. then go back to the invoice batch screen and select another batch and click invoices button but this time will show no records even if the count says there are.
when i checked the SYSTEM.LAST_QUERY, there's a part in the WHERE CLAUSE which says batch_id = some_number and batch_id = some_other_number.
i.e.
WHERE batch_id = 1 AND batch_id = 2...
upon upgrading from 12.0.0 to 12.1.1, we suddenly encountered this technical problem in the invoice workbench screen wherein from the invoice batch screen, selecting 1 then click invoices button will show the list of invoices for that batch. then go back to the invoice batch screen and select another batch and click invoices button but this time will show no records even if the count says there are.
when i checked the SYSTEM.LAST_QUERY, there's a part in the WHERE CLAUSE which says batch_id = some_number and batch_id = some_other_number.
i.e.
WHERE batch_id = 1 AND batch_id = 2...
Tagged:
0