Payables and Cash Management - EBS (MOSC)

MOSC Banner

payables invoice batches showing no invoices in R12 v 12.1.1

edited Jun 16, 2010 8:24PM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered
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...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center