How to Fix/Avoid subLanguageExecutionFault in BPEL process?

subLanguageExecutionFault occurs during the execution of BPEL process in some XPath expressions due to -

• assigning incompatible data types
• invalidating any restrictions on the element - e.g. string legnth exceeding
• missing an arguement in Transform activity's source operation - ora:processXSLT()

To avoid or to fix the subLanguageExecutionFault consider following pointers -

1. Make sure the data types of the source and target are compatible and within the restrictions
2. Make sure while editing the Transformation in BPEL source by double clicking the Transform activity, the payload part of both Source and Targe variable is populated and then only Edit button is clicked
3. Verify that the expression for Transform - ora:processXSLT('Transformation1.xsl','inputVaribale','payload') contains the arguement 'payload' in the BPEL Source.

By taking care of above points you can avoid or fix the subLanguageExecutionFault .

Cheers!!!

Sagar

Database adapter - should be used for Oracle Apps schema?

Hi,
I have a requirement of pulling all the records from Oracle Apps for Purchase Order transactions happened during some period. Can anybody tell me where can I find guidelines for using Database Adapter or Oracle Apps adapter for pulling all the Purchase order records from Apps schema.
I think Database Adapter is not a right choice for the pulling data from Oracle Apps schema, as the shchema structure in Apps is complex and the tables are linked as well.

So, if I have to use Oracle Apps Adapter - then what should I use - APIs, Tables/Views, XML Gateway..

Please help.

Thanks.