Hi community,
i have tried to call background job with PL/SQL developer for “Batch Create Collective Invoices”.
I took the parameter example from scheduled database task.
If this is run with same parameters through Scheduled database task, it won’t give error.
Goal is to have two scheduled Events, which would search customer’s either having Cycle interval 7 days and another with interval 30 days. Logic would find such customers and start “Batch Create Collective Invoices” background job for each found customer.
Code snippet to just test calling the “Batch Create Collective Invoices” standard API.
declare
arg_ VARCHAR2(32000);
BEGIN
Client_SYS.Clear_Attr(arg_);
Client_SYS.Add_To_Attr('$COMPANY=', 'xx'||chr(10), arg_);
Client_SYS.Add_To_Attr('$CONTRACT=', 'xx'||chr(10), arg_);
Client_SYS.Add_To_Attr('$CURRENCY_CODE=', '%'||chr(10), arg_);
Client_SYS.Add_To_Attr('$CUSTOMER_NO=', 'xx'||chr(10), arg_);
Client_SYS.Add_To_Attr('$IVC_UNCONCT_CHG_SEPERATLY=', '0'||chr(10), arg_);
Client_SYS.Add_To_Attr('$PAY_TERM_ID=', '%'||chr(10), arg_);
Client_SYS.Add_To_Attr('$PLANNED_INVOICE_DATE_OFFSET=', '1'||chr(10), arg_);
arg_ := '!'||chr(10)||arg_;
Transaction_SYS.Deferred_Call(
'Invoice_Customer_Order_API.Batch_Create_Coll_Invoices__',
'MESSAGE',
arg_,
'Batch Create Invoices xx'
);
END;
Error seen in the background job.
ORA-06502: PL/SQL: numeric or value errorMessage 1905 not found; No message file for product=plsql, facility=PCM
ORA-06512: at "IFSAPP.INVOICE_CUSTOMER_ORDER_API", line 6484
ORA-06512: at "IFSAPP.INVOICE_CUSTOMER_ORDER_API", line 6544
ORA-06512: at line 1
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1867
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 280
ORA-06512: at "IFSAPP.INVOICE_CUSTOMER_ORDER_API", line 6484
ORA-06512: at "IFSAPP.INVOICE_CUSTOMER_ORDER_API", line 6544
ORA-06512: at line 1
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1867
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 280
ORA-06512: at "IFSAPP.DEFERRED_JOB_API", line 2080
parameters copied from the Background job:
!
$COMPANY=xx
$CONTRACT=xx
$CURRENCY_CODE=%
$CUSTOMER_NO=%
$IVC_UNCONCT_CHG_SEPERATLY=0
$PAY_TERM_ID=%
$PLANNED_INVOICE_DATE_OFFSET=1