Unable to submit "Invoice Validaton" program from pl/sql
This piece of code is not working and failing with ORA-0000: normal, successful completion after initialize also.FND_GLOBAL.APPS_INITIALIZE(fnd_profile.value('USER _ID'),FND_PROFILE.VALUE('RESP_ID'), fnd_profile.value('RESP_APPL_ID')); lv_inv_val_request_id := fnd_request.submit_request ('SQLAP', -- Application'APXAPRVL', -- Program'', -- DescriptionSYSDATE, -- Start_timeFALSE, -- Sub_request'', --fnd_profile.VALUE ('ORG_ID'), -- Operating Unit (optional)'All', -- Match Option'',-- lv_tec_batch_name, -- Batch Name (required)'', -- Invoice Start Date (optional)'', -- Invoice End Date (optional)''
Tagged:
0