Pessoal, bom dia\u00a0<\/span><\/p>\n

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

Consegui solucionar o problema conforme orienta\u00e7\u00e3o do consultor Fernando
\nPolo. Este problema \u00e9 devido a permiss\u00f5es em tabelas e View\u2019s que a\u00a0<\/span>API JL_BR_SPED_PUB\u00a0<\/span>utiliza.<\/span><\/p>\n

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

Ou seja, quando a API JL_BR_SPED_PUB \u00e9 executada corretamente, \u00e9 deletado
\na informa\u00e7\u00e3o do campo\u00a0SELECTED_FOR_RECEIPT_BATCH_ID (-999) \u00a0da tabela AR_PAYMENT_SCHEDULES_ALL e inserido
\na informa\u00e7\u00e3o na tabela\u00a0JL_BR_CUSTOMER_TRX_EXTS. Com isso \u00e9 poss\u00edvel gerar
\nos lotes de remessa no AR.<\/span><\/p>\n

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

Muito obrigada pela ajuda de todos.<\/span><\/p>\n

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

Abra\u00e7os.<\/span><\/p>\n

Patr\u00edcia Ramalho<\/span><\/p>\n

\u00a0<\/p>\n

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

<\/div>\n

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

2014-08-26 13:03 GMT-03:00 Marco Andr\u00e9 Takahashi marcoandretaka@yahoo.com.br<\/a> <<\/a>><\/span>:<\/p>\n

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

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

Talvez estejam falando do campo SELECTED_FOR_RECEIPT_BATCH_ID da AR_PAYMENT_SCHEDULES_ALL.
\nDependendo do valor que constar no campo torna eleg\u00edvel uma opera\u00e7\u00e3o conforme a ajuda do Walman.<\/p>\n

abs <\/p>\n

Marco Takahashi
\nOracle EBS Consultant – OTC
\n55 11 9898-5383
\n marcoandretaka@yahoo.com.br<\/a><\/p>\n

——————————————–
\nEm sex, 22\/8\/14, Walman Ribeiro walmanrcr@gmail.com<\/a> <<\/a>> escreveu:<\/p>\n

Assunto: Ajuda AR<\/div>\n

Para: <\/a>
\n Data: Sexta-feira, 22 de Agosto de 2014, 17:39<\/p>\n

\n \u00a0<\/p>\n

Patricia,
\n N\u00e3o sei se j\u00e1 resolveu ou n\u00e3o o
\n problema da remessa mas aqui vai…
\n quando vc configura uma origem e
\n tipo de transa\u00e7\u00e3o como sendo de NFe ou DFe o sistema
\n sempre gera as transa\u00e7\u00f5es no AR marcando um dos attributos
\n da tabela AR_PAYMENT_SCHEDULES_ALL como n\u00e3o eleg\u00edvel para
\n cobran\u00e7a, voc\u00ea precisa ANTES de criar a REMESSA receber o
\n ok da Synchro dizendo que a nota fiscal foi processada com
\n sucesso e autorizada a emiss\u00e3o.\u00a0
\n Quando isso ocorre, \u00a0o atributo da tabela
\n AR_PAYMENT_SCHEDULES_ALL “n\u00e3o me lembro exatamente
\n qual” \u00a0\u00e9 atualizado permitindo que este registro seja
\n eleg\u00edvel para remessa ou cobran\u00e7a manual, ou seja, se
\n existe uma falha no objeto (API) que atualiza essa
\n informa\u00e7\u00e3o de retorno, o campo n\u00e3o ser\u00e1 atualizado
\n automaticamente e sendo assim n\u00e3o ser\u00e1 eleg\u00edvel para
\n remessa at\u00e9 que esse atributo seja atualizado.
\n WORKAROUND ==>localize e efetue um update neste
\n atributo e teste novamente a remessa. Importante lembrar que
\n voc\u00ea precisa resolver a quest\u00e3o da API que por
\n consequ\u00eancia ir\u00e1 resolver o problema da
\n remessa.\u00a0<\/p>\n

Espero haver
\n ajudado.
\n Att,Walman
\n Ribeiro<\/p>\n

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

#yiv2921001375 #yiv2921001375 —
\n #yiv2921001375ygrp-mkp {<\/p>\n

\n border:1px solid #d8d8d8;font-family:Arial;margin:10px
\n 0;padding:0 10px;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375ygrp-mkp hr {
\n border:1px solid #d8d8d8;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-mkp #yiv2921001375hd {<\/p>\n

\n color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
\n 0;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375ygrp-mkp #yiv2921001375ads {
\n margin-bottom:10px;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-mkp .yiv2921001375ad {
\n padding:0 0;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-mkp .yiv2921001375ad p {
\n margin:0;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-mkp .yiv2921001375ad a {
\n color:#0000ff;text-decoration:none;}
\n #yiv2921001375 #yiv2921001375ygrp-sponsor
\n #yiv2921001375ygrp-lc {
\n font-family:Arial;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-sponsor
\n #yiv2921001375ygrp-lc #yiv2921001375hd {<\/p>\n

\n margin:10px
\n 0px;font-weight:700;font-size:78%;line-height:122%;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375ygrp-sponsor
\n #yiv2921001375ygrp-lc .yiv2921001375ad {<\/p>\n

\n margin-bottom:10px;padding:0 0;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375actions {<\/p>\n

\n font-family:Verdana;font-size:11px;padding:10px 0;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375activity {<\/p>\n

\n background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375activity span {
\n font-weight:700;}<\/p>\n

#yiv2921001375 #yiv2921001375activity span:first-child {
\n text-transform:uppercase;}<\/p>\n

#yiv2921001375 #yiv2921001375activity span a {
\n color:#5085b6;text-decoration:none;}<\/p>\n

#yiv2921001375 #yiv2921001375activity span span {
\n color:#ff7900;}<\/p>\n

#yiv2921001375 #yiv2921001375activity span
\n .yiv2921001375underline {
\n text-decoration:underline;}<\/p>\n

#yiv2921001375 .yiv2921001375attach {<\/p>\n

\n clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
\n 0;width:400px;}<\/p>\n<\/div>\n

#yiv2921001375 .yiv2921001375attach div a {
\n text-decoration:none;}<\/p>\n

#yiv2921001375 .yiv2921001375attach img {
\n border:none;padding-right:5px;}<\/p>\n

#yiv2921001375 .yiv2921001375attach label {
\n display:block;margin-bottom:5px;}<\/p>\n

#yiv2921001375 .yiv2921001375attach label a {
\n text-decoration:none;}<\/p>\n

#yiv2921001375 blockquote {<\/p>\n

\n margin:0 0 0 4px;}<\/p>\n<\/div>\n

#yiv2921001375 .yiv2921001375bold {<\/p>\n

\n font-family:Arial;font-size:13px;font-weight:700;}<\/p>\n<\/div>\n

#yiv2921001375 .yiv2921001375bold a {
\n text-decoration:none;}<\/p>\n

#yiv2921001375 dd.yiv2921001375last p a {
\n font-family:Verdana;font-weight:700;}<\/p>\n

#yiv2921001375 dd.yiv2921001375last p span {<\/p>\n

\n margin-right:10px;font-family:Verdana;font-weight:700;}<\/p>\n<\/div>\n

#yiv2921001375 dd.yiv2921001375last p
\n span.yiv2921001375yshortcuts {
\n margin-right:0;}<\/p>\n

#yiv2921001375 div.yiv2921001375attach-table div div a {
\n text-decoration:none;}<\/p>\n

#yiv2921001375 div.yiv2921001375attach-table {
\n width:400px;}<\/p>\n

#yiv2921001375 div.yiv2921001375file-title a, #yiv2921001375
\n div.yiv2921001375file-title a:active, #yiv2921001375
\n div.yiv2921001375file-title a:hover, #yiv2921001375
\n div.yiv2921001375file-title a:visited {
\n text-decoration:none;}<\/p>\n

#yiv2921001375 div.yiv2921001375photo-title a,
\n #yiv2921001375 div.yiv2921001375photo-title a:active,
\n #yiv2921001375 div.yiv2921001375photo-title a:hover,
\n #yiv2921001375 div.yiv2921001375photo-title a:visited {
\n text-decoration:none;}<\/p>\n

#yiv2921001375 div#yiv2921001375ygrp-mlmsg
\n #yiv2921001375ygrp-msg p a span.yiv2921001375yshortcuts {<\/p>\n

