EXTRA PAYMENT SCHEDULE LINES FOR INVOICES causing FRM-40202: field must be entered when we are querying some invoices in production 11i.AP.N

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    EXTRA PAYMENT SCHEDULE LINES FOR INVOICES causing FRM-40202: field must be entered when we are querying some invoices in production 11i.AP.N

FRM-40202: field must be entered when we are querying some invoices in production.

Those old invoices which are validated and accounted have source 'Manual Invoice Entry'.

Those invoices have got one extra payment schedule line having due_date,gross_amount,payment_priority,amount_remaining as NULL and PAYMENT_STATUS_FLAG = 'N'.

We do not have any idea how come system created these lines and how come above mandatory columns are null for them.

Solution:

create backup of AP_PAYMENT_SCHEDULES_ALL

delete from AP_PAYMENT_SCHEDULES_ALL
where AMOUNT_REMAINING is null
and GROSS_AMOUNT is null and
INVOICE_ID=&invoice_id;

Now query the problematic invoice and check whether invoice is displaying correct data or not.

References:

Refer BUG # 4939397 for more information on this

    

Get Oracle Certifications for all Exams
Free Online Exams.com