{"id":218,"date":"2007-08-02T14:49:38","date_gmt":"2007-08-02T12:49:38","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=218"},"modified":"2012-04-03T09:46:37","modified_gmt":"2012-04-03T07:46:37","slug":"blad-app-ar-11017-przy-probie-modyfikacji-dnaych-faktury-cheman","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=218","title":{"rendered":"B\u0142\u0105d APP-AR-11017 przy pr\u00f3bie modyfikacji dnaych faktury"},"content":{"rendered":"<p><span style=\"font-size: 12pt; font-family: Arial;\">Rozwi\u0105zanie: nale\u017cy zmodyfikowa\u0107\u00a0 (term_id) warunek p\u0142atno\u015bci na formatce &#8222;transakcje&#8221; tak aby by\u0142 zgodny z tym z formatki &#8222;raty&#8221;<\/span><\/p>\n<p><span style=\"font-size: 12pt; font-family: Arial;\">informacje z metalinka:<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"margin: auto 0cm;\"><span style=\"font-family: Arial;\" lang=\"EN-US\">The information in this article applies to: <\/span><\/h3>\n<p><span style=\"font-family: Arial;\" lang=\"EN-US\">Oracle Receivables &#8211; Version: 11.5<br \/>\nThis problem can occur on any platform.<br \/>\nARXTWMAI &#8211; Transactions <\/span><\/p>\n<h3 style=\"margin: auto 0cm;\"><span style=\"font-family: Arial;\" lang=\"EN-US\">Errors<\/span><\/h3>\n<p><span style=\"font-family: Arial;\" lang=\"EN-US\">APP-AR-11017<\/span><\/p>\n<h3 style=\"margin: auto 0cm;\"><span style=\"font-family: Arial;\" lang=\"EN-US\">Symptoms<\/span><\/h3>\n<p><span style=\"font-family: Arial;\" lang=\"EN-US\">Copy invoice fails with the error message :<br \/>\nAPP-AR-11017 'Recreation of Payment Schedules failed because the transaction has activity against it&#8217; <\/span><\/p>\n<h3 style=\"margin: auto 0cm;\"><span style=\"font-family: Arial;\" lang=\"EN-US\">Cause<\/span><\/h3>\n<p><span style=\"font-family: Arial;\"><a href=\"https:\/\/metalink.oracle.com\/metalink\/plsql\/showdoc?db=Bug&amp;id=2510929\"><span lang=\"EN-US\">Bug 2510929<\/span><\/a><\/span><span style=\"font-family: Arial;\" lang=\"EN-US\"> ARXTW: APP-AR-11017 RECEIVE ERROR WHEN TRYING TO APPLY CREDIT MEMO TO INVOICE<\/span><span style=\"font-family: Arial;\" lang=\"EN-US\">The problem was likely to have happened on old data that was upgraded.<br \/>\nThe cause of the error was not found and the problem is not reproducable<\/span><\/p>\n<h3 style=\"margin: auto 0cm;\"><span style=\"font-family: Arial;\" lang=\"EN-US\">Fix<\/span><\/h3>\n<p><span style=\"font-family: Arial;\" lang=\"EN-US\">The problem is because the term_id in the ar_payment_schedules_all table is not the same as the term_id in the ra_customer_trx_all table.<\/span><span style=\"font-family: Arial;\" lang=\"EN-US\">Check to see if there are any invoices where the terms are not equal.<\/span><span style=\"font-family: Arial;\" lang=\"EN-US\">SELECT p.payment_schedule_id ps_id,<br \/>\np.term_id ps_term_id,<br \/>\nt.term_id cu_term_id<br \/>\nFROM ra_customer_trx_all t,<br \/>\nar_payment_schedules_all p<br \/>\nWHERE t.customer_trx_id = p.customer_trx_id<br \/>\nAND t.term_id<\/span><\/p>\n<p>Please contact Oracle Support Services quoting this article to request a datafix.<\/p>\n<h3 style=\"margin: auto 0cm;\"><span style=\"font-family: Arial;\">References<\/span><\/h3>\n<p><span style=\"font-size: 12pt; font-family: Arial;\"><a href=\"https:\/\/metalink.oracle.com\/metalink\/plsql\/showdoc?db=Bug&amp;id=2510929\"><span lang=\"EN-US\">Bug 2510929<\/span><\/a><\/span><span style=\"font-size: 12pt; font-family: Arial;\" lang=\"EN-US\"> &#8211; Arxtw: App-Ar-11017 Receive Error When Trying To Apply Credit Memo To Invoice<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Rozwi\u0105zanie: nale\u017cy zmodyfikowa\u0107\u00a0 (term_id) warunek p\u0142atno\u015bci na formatce &#8222;transakcje&#8221; tak aby by\u0142 zgodny z tym z formatki &#8222;raty&#8221; informacje z metalinka: &nbsp; The information in this article applies to: Oracle Receivables &#8211; Version: 11.5 This problem can occur on any &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=218\">Czytaj dalej <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[22],"tags":[225,226],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/218"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=218"}],"version-history":[{"count":4,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":684,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions\/684"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}