\n font-family:Verdana;font-size:10px;font-weight:normal;}<\/p>\n<\/div>\n

#yiv2921001375 .yiv2921001375green {
\n color:#628c2a;}<\/p>\n

#yiv2921001375 .yiv2921001375MsoNormal {<\/p>\n

\n margin:0 0 0 0;}<\/p>\n<\/div>\n

#yiv2921001375 o {
\n font-size:0;}<\/p>\n

#yiv2921001375 #yiv2921001375photos div {
\n float:left;width:72px;}<\/p>\n

#yiv2921001375 #yiv2921001375photos div div {<\/p>\n

\n border:1px solid
\n #666666;height:62px;overflow:hidden;width:62px;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375photos div label {<\/p>\n

\n color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375reco-category {
\n font-size:77%;}<\/p>\n

#yiv2921001375 #yiv2921001375reco-desc {
\n font-size:77%;}<\/p>\n

#yiv2921001375 .yiv2921001375replbq {
\n margin:4px;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-actbar div a:first-child {
\n margin-right:2px;padding-right:5px;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-mlmsg {<\/p>\n

\n font-size:13px;font-family:Arial, helvetica, clean,
\n sans-serif;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375ygrp-mlmsg table {
\n font-size:inherit;font:100%;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-mlmsg select,
\n #yiv2921001375 input, #yiv2921001375 textarea {<\/p>\n

\n font:99% Arial, Helvetica, clean, sans-serif;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375ygrp-mlmsg pre, #yiv2921001375
\n code {
\n font:115% monospace;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-mlmsg * {
\n line-height:1.22em;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-mlmsg #yiv2921001375logo {
\n padding-bottom:10px;}<\/p>\n

\n #yiv2921001375 #yiv2921001375ygrp-msg p a {
\n font-family:Verdana;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-msg
\n p#yiv2921001375attach-count span {
\n color:#1E66AE;font-weight:700;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-reco
\n #yiv2921001375reco-head {
\n color:#ff7900;font-weight:700;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-reco {
\n margin-bottom:20px;padding:0px;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-sponsor #yiv2921001375ov<\/p>\n

\n li a {
\n font-size:130%;text-decoration:none;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375ygrp-sponsor #yiv2921001375ov<\/p>\n

\n li {
\n font-size:77%;list-style-type:square;padding:6px 0;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375ygrp-sponsor #yiv2921001375ov<\/p>\n

\n ul {
\n margin:0;padding:0 0 0 8px;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375ygrp-text {
\n font-family:Georgia;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-text p {<\/p>\n

\n margin:0 0 1em 0;}<\/p>\n<\/div>\n

#yiv2921001375 #yiv2921001375ygrp-text tt {
\n font-size:120%;}<\/p>\n

#yiv2921001375 #yiv2921001375ygrp-vital ul li:last-child {
\n border-right:none !important;
\n }
\n #yiv2921001375 <\/p>\n<\/p><\/div>\n

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

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

__._,_.___<\/div>\n

<\/div>\n

Posted by: Patricia Ramalho <rpatriciaramalho@gmail.com>\n <\/p><\/div>\n

<\/div>\n

Reply via web post<\/a><\/p>\n

•<\/p>\n

\n Reply to sender <\/a><\/p>\n

•<\/p>\n

\n Reply to group <\/a><\/p>\n

•<\/p>\n

Start a New Topic<\/a><\/p>\n

•<\/p>\n

Messages in this topic<\/a>
\n (7)<\/p>\n

Visit Your Group<\/a><\/span><\/p>\n

New Members<\/a><\/span>
\n 2<\/span><\/p><\/div>\n

\n $\"Yahoo!$ <\/a><\/p>\n

• Privacy<\/a> • Unsubscribe<\/a> • Terms of Use<\/a> <\/div>\n<\/div>\n

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

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

.<\/div>\n<\/div>\n

<\/p>\n

__,_._,___<\/div>\n

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

Pessoal, bom dia\u00a0 \u00a0 Consegui solucionar o problema conforme orienta\u00e7\u00e3o do consultor Fernando Polo. Este problema \u00e9 devido a permiss\u00f5es em tabelas e View\u2019s… <\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56],"tags":[],"class_list":["post-4178","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/4178","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"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4178"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/4178\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}