I am using PLSQL to call the Payables Open Interface Program. Everything runs rather smoothly except for the fact that the Payables Import will only import 15 records at a time. After that it gives me the errors
The account created with overlay is invalid
and
Invalid distribution account
The problem is if I rerun the program it will grab the next 15 (even though I had those errors) and run then gives those 2 errors for the rest of the records. This continues as long as I'm willing to rerun the programs. Can anyone tell me what is going on?
This is the part of the program that calls the open interface import:
l_group_id := TO_CHAR (SYSDATE, 'MM/DD/YYYY');
l_batch_name := TO_CHAR (SYSDATE, 'MM/DD/YYYY');
l_source := p_source; --'INVOICE UPLOAD'; --'BFRIDAY';
l_invimp_reqid :=
fnd_request.submit_request
(
application => 'SQLAP',
program => 'APXIIMPT',
description => 'Payables Open Interface Import',
start_time => NULL,
sub_request => FALSE,
argument1 => l_source,
argument2 => l_group_id,
argument3 => l_batch_name,
argument4 => NULL,
argument5 => NULL,
argument6 => NULL,
argument7 => 'N',
argument8 => 'N',
argument9 => 'Y', --argument9 => NULL,
argument10 => 'N',
argument11 => 1000,
argument12 => fnd_profile.VALUE ('USER_ID'),
argument13 => fnd_profile.VALUE ('LOGIN_ID')
);
any helps or tips would be greatly appreciated.
The account created with overlay is invalid
and
Invalid distribution account
The problem is if I rerun the program it will grab the next 15 (even though I had those errors) and run then gives those 2 errors for the rest of the records. This continues as long as I'm willing to rerun the programs. Can anyone tell me what is going on?
This is the part of the program that calls the open interface import:
l_group_id := TO_CHAR (SYSDATE, 'MM/DD/YYYY');
l_batch_name := TO_CHAR (SYSDATE, 'MM/DD/YYYY');
l_source := p_source; --'INVOICE UPLOAD'; --'BFRIDAY';
l_invimp_reqid :=
fnd_request.submit_request
(
application => 'SQLAP',
program => 'APXIIMPT',
description => 'Payables Open Interface Import',
start_time => NULL,
sub_request => FALSE,
argument1 => l_source,
argument2 => l_group_id,
argument3 => l_batch_name,
argument4 => NULL,
argument5 => NULL,
argument6 => NULL,
argument7 => 'N',
argument8 => 'N',
argument9 => 'Y', --argument9 => NULL,
argument10 => 'N',
argument11 => 1000,
argument12 => fnd_profile.VALUE ('USER_ID'),
argument13 => fnd_profile.VALUE ('LOGIN_ID')
);
any helps or tips would be greatly appreciated.