ORA-00976 Error While Approving Internal Requisitions

(Doc ID 968651.1)

Last updated on APRIL 17, 2017

Applies to:

Oracle Purchasing - Version 12.0.0 and later
Oracle E-Business Tax - Version 12.0.0 and later
Information in this document applies to any platform.
Form:POXRQERQ - Enter Requisitions


Symptoms

When approving an internal requisition the following error appears :

ORA-00976 LEVEL,PRIOR, or ROWNUM not allowed here in Package PO_DOCUMENT_CHECKS_PVT Procedure CHECK_REQUISITIONS.

 

Debug Log messages shows :

Found the location info in cache for location id: 142 for table HR_LOCATIONS_ALL
get_location_info(-)
B: SEL hz_geo_name_ref: in: p_location_id=142, p_geography_type=COUNTRY, x_location_table_name=HR_LOCATIONS_ALL
S: SEL hz_geo_name_ref: no_data_found: x_location_table_name=HR_LOCATIONS_ALL B: x_geography_id=, p_geography_type=COUNTRY, p_location_id=142, p_geography_type=COUNTRY
B: SEL hz_geographies: in: l_country_code=KE
R: x_geography_id=10109, x_gegraphy_code=KE, x_geography_name=Kenya- get_master_geography(-)

Steps to Reproduce:
1. Create an Internal Requisition
2. Attempt to approve the internal requisition-> error occurs

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms