{"id":6661,"date":"2015-07-14T17:31:49","date_gmt":"2015-07-14T18:31:49","guid":{"rendered":"http:\/\/www.orabr.com\/?p=6661"},"modified":"2015-07-14T20:04:12","modified_gmt":"2015-07-14T23:04:12","slug":"-COPIA-DO-SLA-DO-COST-MANAGEMENT-4","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=6661","title":{"rendered":"C\u00d3PIA DO SLA DO COST MANAGEMENT"},"content":{"rendered":"

<\/p>\n

 <\/span> <\/p>\n
\n
<\/p>\n
\n

Marcos.<\/p>\n
<\/div>\n
Voc\u00ea est\u00e1 usando o SLA core do Cost Management? Para manufatura?<\/div>\n
Informo que ele n\u00e3o funciona. A conta de origem que vem de f\u00e1brica n\u00e3o pega nada. Tem que copiar o SLA inteiro para o owner user e fazer suas pr\u00f3prias.<\/div>\n
E tanto faz se estiver fazendo o do OPM ou o da Discreta.<\/div>\n
<\/div>\n
Quando a gente implanta o OPM Financials a primeira coisa que se faz j\u00e1 \u00e9 sair copiando o AAD daquilo que temos certeza que vai funcionar.<\/div>\n
<\/div>\n
\u00c9 isso?<\/div>\n
<\/div>\n<\/div>\n

<\/p>\n
\n
\n
________________________________
Caio M. S. Mancini<\/b>
Oracle EBS Manufacturing Consultant
<\/a>http:\/\/br.linkedin.com\/in\/caiomancini<\/a>
<\/span>
Phone: +55 11 98675 1205
Skype: caiomsmancini
GTalk: caio.mancini
ICQ #177165688
<\/font>________________________________<\/div>\n<\/div>\n<\/div>\n

<\/p>\n

2015-07-14 16:04 GMT-03:00 Rodrigo Andrade Bueno <\/a>rodrigo_andbueno@hotmail.com<\/a> <<\/a><\/a>><\/span>:<\/p>\n

<\/u> <\/p>\n

\u00a0<\/span> <\/p>\n
\n
\n
\n
\n
Marcos,<\/div>\n
<\/div>\n

Verifique tamb\u00e9m, se ha caracter set no nome da defini\u00e7\u00e3o, pois todo relacionamento no sla \u00e9 feito pelo nome e n\u00e3o por um ID, como de costume.<\/p>\n

<\/div>\n
Abaixo um select para ajudar nas tabelas.<\/div>\n
<\/div>\n
Abs<\/div>\n
<\/div>\n
<\/div>\n
\n
SELECT XAM.ACCOUNTING_METHOD_CODE<\/div>\n
\u00a0 \u00a0 \u00a0, XAMR.PRODUCT_RULE_CODE<\/div>\n
\u00a0 \u00a0 \u00a0, XAMR.PRODUCT_RULE_NAME<\/div>\n
\u00a0 \u00a0 \u00a0, XPAH.EVENT_CLASS_NAME<\/div>\n
\u00a0 \u00a0 \u00a0, XALDA.LINE_DEFINITION_CODE<\/div>\n
\u00a0 \u00a0 \u00a0, XALDA.LINE_DEFINITION_NAME<\/div>\n
\u00a0 \u00a0 \u00a0, XLDJA.DESCRIPTION_CODE<\/div>\n
\u00a0 \u00a0 \u00a0, XLDJA.ACCOUNTING_LINE_CODE<\/div>\n
\u00a0 \u00a0 \u00a0, XLDJA.ACCOUNTING_LINE_NAME<\/div>\n
\u00a0 \u00a0 \u00a0, XLDAA.FLEXFIELD_SEGMENT_NAME<\/div>\n
\u00a0 \u00a0 \u00a0, XLDAA.SEGMENT_RULE_CODE<\/div>\n
\u00a0 \u00a0 \u00a0, XLDAA.SEGMENT_RULE_NAME<\/div>\n
\u00a0 FROM XLA_ACCTG_METHODS_FVL \u00a0 \u00a0 \u00a0 \u00a0XAM<\/div>\n
\u00a0 \u00a0 \u00a0, XLA_ACCTG_METHOD_RULES_FVL \u00a0 XAMR<\/div>\n
\u00a0 \u00a0 \u00a0, XLA_PROD_ACCT_HEADERS_FVL \u00a0 \u00a0XPAH<\/div>\n
\u00a0 \u00a0 \u00a0, XLA_AAD_LINE_DEFN_ASSGNS_F_V XALDA<\/div>\n
\u00a0 \u00a0 \u00a0, XLA_LINE_DEFN_JLT_ASSGNS_F_V XLDJA<\/div>\n
\u00a0 \u00a0 \u00a0, XLA_LINE_DEFN_ADR_ASSGNS_F_V XLDAA<\/div>\n
WHERE XAM.ACCOUNTING_METHOD_CODE \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= XAMR.ACCOUNTING_METHOD_CODE<\/div>\n
\u00a0 \u00a0AND XAMR.PRODUCT_RULE_CODE \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= XPAH.PRODUCT_RULE_CODE<\/div>\n
\u00a0 \u00a0AND XAMR.PRODUCT_RULE_CODE \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= XPAH.PRODUCT_RULE_CODE<\/div>\n
\u00a0 \u00a0AND XPAH.PRODUCT_RULE_CODE \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= XALDA.PRODUCT_RULE_CODE<\/div>\n
\u00a0 \u00a0AND XPAH.EVENT_CLASS_CODE \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 = XALDA.EVENT_CLASS_CODE<\/div>\n
\u00a0 \u00a0AND XALDA.EVENT_CLASS_CODE \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= XLDJA.EVENT_CLASS_CODE<\/div>\n
\u00a0 \u00a0AND XALDA.LINE_DEFINITION_CODE \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= XLDJA.LINE_DEFINITION_CODE<\/div>\n
\u00a0 \u00a0AND XLDJA.LINE_DEFINITION_CODE \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= XLDAA.LINE_DEFINITION_CODE<\/div>\n
\u00a0 \u00a0AND XLDJA.ACCOUNTING_LINE_CODE \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= XLDAA.ACCOUNTING_LINE_CODE<\/div>\n
\u00a0 \u00a0–AND XAMR.APPLICATION_ID \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 = 222<\/div>\n
\u00a0 \u00a0AND NVL(XAMR.END_DATE_ACTIVE,SYSDATE+1) > SYSDATE<\/div>\n
\u00a0 \u00a0AND UPPER(XALDA.LINE_DEFINITION_OWNER) \u00a0= 'USU\u00c1RIO'<\/div>\n
\u00a0 \u00a0AND UPPER(XLDJA.ACCOUNTING_LINE_OWNER) \u00a0= 'USU\u00c1RIO'<\/div>\n
— \u00a0 AND XAM.ACCOUNTING_METHOD_CODE \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= 'ODB_STANDARD_ACCRUAL'<\/div>\n
ORDER BY<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0XAM.ACCOUNTING_METHOD_CODE<\/div>\n
\u00a0 \u00a0 \u00a0, XAMR.PRODUCT_RULE_CODE<\/div>\n
\u00a0 \u00a0 \u00a0, XPAH.EVENT_CLASS_NAME<\/div>\n
\u00a0 \u00a0 \u00a0, XLDJA.ACCOUNTING_LINE_CODE<\/div>\n
\u00a0 \u00a0 \u00a0, XLDAA.FLEXFIELD_SEGMENT_NAME<\/div>\n<\/div>\n
\n
<\/p>\n
\n

To: <\/a><\/a>
From: <\/a><\/a>
<\/span>
Subject: C\u00f3pia do SLA do Cost Management<\/p>\n

\u00a0<\/span> <\/p>\n

\n
\n
<\/p>\n
Marcos,<\/p>\n
<\/div>\n
Verifique se todos os eventos da c\u00f3pia est\u00e3o validados.<\/div>\n
<\/div>\n
Abs<\/div>\n
<\/div>\n
Marcelo Menezes<\/p>\n
\n
\n

To: <\/a><\/a>
From: <\/a><\/a>
Date: Tue, 14 Jul 2015 14:22:29 -0300
Subject: C\u00f3pia do SLA do Cost Management<\/p>\n

\u00a0<\/span> <\/p>\n

\n
\n
<\/p>\n

<\/font>Boa tarde Grupo!<\/p>\n

Est\u00e1vamos com alguns problemas para processar as transa\u00e7\u00f5es de custo de venda no CM. Ap\u00f3s v\u00e1rias tentativas vimos que o nosso problema estava ocorrendo apenas quando est\u00e1vamos usando uma c\u00f3pia do SLA do Cost Management.
Algu\u00e9m j\u00e1 teve um problema semelhante e tem alguma refer\u00eancia do metalink sobre isso? (Tenho procurado aqui no metalink mas n\u00e3o achei nenhum bug ou\u00a0 note referente a c\u00f3pia de Defini\u00e7\u00e3o Cont\u00e1bil da Aplica\u00e7\u00e3o do CM no SLA).<\/p>\n

Agrade\u00e7o antecipadamente a ajuda!<\/p>\n

Abra\u00e7os,
Marcos<\/p>\n

Marcos Freitas<\/span><\/b><\/span><\/p>\n

Analista de Sistemas<\/span><\/b><\/span><\/p>\n

Consultor Funcional Oracle EBS<\/span><\/b><\/span><\/p>\n

phone.: (55|11) 98147-4684<\/a> ou (55 | 35) 8722-2304<\/a>
<\/span><\/span><\/p>\n

mail: <\/a>marcosfreitasmb@live.com<\/a><\/span><\/span><\/span><\/p>\n

skype: marcos.t.freitas<\/span><\/span><\/p>\n

linkedIN:\u00a0br.linkedin.com\/in\/marcosfreitasmb<\/a><\/span><\/span><\/p>\n<\/p><\/div>\n

<\/div>\n

<\/div>\n<\/p><\/div>\n<\/div><\/div>\n<\/p><\/div>\n<\/div>\n

<\/div>\n

<\/div>\n<\/p><\/div>\n<\/div>\n

\t\t \t \t\t <\/span><\/div>\n<\/p><\/div>\n<\/div>\n<\/p><\/div>\n

<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n<\/blockquote>\n<\/div>\n

<\/div>\n<\/p><\/div>\n

<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"

  Marcos. Voc\u00ea est\u00e1 usando o SLA core do Cost Management? Para manufatura? Informo que ele n\u00e3o funciona. A conta de origem que vem de… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56],"tags":[77,99,105,76,103,104,97,98,107,102,108,72,100,85,87,59,89,101,106,46,84],"class_list":["post-6661","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-adf","tag-applications","tag-atg-financials","tag-banco-de-dados","tag-dadabase","tag-dba","tag-duvidas-e-repostas-oracle-vagas","tag-ebs","tag-etl","tag-fusion","tag-hyperion","tag-java","tag-odi","tag-oracle-apex","tag-oracle-forms","tag-oracle-oportunidades","tag-oracle-reports","tag-people-soft","tag-plsql-bi","tag-soa","tag-supply-chain"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/6661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6661"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/6661\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}