Create Applications Adapter in JDeveloper Causes Error: java.sql.SQLException: ORA-06502 (Doc ID 565850.1)

Last updated on MARCH 02, 2009

Applies to:

Oracle JDeveloper - Version: 10.1.3.3.0 to 10.1.3.3.0
Oracle(R) BPEL Process Manager - Version: 10.1.3.3.0 to 10.1.3.3.0
Microsoft Windows XP
Linux x86
Jdeveloper 10.1.3.3
Information in this document applies to any platform.

Symptoms

While creating a wrapper API in a BPEL project, it fails with the following error:


OE_ORDER_PUB$GET_ORDER API. Cause: java.sql.SQLException: ORA-06502: PL/SQL:
numeric or value error
ORA-06512: at "APPS.XXVM_BPEL_GETORDERS", line 1
ORA-06512: at "APPS.XXVM_BPEL_GETORDERS", line 1
ORA-06512: at line 1
[Caused by: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.XXVM_BPEL_GETORDERS", line 1
ORA-06512: at "APPS.XXVM_BPEL_GETORDERS", line 1
ORA-06512: at line 1
]


Steps to reproduce the issue:

1. Create a new BPEL project (synchronous BPEL project).
2. Add a partner link.
3. Define a Wrapper API.
a. Drag and drop an Oracle Applications Adapter Service.
b. Enter the service name and select the database connection.
c. Add Database objects - click on Get Object.

select GET_ORDER object (Order Management Suite(OM_PF) - > Order Management(ONT)- > Sales Order (ONT_SALES_ORDER) -> PLSQL(3) -> Purchase Order API (OD
_ORDER_PUB) -> Get Sales Order (GET_ORDER) )

d. create Wrapper API.
e. Click finish.

While creating wrapper API it fails with SQLException: ORA-06502.

Check to ensure that the API is defined in the database and that the parameters match the signature of the API.



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