用fnd_request.submit_request调自动开票主程序出错

[复制链接]
查看11 | 回复1 | 2007-3-9 11:45:36 | 显示全部楼层 |阅读模式
在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
+---------------------------------------------------------------------------+
回复

使用道具 举报

千问 | 2007-3-9 11:45:36 | 显示全部楼层
Hi, 樓主
您提出問題所在:
其一:若您是在Form中調用系統程式,那么參數必須給足預設的個數,通常是105個。
其二:若本次給的參數為5個,那么第6個參數必須給Chr(0),余下給null(第六個必須是chr(0))
以此表明程式被調用從第六個參數開始做Null 處理。
Best Regards, Kenver

工作快樂,快樂工作~~~
[ 本帖最后由 kenver 于 2007-12-11 14:44 编辑 ]
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行