: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 [Caused by: ORA-01403: no data found issue in Database Adapter

ERROR:
file:/u01/app/oracle/product/10.1.3/bpel/domains/xl/tmp/.bpel_CreateManifest_1.0_b4e96c3ac640a4edb6c0fd2ca0c8156a.tmp/CreateManifestDetailsInODS.wsdl [ CreateManifestDetailsInODS_ptt::CreateManifestDetailsInODS(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'CreateManifestDetailsInODS' failed due to: Error while converting to a Java struct object.Unable to convert the XSD element PI_MANIFEST_REC whose user defined type is ODS.XX_ODS_MANIFEST_REC. Cause: java.sql.SQLException: ORA-01403: no data foundORA-06512: at line 1
[Caused by: ORA-01403: no data found

ORA-06512: at line 1

]

; nested exception is: 

                    ORABPEL-11802

Error while converting to a Java struct object.

Unable to convert the XSD element PI_MANIFEST_REC whose user defined type is 

ODS.XX_ODS_MANIFEST_REC. Cause: java.sql.SQLException: ORA-01403:

 no data found ORA-06512: at line 1

 [Caused by: ORA-01403: no data found

ORA-06512: at line 1

]

 Solution:

 I have I tried below to resolve the issue.

 1. One thing surprised me that the same code working in other environments 

     but not working only one environment i.e SIT.

 2. Initially I thought some thing going wrong in package..Record structure…

    that may be different from other environments but …I have verified package …

    after analyzing code I found that is not the reason for this error…

    package looks fine..

3. I have created one DB adapter against SIT DB and deployed it works fine…

   But this is not my final goal my old code should work in SIT also because this 

   is working in all environments and I should not develop code 

   for each environment one version.

4. Later I compared XSDs of both SIT and others I found DB user is the problem…

 For example XX_ODS_MANIFEST_REC is the record type in DB.

 ODS.XX_ODS_MANIFEST_REC àin BPEL XSD

 But the SIT user ID is some thing like SITODS so XSD should have 

SITODS.XX_ODS_MANIFEST_REC but current XSD have only 

ODS.XX_ODS_MANIFEST_REC due to that we are facing above error.

5. I have changed XSD and deployed it works fine …J