自動收料提交事务处理器Receiving Transaction Processor后沒有任何反映

gaoszqerp · 发表于 2007-10-9 13:59

这个接口表研究起来比较麻烦，不知道你们实际业务是几维匹配，我写了段三维匹配的程序（接口管理器提交了70多次才成功），你可以将你的程序贴上来，看看

xxuuvv · 发表于 2007-10-9 14:07

樓上大哥，你的MSN是？真照埥蹋∫韵率俏也宓臄祿

ammonecho · 发表于 2007-10-9 14:08

貼一下INSERT INTERFACE 的那一段吧,MSN發不出消息給你

zlc158 · 发表于 2007-10-9 14:13

有那么麻烦吗?
可惜帮不上你.我只做DBA 的事
实在不行,从数据库里直接更新数据,不就完了..嘿嘿

zhanglinjun007 · 发表于 2007-10-9 14:28

程式好象有点问题吧!

xxuuvv · 发表于 2007-10-9 14:31

最初由 zhanglinjun007 发布
[B]程式好象有点问题吧! [/B]

？？只要把數據插進去，再提交事務處理器就可以了，有什么問題呢？

xxuuvv · 发表于 2007-10-9 14:39

我覺得問題不應該出在數據上，應該是哪個區間或處理器等一些設置沒有正確，可究竟問題出在哪呢，在一樓我已經排除了一些了

dianxing · 发表于 2007-10-9 15:11

Concurrent program RVCTP returned error

Cause:       RVCTP encountered an internal error.  Parameters: RVCTP,BATCH,,

Action:       Note both this error number and the actions you are trying to perform. Contact your system administrato
RVTPT-000: Subroutine rvtvqty() returned error

Cause:       Subroutine rvtvqty() returned an internal error.

Action:       Note this error number and the actions you are trying to perform. Contact your system administrator for assist
RVTVQ-010: Subroutine rvtvqcnvqty() returned error

Cause:       Subroutine rvtvqcnvqty() returned an internal error.

Action:       Note this error number and the actions you are trying to perform. Contact your system administrator fo
RVTVQ-140: Subroutine rvtvqgetsrcuom() returned error

Cause:       Subroutine rvtvqgetsrcuom() returned an internal error.

Action:       Note this error number and the actions you are trying to perform. Contact your system administra
RVTVQ-160: ORA-01403: no data found


Cause:       A SQL error has occurred in RVTVQ.  The SQL error is &LSQL_ERR.

Action:       Take note of both this error number and the actions you were t
Concurrent Manager encountered an error while attempting to start your immediate concurrent program RVCTP. Routine &ROUTINE received a return code of failure.

dianxing · 发表于 2007-10-9 15:12

帮忙分析一下

xxuuvv · 发表于 2007-10-9 15:21

樓上這段信息哪來的？
提交
  l_request_id := fnd_request.submit_request('PO',
                                             'RVCTP',
                                             '',
                                             to_char(SYSDATE,
                                                   'YYYY/MM/DD HH24:MI:SS'),
                                             FALSE,
                                             'BATCH',
                                             to_char(L_GROUP_ID),
                                             chr(0));
后的嗎？

[原创] 自動收料 提交事务处理器Receiving Transaction Processor后沒有任何反映

[原创] 自動收料提交事务处理器Receiving Transaction Processor后沒有任何反映