SO 無法產生發票（已經解決）

jieping_zhang

改了匯率，還是不行，而且有錯誤，但是，不知道Log里面沒有東西！

[ 本帖最后由 jieping_zhang 于 2008-12-1 12:21 编辑 ]

royalbfc

upload  autoinvoice log

jieping_zhang

+---------------------------------------------------------------------------+
Oracle Receivables: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

RAXTRX module: Autoinvoice Import Program
+---------------------------------------------------------------------------+

Current system time is 28-NOV-2008 21:36:08

+---------------------------------------------------------------------------+

raagsp()+ Current system time is 28-NOV-2008 21:36:08
raagsp()- Current system time is 28-NOV-2008 21:36:08
raaini()+ Current system time is 28-NOV-2008 21:36:08
raaapx()+ Current system time is 28-NOV-2008 21:36:08
raaapx()- Current system time is 28-NOV-2008 21:36:08
raagbo()+ Current system time is 28-NOV-2008 21:36:08
Dumping data fetched from RA_BATCH_SOURCES
batch_source_name = Order Entry
auto_trx_numbering_flag = Y
copy_doc_number_flag = N
cust_trx_type_rule = I
sold_customer_rule = I
bill_customer_rule = I
bill_address_rule = I
bill_contact_rule = I
ship_customer_rule = I
ship_address_rule = I
ship_contact_rule = I
memo_reason_rule = I
term_rule = I
invoicing_rule_rule = N
accounting_rule_rule = N
unit_of_measure_rule = I
agreement_rule = N
inventory_item_rule = I
fob_point_rule = N
ship_via_rule = N
invalid_lines_rule = R
salesperson_rule = I
sales_credit_type_rule = I
accounting_flexfield_rule = I
invalid_tax_rate_rule = R
rev_acc_allocation_rule = P
gl_date_period_rule = R
create_clearing_flag = N
derive_date_flag = Y
sales_credit_rule = P
sales_territory_rule = N
receipt_method_rule = I
customer_bank_account_rule = I
related_document_rule = N
memo_line_rule = I
allow_sales_credit_flag = Y
raagbo()- Current system time is 28-NOV-2008 21:36:08
raaggi()+ Current system time is 28-NOV-2008 21:36:08
raagixpfx = 0
raagixtpf = 0
raagixddf = 1
raagixacf = 0
raagixrit = 1
raagixagd = 0
raagixatn = 1
raagixcte = 0
raagixdfd =
raagixctc = 3
raagixrmx = T
raagixfdx = 28-NOV-08
raagixbix =
raagixbsi = 1025
raagixbnx = Order Entry
raagixoix = 82
raagixrix = 4426109
raagixpix = 20428
raagixpai = 222
raagixuix = 3663
raagixunx = P-SPRING
raagixanx = AR
raagixlul = 5353170
raagixasc = 1
raagixrsf = 0
raagixcbf = 0
raagixuax = 1
Argtcm = 0
Argtvd = 0
raagixsnf = 1
raagixtao = 1
raagixptf = 1
raagixstf = 1
raagixrfi = 0
raagixtac = 1
raagixcai = 101
raagixsbi = 2
raagixcpr = 3
raagixmau =
raagixmlx = 3
raagixmbx = 6000000
raagixafp = Account
raagixifp = ITEM
raagixtfp = TERRITORY
Argbdf = 1
Argddo = -9999
raaggi()- Current system time is 28-NOV-2008 21:36:09
raaseb()+ Current system time is 28-NOV-2008 21:36:09
raaseb()- Current system time is 28-NOV-2008 21:36:09
arcdsu()+ Current system time is 28-NOV-2008 21:36:09
arcdsu()    error level: 3  array size: 6000000  insert array size: 6000000
arcdsu()   Use Invoice Accounting For Credit Memo: Y
arcdsu()- Current system time is 28-NOV-2008 21:36:09
raaini()- Current system time is 28-NOV-2008 21:36:09
raapft()+ Current system time is 28-NOV-2008 21:36:09
raagtr()+ Current system time is 28-NOV-2008 21:36:09
FDPGRS cannot find your concurrent request 2982253

