{"id":246,"date":"2007-09-05T11:28:09","date_gmt":"2007-09-05T09:28:09","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=246"},"modified":"2012-03-09T17:25:44","modified_gmt":"2012-03-09T15:25:44","slug":"transakcja-nie-maja-dekretacji-cheman","status":"publish","type":"post","link":"http:\/\/oracle.malin.pl\/?p=246","title":{"rendered":"Transakcja nie maj\u0105 dekretacji"},"content":{"rendered":"<p>Transakcja nie mia\u0142a koszt\u00f3w  na magazynie.<br \/>\nPrzyczyn\u0105 by\u0142o to ze  jedna transakcja wcze\u015bniej  zwi\u0105zana z ZZM-k\u0105 zako\u0144czy\u0142a si\u0119 z b\u0142\u0119dem 'E&#8217;:<\/p>\n<p><!--more--><\/p>\n<p>Mo\u017cna  to sprawdzi\u0107 selektem:<\/p>\n<p>select ood.ORGANIZATION_CODE,mmt.costed_flag,count(*) from inv.mtl_material_transactions mmt,APPS.Org_Organization_Definitions ood where<br \/>\nmmt.costed_flag in (&#8217;E&#8217;,&#8217;N&#8217;)<br \/>\nand mmt.organization_id=ood.ORGANIZATION_ID<br \/>\ngroup by ood.ORGANIZATION_CODE,mmt.costed_flag;<\/p>\n<p>W tabeli mtl_material_transactions zapisane jest error_code no error, error_explanation: error<br \/>\nCSTPLCIN.COST_INV_TXN:CSTPLENG.calc_layer_average_cost (12): ORA-01476: divisor is equal to zero.<\/p>\n<p>Rozwi\u0105zaniem jest:<\/p>\n<p>-Wy\u0142\u0105czy\u0107 managera koszt\u00f3w,<br \/>\n-zmieni\u0107 flage E na pust\u0105 z kolumny costed_flag w tabeli mtl_material_transactions<\/p>\n<p>-w\u0142\u0105czy\u0107 managera koszt\u00f3w<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Transakcja nie mia\u0142a koszt\u00f3w na magazynie. Przyczyn\u0105 by\u0142o to ze jedna transakcja wcze\u015bniej zwi\u0105zana z ZZM-k\u0105 zako\u0144czy\u0142a si\u0119 z b\u0142\u0119dem 'E&#8217;:<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[225,226],"_links":{"self":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/246"}],"collection":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=246"}],"version-history":[{"count":2,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/246\/revisions"}],"predecessor-version":[{"id":638,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/246\/revisions\/638"}],"wp:attachment":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=246"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}