在package中用 fnd_request.submit_request 调自动开票主程序时报: Usage: program oracleid request_id Y 的错误;单独提交又是可以的。
调用代码:
n_req_id := fnd_request.submit_request(application => 'AR',
program => 'RAXMTR',
description => NULL,
start_time=> NULL,
sub_request => FALSE,
argument1 => '1', --number instances
argument2 => to_char(pi_batch_source_id), -- batch source id
argument3 => pi_batch_source_name, -- batch source name
argument4 => pi_gl_date,
argument5 => NULL,
argument6 => NULL,
argument7 => NULL,
argument8 => NULL,
argument9 => NULL,
argument10 => NULL,
argument11 => NULL,
argument12 => NULL,
argument13 => NULL,
argument14 => NULL,
argument15 => NULL,
argument16 => NULL,
argument17 => NULL,
argument18 => NULL,
argument19 => NULL,
argument20 => NULL,
argument21 => NULL,
argument22 => NULL,
argument23 => NULL,
argument24 => NULL,
argument25 => '是',
argument26 => NULL);
把100个参数据都带入也是同样的错误,按 metalink 上的解决方法把参数为空的不用 null 用 '',也是同样的错误;不知道哪位高手遇到过这样的问题?请指教!!多谢!
LOG
++++++++++++++++++++++++++++++
+---------------------------------------------------------------------------+
Oracle Receivables: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
RAXMTR module: 自动开票主程序
+---------------------------------------------------------------------------+
当前的系统时间为 19-01-2007 14:10:19
+---------------------------------------------------------------------------+
Usage: program oracleid request_id Y
argv[0]program name
argv[1]number instances
argv[2]batch source id
argv[3]batch source name
argv[4]default date
argv[5]concatenated transaction flexfield attribute value
argv[6]transaction type id
argv[7]low bill to customer number
argv[8]high bill to customer number
argv[9]low bill to customer name
argv[10] high bill to customer name
argv[11] low gl date
argv[12] high gl date
argv[13] low ship date
argv[14] high ship date
argv[15] low transaction number
argv[16] high transaction number
argv[17] low sales order
argv[18] high sales order
argv[19] low invoice date
argv[20] high invoice date
argv[21] low ship to customer number
argv[22] high ship to customer number
argv[23] low ship to customer name
argv[24] high ship to customer name
argv[25] Base Due Date on invoice date flag
argv[26] Minimum Due Date offset from trx date
argv[27] Org Id
+---------------------------------------------------------------------------+
Plsql 程序的日志信息开始
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
PlSql 程序的日志信息结尾
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
正在执行请求完成选项...
已完成执行请求完成选项。
Usage: program oracleid request_id Y
+---------------------------------------------------------------------------+
已完成并发请求
当前的系统时间为 19-01-2007 14:10:19
+---------------------------------------------------------------------------+
|