Integration

I’m working with Oracle E-Business Suite (EBS) and exploring ways to insert data using APIs rather than direct SQL or form-based entry.

I tried inserting invoices using concurrent program, but it keeps returning 0

DECLARE
   l_request_id NUMBER;
BEGIN
   l_request_id := fnd_request.submit_request(
       application => 'SQLAP',                 -- Application Short Name for AP
       program     => 'APXIIMPT',              -- Short Name for the Invoice Import Program
       description => 'Import Invoices from Interface',
       start_time  => NULL,
       sub_request => FALSE
   );
   COMMIT;
   -- Optionally, check if the request submitted successfully
   IF l_request_id IS NULL THEN
       RAISE_APPLICATION_ERROR(-20001, 'Invoice Import Request Submission Failed');
   ELSE
       DBMS_OUTPUT.PUT_LINE('Invoice Import Request ID: ' || l_request_id);
   END IF;
END;
/