My Oracle Support Banner

R12: AP: Attempting to Compile the Invoice Workbench (APXINWKB) Errors with FRM-30064: Unable to parse statement select project_id, project_number (Doc ID 2655544.1)

Last updated on APRIL 29, 2020

Applies to:

Oracle Payables - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Form APXINWKB Compilation Fails With Error FRM-30064: Unable to parse statement select project_id, project_number

Symptoms

Try compiling Invoice Workbench (APXINWKB). It ends in errors

FRM-30064: Unable to parse statement select project_id, project_number, project_name, start_date, completion_date, project_type_class_code, project_number_sort_order, expenditure_ou org_id, mo_global.get_ou_name(expenditure_ou) operating_unit  from pa_projects_expnd_srch_v order by project_number_sort_order.
ORA-00942: table or view does not exist
Record Group PA_PROJECTS
Form: APXINWKB
FRM-30085: Unable to adjust form for output.

 

 

Changes

Patches 30849087:R12.AP.B & 29824092:R12.AP.B are applied which brought the latest form $AU_TOP/forms/US/APXINWKB.fmb version 120.601.12010000.561.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.