摘要：
RTP报错信息: RVTPT-020: Subroutine rvtoe_RmaPushApi() - EDelivered quantity cannot exceed received quantity. returned error原因:部分接收时,系统没有自动split这个RMA订单行;现假设RMA订单行数量为10个,先前已成功接收5个,现再接收余下5个时报上面的错误.解决方法(假设RMA行的id为1234567):BEGIN dbms_application_info.set_client_info(123);--假定OU为123 oe_rma_receiving.push_rece 阅读全文
摘要：
如果SELECT语句中有使用Alias,DISTINCToperator,CURSORexpression,SET(union,union all,minus,intersect)operators,group_by_clause, oraggregate(count,max,mix,avg)functions,则无法到查询返回值进行更新;eg:TABLE:empid name salary==========================10 aaaa 123413 abcd 231315 cdue 1245... ... ...case 1> 使用别名;select id emp_ 阅读全文
摘要：
SELECT OHA.ORDER_NUMBER, HS.HOLD_ENTITY_CODE CREDIT_CHECK_CRITERIA_CODE, FLV.MEANING CREDIT_CHECK_CRITERIA, HD.NAME HOLD_NAME, HD.TYPE_CODE HOLD_TYPE, HR.RELEASE_REASON_CODE, FLV1.MEANING RELEASE_REASON, HS.RELEASED_FLAG, HS.HOLD_ENTITY_ID, OH.HOLD_RELEASE_ID, OH.HEADER_ID, HS.HOLD_SOURCE_ID FROM ON 阅读全文
摘要：
How to change the status of Prepayment invoice from ‘Fully Applied’ to ‘Available’,In fact the prepayment invoice has been applied./Files/benio/aaa.doc 阅读全文
摘要：
The issue occurs twice again, the problem should be a bug[patch 5256307].Solution:-----------------------------------------------------------------------------Step1>update po's unit price to the price that it has been used by receiving;udate po_lines_allset unit_price = 766.99where po_line_id 阅读全文
摘要：
AR transactions should be created on 6-JUL-2010,in fact they weregenerated on 25-JUN-2010. Because the SHIP_DATE_ACTUAL is on 25-JUN-2010.----------------------------------------------------------------------------------Original date: TRX_DATE=25-JUN-2010,GL_DATE=25-JUN-2010,DUE_DATE=25-JUL-2010---- 阅读全文
摘要：
Payables displays the status of the payment. You can change the value in this field under ertain circumstances for future dated payments. Note that the statuses that Payables uses for cleared payments and reconciled payments depends on your setting for the Account for Payment When Payment Clears Pay 阅读全文
摘要：
你可曾发现,在ap_invoice_distributions_all中有时rcv_transaciton_id为空,有时却又是有值的, 这是为什么呢?(请参考po_line_locations_all.match_option)或许你还记得我们在发票工作台上选择匹配时,有时是Match PO,有时却是Match Receipt,其实这就是原因所在, 当然影响这个匹配项的根本还是PO的shipment上的一个开关:是Receipt,还是Purchase Order,如果这里是Receipt,在匹配PO时,只能选择Receipt(匹配成功保存后rcv_transaciton_id是有值的),反之 阅读全文
摘要：
待摊费用场景:一次性支付1年房租24000.001）AP发票 DR: 待摊费用-房租 24000.00 CR: 应付帐款-其它 24000.002）AP付款 DR: 应付帐款-其它 24000.00 CR: 银行存款 24000.003）GL日记帐(每月做) DR: 管理费用-房租分摊 2000.00（1/12) CR: 待摊费用 2000.00（1/12) 阅读全文
摘要：
12 How to Match a Credit Memo to an Invoice for Correction? [ID 1314520.1]--------------------------------------------------------------------------------Applies to:Oracle Payables - Version: 12.0.0 to 12.1.3 - Release: 12.0 to 12.1Information in this document applies to any platform.SolutionHere ar 阅读全文