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

<\/p>\n

Boa tarde!<\/p>\n

Primeiramente obrigado a todos voc\u00eas que se dispuseram a me ajudar! Rodrigo Bueno, Marcelo Menezes, Vanessa Assun\u00e7\u00e3o, Rodrigo Andrade, Marco Vieira e Caio Mancini!<\/p>\n

N\u00e3o conseguimos determinar exatamente o que aconteceu, haviam v\u00e1rios eventos n\u00e3o processados no SLA referentes a Sales Order, e aparentemente eles foram ocasionados por conta da c\u00f3pia da Defini\u00e7\u00e3o Cont\u00e1bil da Aplica\u00e7\u00e3o (j\u00e1 que com a AAD Core conseguimos processar essas transa\u00e7\u00f5es).
Fizemos uma nova c\u00f3pia do AAD e as transa\u00e7\u00f5es foram processadas com sucesso!<\/p>\n

Abra\u00e7o a todos e obrigado!
<\/font><\/p>\n

Att.,<\/span><\/b><\/span><\/span><\/p>\n

<\/span><\/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 ou (55 | 35) 8722-2304
<\/span><\/span><\/p>\n

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

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

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

\n
To: <\/a>
From: <\/a><\/p>\n
Subject: C\u00f3pia do SLA do Cost Management<\/p>\n
<\/span> <\/p>\n
\n
\n
<\/p>\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
<\/span> <\/p>\n
\n
\n
<\/p>\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
, XAMR.PRODUCT_RULE_CODE<\/div>\n
, XAMR.PRODUCT_RULE_NAME<\/div>\n
, XPAH.EVENT_CLASS_NAME<\/div>\n
, XALDA.LINE_DEFINITION_CODE<\/div>\n
, XALDA.LINE_DEFINITION_NAME<\/div>\n
, XLDJA.DESCRIPTION_CODE<\/div>\n
, XLDJA.ACCOUNTING_LINE_CODE<\/div>\n
, XLDJA.ACCOUNTING_LINE_NAME<\/div>\n
, XLDAA.FLEXFIELD_SEGMENT_NAME<\/div>\n
, XLDAA.SEGMENT_RULE_CODE<\/div>\n
, XLDAA.SEGMENT_RULE_NAME<\/div>\n
FROM XLA_ACCTG_METHODS_FVL XAM<\/div>\n
, XLA_ACCTG_METHOD_RULES_FVL XAMR<\/div>\n
, XLA_PROD_ACCT_HEADERS_FVL XPAH<\/div>\n
, XLA_AAD_LINE_DEFN_ASSGNS_F_V XALDA<\/div>\n
, XLA_LINE_DEFN_JLT_ASSGNS_F_V XLDJA<\/div>\n
, XLA_LINE_DEFN_ADR_ASSGNS_F_V XLDAA<\/div>\n
WHERE XAM.ACCOUNTING_METHOD_CODE = XAMR.ACCOUNTING_METHOD_CODE<\/div>\n
AND XAMR.PRODUCT_RULE_CODE = XPAH.PRODUCT_RULE_CODE<\/div>\n
AND XAMR.PRODUCT_RULE_CODE = XPAH.PRODUCT_RULE_CODE<\/div>\n
AND XPAH.PRODUCT_RULE_CODE = XALDA.PRODUCT_RULE_CODE<\/div>\n
AND XPAH.EVENT_CLASS_CODE = XALDA.EVENT_CLASS_CODE<\/div>\n
AND XALDA.EVENT_CLASS_CODE = XLDJA.EVENT_CLASS_CODE<\/div>\n
AND XALDA.LINE_DEFINITION_CODE = XLDJA.LINE_DEFINITION_CODE<\/div>\n
AND XLDJA.LINE_DEFINITION_CODE = XLDAA.LINE_DEFINITION_CODE<\/div>\n
AND XLDJA.ACCOUNTING_LINE_CODE = XLDAA.ACCOUNTING_LINE_CODE<\/div>\n
–AND XAMR.APPLICATION_ID = 222<\/div>\n
AND NVL(XAMR.END_DATE_ACTIVE,SYSDATE+1) > SYSDATE<\/div>\n
AND UPPER(XALDA.LINE_DEFINITION_OWNER) = ‘USU\u00c1RIO’<\/div>\n
AND UPPER(XLDJA.ACCOUNTING_LINE_OWNER) = ‘USU\u00c1RIO’<\/div>\n
— AND XAM.ACCOUNTING_METHOD_CODE = ‘ODB_STANDARD_ACCRUAL’<\/div>\n
ORDER BY<\/div>\n
XAM.ACCOUNTING_METHOD_CODE<\/div>\n
, XAMR.PRODUCT_RULE_CODE<\/div>\n
, XPAH.EVENT_CLASS_NAME<\/div>\n
, XLDJA.ACCOUNTING_LINE_CODE<\/div>\n
, XLDAA.FLEXFIELD_SEGMENT_NAME<\/div>\n<\/div>\n
\n
<\/p>\n
\n
To: <\/a><\/a>
From: <\/a><\/a>
<\/span>Date: Tue, 14 Jul 2015 15:31:49 -0300
Subject: C\u00f3pia do SLA do Cost Management<\/p>\n
<\/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
<\/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 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>
Analista de Sistemas<\/span><\/b><\/span>
Consultor Funcional Oracle EBS<\/span><\/b><\/span>
phone.: (55|11) 98147-4684<\/a> ou (55 | 35) 8722-2304<\/a>
<\/span><\/span>
mail: <\/a>marcosfreitasmb@live.com<\/a><\/span><\/span><\/span>
skype: marcos.t.freitas<\/span><\/span>
linkedIN: br.linkedin.com\/in\/marcosfreitasmb<\/a><\/span><\/span> \t\t \t \t\t <\/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
<\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n<\/blockquote>\n<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n<\/p><\/div>\n
<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"
Boa tarde! Primeiramente obrigado a todos voc\u00eas que se dispuseram a me ajudar! Rodrigo Bueno, Marcelo Menezes, Vanessa Assun\u00e7\u00e3o, Rodrigo Andrade, Marco Vieira e… <\/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-6705","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\/6705","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=6705"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/6705\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}