Problems with purchase order notifications

[Jadder]

Good afternoon everyone, I have a problem in the notifications that the user receives when he needs to approve a purchase order. The error mentioned when opening Oracle Explorer is as follows:



I rummaged through the whole package and spread traces for it, but so far I did not discover the problem. Because it is a proc "core" should not give any problems correctly?

Can anyone provide a light at the end of the tunnel?

grateful

[dr_gori]

I think you have to rummage through what is being passed on the variables.
For this error usually happens when you try to put something in a larger variable than your ability to handle.

Type:

Select all

SQL> declare 
  2    vtemp number(2); 
  3  begin 
  4    vtemp :=1000; 
  5  end; 
  6  / 
declare 
* 
ERROR at line 1: 
ORA-06502: PL/SQL: numeric or value error: number precision too large 
ORA-06512: at line 4 
 
 
SQL> 

Maybe for being there all in Portuguese, have some message that is not fitting in its proper place. I think I would look for it ...
And as you said yourself, this is a core and would not even have a bug like this: - /

[adoniasviana]

Hi !

Although the topic is 2008:

I had the same problem recently, was solved with patch application, I realized that creating the PO with NLS en-BR This problem was occurring in English.

The patch corrected the problem.


Hugs!