<\/p>\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

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 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

To: <\/a>
From: <\/a><\/p>\n

Subject: C\u00f3pia do SLA do Cost Management<\/p>\n

<\/span> <\/p>\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

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

<\/span> <\/p>\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><\/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<\/p><\/div>\n

<\/div>\n