Calling Accounting Program from a custom program using fnd_request.submit_request API, but create ac

Hi All,

we have a scenario where we need to call create accounting program from a custom program and perform some updates once create accounting completes successfully.

I have written this attached piece of code to call the create accounting program using fnd_request.submit_request API. But as soon as create accounting program triggers from custom program , it fails with below error message.

[071514_065238481][][EXCEPTION] SQLException encounter while executing data trigger....

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at line 14

I have checked the parameter passed to the create accounting program and also their data type . But every time it is failing due to the same reason. Not sure what the error is. I have raised an SR with oracle, but they also are not sure on the issue.