FDPGRS found no rows while selecting your concurrent request 2982253.
Please contact your support representative.
FDPGRS cannot find your concurrent request 2891358

FDPGRS found no rows while selecting your concurrent request 2891358.
Please contact your support representative.
FDPGRS cannot find your concurrent request 3461377

FDPGRS found no rows while selecting your concurrent request 3461377.
Please contact your support representative.
FDPGRS cannot find your concurrent request 4271208

FDPGRS found no rows while selecting your concurrent request 4271208.
Please contact your support representative.
crb->raaucrpn = RAXTRX
crb->raaucrcr = 4426109
crb->raaucrnt = 0
crb->raaucrml = 3
raagtr()- Current system time is 28-NOV-2008 21:36:09
raamil()+ Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
raaasf()+ Current system time is 28-NOV-2008 21:36:09
raaasf()- Current system time is 28-NOV-2008 21:36:09
UPDATE RA_INTERFACE_LINES
SET
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = :b1,
LAST_UPDATE_LOGIN = :b2,
TRX_DATE = TRUNC(TRX_DATE),
GL_DATE = TRUNC(GL_DATE),
CONVERSION_DATE = TRUNC(CONVERSION_DATE),
PURCHASE_ORDER_DATE = TRUNC(PURCHASE_ORDER_DATE),
RULE_START_DATE = TRUNC(RULE_START_DATE),
SALES_ORDER_DATE = TRUNC(SALES_ORDER_DATE),
SHIP_DATE_ACTUAL = TRUNC(SHIP_DATE_ACTUAL),
CUSTOMER_TRX_ID = NULL,
INTERFACE_LINE_ID = NVL(INTERFACE_LINE_ID, RA_CUSTOMER_TRX_LINES_S.NEXTVAL)
WHERE NVL(INTERFACE_STATUS, '~') != 'P'
AND REQUEST_ID = :b3
AND LINK_TO_LINE_ATTRIBUTE1 IS NULL
AND LINK_TO_LINE_ATTRIBUTE2 IS NULL
AND LINK_TO_LINE_ATTRIBUTE3 IS NULL
AND LINK_TO_LINE_ATTRIBUTE4 IS NULL
AND LINK_TO_LINE_ATTRIBUTE5 IS NULL
AND LINK_TO_LINE_ATTRIBUTE6 IS NULL
AND LINK_TO_LINE_ATTRIBUTE7 IS NULL
AND LINK_TO_LINE_ATTRIBUTE8 IS NULL
AND LINK_TO_LINE_ATTRIBUTE9 IS NULL
AND LINK_TO_LINE_ATTRIBUTE10 IS NULL
AND LINK_TO_LINE_ATTRIBUTE11 IS NULL
AND LINK_TO_LINE_ATTRIBUTE12 IS NULL
AND LINK_TO_LINE_ATTRIBUTE13 IS NULL
AND LINK_TO_LINE_ATTRIBUTE14 IS NULL
AND LINK_TO_LINE_ATTRIBUTE15 IS NULL

len = 1099
1 rows updated Current system time is 28-NOV-2008 21:36:09
raagtf()+ Current system time is 28-NOV-2008 21:36:09
None of the transaction flexfield contexts you have provided for this request have enabled segments
Error calling raagtf()
Error calling raamil()
Error calling raapft()
raafds()+ Current system time is 28-NOV-2008 21:36:09
raafeb()+ Current system time is 28-NOV-2008 21:36:09
raafeb()- Current system time is 28-NOV-2008 21:36:09
arcdcu()+ Current system time is 28-NOV-2008 21:36:09
arcdcu()- Current system time is 28-NOV-2008 21:36:09
raafds()- Current system time is 28-NOV-2008 21:36:09
+---------------------------------------------------------------------------+
Start of log messages from Plsql  program
+---------------------------------------------------------------------------+
Entering OE_Sys_Parameters.Value
Entering OE_Sys_Parameters.Value
+---------------------------------------------------------------------------+
End of log messages from PlSql program
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+


No completion options were requested.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 28-NOV-2008 21:36:09

+---------------------------------------------------------------------------+

