My Oracle Support Banner

Error "ORA-20001: FLEX-DSQL EXCEPTION: N, MSG, ORA-01722: invalid number..." When Creating Position Using HR_POSITION_API.CREATE_POSITION API (Doc ID 3012717.1)

Last updated on MARCH 26, 2024

Applies to:

Oracle Human Resources - Version 12.2.12 and later
Information in this document applies to any platform.


When attempting to create a position from the HR_POSITION_API.CREATE_POSITION API,
the following error occurs.

ORA-20001: FLEX-DSQL EXCEPTION: N, MSG, ORA-01722: invalid number, N, SQLSTR, select Meaning, to_char(LOOKUP_CODE), NULL, 'Y', to_char(to_date(null),'YYYY/MM/DD HH24:MI:SS'), to_char(to_date(null),'YYYY/MM/DD HH24:MI:SS'), 'N', NULL from HR_LOOKUPS where ( LOOKUP_TYPE = 'LNH_POSITIONS' AND ENABLED_FLAG = 'Y') and LOOKUP_CODE = :FND_BIND1, N, ERRMSG, An unexpected error has occurred. Please inform your system administrator that the error: ORA-01722: invalid number occurred when the FND_FLEX_SERVER package tried to execute the SQL statement below.


A) Write a wrapper code using hr_position_api.create_position API


B) Execute the API script and gets above mentioned error.


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

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