Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Payables Open Interface Problem

Status
Not open for further replies.

ISUTri

MIS
Mar 25, 2004
38
0
0
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top