richardliu1123

FDPGRS cannot find your concurrent request <request_id>. FDPGRS found no rows while selecting your concurrent request <request_id>.
Solution
Step 1:

Every time AutoInvoice is run, it picks up all the failed requests from the prior runs (accessing the table AR_CONC_PROCESS_REQUESTS), reprocesses those transactions as well as any new ones. It is possible that you could manually update the request_id in the interface table or delete the rows and reimport those to process as fresh transactions. But then, you must remove the entry from the AR_CONC_PROCESS_REQUESTS table as well.

[ 本帖最后由 richardliu1123 于 2008-12-1 15:34 编辑 ]

jieping_zhang

原帖由 richardliu1123 于 2008-12-1 15:10 发表
FDPGRS cannot find your concurrent request . FDPGRS found no rows while selecting your concurrent request .
Solution
Step 1:

Every time AutoInvoice is run, it picks up all the failed requests from the prior runs (accessing the table AR_CONC_PROCESS_REQUESTS), reprocesses those transactions as well as any new ones. It is possible that you could manually update the request_id in the interface table or delete the rows and reimport those to process as fresh transactions. But then, you must remove the entry from the AR_CONC_PROCESS_REQUESTS table as well.

jieping_zhang

此問題在一個朋友的幫助下解決了，在這里很感謝他，也很感謝大家！
說一下解決問題的方法吧，
1. 由于公司歷史的原因產生了很多數據ar_interface _lines_all里面，一直沒有得到很好的清理， 同樣在AR_CONC_PROCESS_REQUESTS 這個表里面有四個 如下圖，首先清空掉AR_CONC_PROCESS_REQUESTS  這個table 里面的咨詢！
2. 在到 ra_interface_lines_all  這個table 里面 把 request_id 清空掉，在到當前的OU 的rep里面去　ｒｕｎ　　Autoinvoice Import Program　這個程序！

[ 本帖最后由 jieping_zhang 于 2008-12-2 11:56 编辑 ]

陌陌卡

   這個Table : AR_CONC_PROCESS_REQUESTS 裡面紀錄的是什麼信息?
跟interface_line有什麼關係呢 ?  疑惑......

fly-in-the-sky

恭喜LZ解決問題，要是能找到原因就更好了。

jieping_zhang

我懷疑一直是歷史資料的原因，ar_inteface_lines_all 這個table里面有好多歷史資料，以前這個公司的做法就是ｒｕｎ　不出來去手動的添加一個發票，沒有人愿意去找原因，以前支持的顧問公司也沒有找到原因！

cinimo

Error:
Autoinvoice max memory set below recommended value, defaulted to 1048576 bytes
调用 afpoget() - AR_ALLOW_TRX_LINE_EXEMPTIONS 时出错
raagsp()- 当前的系统时间为 09-01-2008 16:48:40
Dumping data fetched from RA_BATCH_SOURCES
batch_source_id = 1003
.......................
转载自：http://ecmcug.itpub.net/viewthread.php?tid=924467&page=1
参考Solution
1.无法读取例程 &ROUTINE 中配置文件选项 ZX_ALLOW_TRX_LINE_EXEMPTIONS 的值。
   到Profile里检查Tax: Allow Override of Customer Exemptions 属性，可能为空设为Yes or No

2.检查自动会计 N:AR SetUp => Transactions => AutoAccounting 是否设置完成。完整有(AutoInvoice Clearing, Freight, Receivable, Revenue, Tax,Unbilled Receivable, and Unearned Revenue)七类，缺少一项未设定都会错误。

3.Autoinvoice max memory set below recommended value, defaulted to 1048576 bytes
  自动更新可用内存尺寸大小加大一些。

4.检查Profile 的AR: Use Invoice Accounting For Credit Memos属性
   Fix
   Please provide settings at all 3 levels ( Site/Application/Responsibility/Use
   r)
The name of the profile option is :
AR: Use Invoice Accounting For Credit Memos.
This profile options determines whether to assign your credit memo to the same accounts that are assigned to the invoice you are crediting.
Please chk. if the profile option is set to yes at the site and application level.