You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ORA-06512: at "SYS.XMLTYPE", line 169

in Reporting and Analytics for ERP

Summary:

Hi,

i have created the AR Invoice Auto Mail by taken the reference of "Print receivable transactions", if i schedule the report the report should send the invoices to the customers via mail with PDF attachment. But if i am run the report, I am getting the error (ORA-06502: PL/SQL: numeric or value error: character string buffer too smallORA-06512: at "SYS.XMLTYPE", line 169). it was working for few invoices. but now it is erroring. please help me on this.

"Detail Message:

::JOB_WAIT_TIME_SECONDS{0.9}::JOB_FETCH_TIME_SECONDS{54}::JOB_EXECUTION_TIME_SECONDS{54}::JOB_PRIORITY_COLON_NORMAL::::JOB_PROCESSOR_EXCEPTION::[INSTANCE_ID=bip.bi_server1] [INSTANCE_JOB_ID=16886164]::::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=bip.bi_server1] DataException:[INSTANCE_JOB_ID=16886164] oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!