(ORA-04063:view "Apps.AP_RECURRING_PAYMENTS_V" has errors) when inquiry Recurring invoice

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: (ORA-04063:view "Apps.AP_RECURRING_PAYMENTS_V" has errors) when inquiry Recurring invoice

Symptoms:
Invoices:entry:Recurring Invoices then Ctrl f11 to Inquiry existing recurring Invoices ,an error message displayed (ORA-04063:view "Apps.AP_RECURRING_PAYMENTS_V" has errors)
Log files:



Solution:

The table AP_RECURRING_PAYMENTS_ALL, from which the column pay_awt_group_id is retrieved for the view AP_RECURRING_PAYMENTS_V, does not include a column called pay_awt_group_id.

The cause is justified by the fact that on querying the table AP_RECURRING_PAYMENTS_ALL on
customer's instance, it shows that the pay_awt_group_id does not exist.

1) Please download and review the readme for Patch.7575211.
2) Please apply Patch.7575211 in a test environment.
3) Please confirm the following file versions:
apcinreg.ldt 120.8.12000000.3
You can use the commands like the following:
strings -a $AP_TOP/patch/115/import/US/apcinreg.ldt | grep '$Header'
4) Please retest the issue.
5) If the issue is resolved, please migrate the solution as appropriate to other environments.

References:


Reference Note 872772.1 R12 AP_RECURRING_PAYMENTS_V Invalid After Applying Patch 8627216:R12.AP.A

Get Oracle Certifications for all Exams
Free Online Exams.com