Payables and Cash Management - EBS (MOSC)

MOSC Banner

Record and report on Spoiled payments?

edited Jul 8, 2013 11:46PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered
Hi,

We are on 12.1.3.  Is there a standard report that displays spoiled payment batches?  Our AP team uses the Payment Register to report on payments created for SOX compliance. 

This payment register is based on ap_checks_all and reports actual checks. Spoiled and voided codes are located in the table IBY_PAYMENTS_ALL.PAYMENT_STATUS. Values for this column can be found here: select * from fnd_lookup_values where lookup_type='IBY_PAYMENT_STATUSES' .

For the following payment_status codes, these payment rows do not appear in ap_checks_all

REJECTED
VOID_BY_OVERFLOW
REMOVED_REQUEST_TERMINATED
REMOVED_DOCUMENT_SPOILED

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