SLA Custom Source Definition Errors out: ORA-06502: PL/SQL: numeric or value error: character to num
Hi,
We have created a custom source for property manager SLA for complying with IFRS16 accounting with the following code:
Package Function name: Pn_Eqp_Lease_Utils.IS_IFRS16_LEASE
Code
function IS_IFRS16_LEASE (PAYMENT_TERM_ID number) return varchar2 is
V_RETURN varchar2(1);
begin
select NVL(pt.ATTRIBUTE9,'N')
into V_RETURN
from PN_PAYMENT_TERMS_ALL pt
where pt.PAYMENT_TERM_ID=PAYMENT_TERM_ID;
return V_RETURN;
end;
When running create accounting the process enters out with following message:
An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program XLA_00240_AAD_C_011164_PKG.AcctLineType_34. ORA-06502: PL/SQL: numeric or value error: character to number conversion error.