Oracle Reports (MOSC)

MOSC Banner

REP-1401: 'customer_nameformula': Fatal PL/SQL error occurred.

edited May 5, 2009 12:16AM in Oracle Reports (MOSC) 3 commentsAnswered
We are converting our existing oracle reports6i from text to XML (Running under EBS 11.5.10.2 Applications). We modified one Subledger Report and converted it to XML and now we are getting error signal 11 and when we convert it back to text we get an error as below:
REP-1401: 'customer_nameformula': Fatal PL/SQL error occurred.
ORA-06502: PL/SQL: numeric or value error
 I have tried to increase the size of the formula column but to no avail.  The formula column code is as below:
function CUSTOMER_NAMEFormula return Char is
t_customer_name varchar2(7000);
t_reference_id  number :=:reference_7;
t_ae_line_id    number :=:ae_line_id;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center