{"id":7537,"date":"2015-09-08T12:27:14","date_gmt":"2015-09-08T13:27:14","guid":{"rendered":"http:\/\/www.orabr.com\/?p=7537"},"modified":"2015-09-08T10:30:01","modified_gmt":"2015-09-08T13:30:01","slug":"-SEQUENCIA-DE-NUMERACAO-OMBILLING-5","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=7537","title":{"rendered":"SEQU\u00caNCIA DE NUMERA\u00c7\u00c3O OM\/BILLING"},"content":{"rendered":"

<\/p>\n

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

Oi Wendel,<\/p>\n
<\/div>\n
Aqui \u00e9 R11 e j\u00e1 tinha feito tudo isso…tanto para RA como JL. Mas n\u00e3o est\u00e1 dando certo.<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
Obrigada!<\/div>\n
<\/div>\n
<\/div>\n
<\/p>\n
2015-09-08 10:23 GMT-03:00 wendel andrade <\/a>wendelandrade2002@yahoo.com.br<\/a> <<\/a><\/a>><\/span>:<\/p>\n

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

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

Ol\u00e1 Vania, <\/p>\n

N\u00e3o sei se \u00e9 R11 ou R12 no seu caso, mas tive este problema j\u00e1 na R11 pois existem 2 sequences, a JL e a RA, depois de alguns patches de localiza\u00e7\u00e3o.
Voc\u00ea pode verificar com esta query, colocando o nome da sua origem:<\/p>\n

select rbs.name<\/a>, rbs.batch_source_id,org_id
from apps.RA_BATCH_SOURCES_ALL rbs
where rbs.org_id is not null
and rbs.created_by <> -1
AND rbs.name<\/a> IN ('BR SP TRX MERC IMP', 'BR SP TRX MERC MANUAL') — ,'NFF-e AUTOMATICA')
;<\/p>\n

Com o resultado encontrado voc\u00ea verifica as origens manuais assim:
SELECT *
FROM dba_sequences ao
WHERE ao.sequence_name IN ( 'JL_BR_TRX_NUM_1448_914_S'
,'JL_BR_TRX_NUM_1456_914_S'
,'RA_TRX_NUMBER_1448_914_S'
,'RA_TRX_NUMBER_1456_914_S'
);<\/p>\n

O pulo do gato est\u00e1 no sin\u00f4nimos, verifique assim:
SELECT *
FROM all_synonyms
WHERE synonym_name in ( 'JL_BR_TRX_NUM_1041_43_S'
,'RA_TRX_NUMBER_1041_43_S')<\/p>\n

mande parar tudo e recria tudo certinho agora:
—
— Dropa sequences
—
DROP SEQUENCE JL_BR_TRX_NUM_1020_43_S;
DROP SEQUENCE RA_TRX_NUMBER_1020_43_S;<\/p>\n

DROP SEQUENCE AR.RA_TRX_NUMBER_1200_43_S;
DROP SEQUENCE AR.RA_TRX_NUMBER_1201_43_S;
—
— Recria Automatica( n\u00e3o esquece de pegar o ultimo numero)
—
create SEQUENCE AR.RA_TRX_NUMBER_1200_43_S MINVALUE 1 START WITH 4000 INCREMENT BY 1 NOCACHE;
create SEQUENCE JL.JL_BR_TRX_NUM_1200_43_S MINVALUE 1 START WITH 4000 INCREMENT BY 1 NOCACHE;<\/p>\n

— sinonimo para Automatica
CREATE SYNONYM JL_BR_TRX_NUM_1200_43_S FOR JL.JL_BR_TRX_NUM_1041_43_S;<\/p>\n

— MANUAL
create SEQUENCE AR.RA_TRX_NUMBER_1201_43_S MINVALUE 1 START WITH 100 INCREMENT BY 1 NOCACHE;
create SEQUENCE JL.JL_BR_TRX_NUM_1201_43_S MINVALUE 1 START WITH 100 INCREMENT BY 1 NOCACHE;<\/p>\n

— sinonimo para Manual (Aqui \u00e9 o segredo de tudo, pois a manual aponta para a autom\u00e1tica)
CREATE SYNONYM JL_BR_TRX_NUM_1201_43_S FOR JL.JL_BR_TRX_NUM_1041_43_S;<\/p>\n

Se voc\u00ea n\u00e3o quizer dropar a sequence e s\u00f3 o sin\u00f4nimo tamb\u00e9m daria certo, mas como sempre temos problema de cache, ent\u00e3o eu sempre fa\u00e7o tudo.<\/p>\n

Espero que gte ajude.<\/p>\n

Wendel
——————————————–
Em ter, 8\/9\/15, Vania Giorgi Lopes Puerta <\/a>vania.lopesp@gmail.com<\/a> <<\/a><\/a>> escreveu:<\/p>\n

Assunto: Sequ\u00eancia de Numera\u00e7\u00e3o OM\/Billing
Para: <\/a><\/a>
Data: Ter\u00e7a-feira, 8 de Setembro de 2015, 10:07<\/p>\n

\u00a0<\/p>\n

Oi Sergio,
Fiz sim, tudo
normalmente…
2015-09-08 10:06 GMT-03:00
Sergio Eduardo da Silva <\/a>srg_silva@yahoo.com.br<\/a>
<<\/a><\/a>>:<\/p>\n

\u00a0<\/p>\n

Vania bom
dia.
Como est\u00e3o
configuradas as origens Autom\u00e1tica e Manual no
<\/span> AR?Vc fez a associa\u00e7\u00e3o na origem
manual com a autom\u00e1tica?
Abra\u00e7os
_________________________________\u00a0Sergio
Eduardo da Silva\u00a0\u00a043
9114-9479<\/p>\n

<\/span> De:
"Vania Giorgi Lopes Puerta <\/a>vania.lopesp@gmail.com<\/a>
" <<\/a><\/a>>
Para: <\/a><\/a><\/p>\n

Enviadas: Ter\u00e7a-feira,
8 de Setembro de 2015 9:54
Assunto:
Sequ\u00eancia de Numera\u00e7\u00e3o OM\/Billing<\/p>\n

\u00a0<\/p>\n

Bom dia grupo!!
Estou usando uma Origem Autom\u00e1tica
no OM e a sequencia est\u00e1 OK quando fa\u00e7o a importa\u00e7\u00e3o no
Billing.
Mas estou
tentando fazer uma NF Manual usando como sequencia essa
mesma origem autom\u00e1tica do OM, para exatamente respeitar a
sequence criada, mas ele n\u00e3o respeita, simplesmente repete
a numera\u00e7\u00e3o.<\/p>\n

Algu\u00e9m j\u00e1 passou por
isso?<\/p>\n

Obrigada!<\/p>\n

<\/span> #yiv8518962352 #yiv8518962352 —
#yiv8518962352ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}<\/p>\n

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

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

#yiv8518962352 #yiv8518962352ygrp-mkp #yiv8518962352ads {
margin-bottom:10px;}<\/p>\n

#yiv8518962352 #yiv8518962352ygrp-mkp .yiv8518962352ad {
padding:0 0;}<\/p>\n

#yiv8518962352 #yiv8518962352ygrp-mkp .yiv8518962352ad p {
margin:0;}<\/p>\n

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

#yiv8518962352 #yiv8518962352ygrp-sponsor
#yiv8518962352ygrp-lc #yiv8518962352hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}<\/p>\n

#yiv8518962352 #yiv8518962352ygrp-sponsor
#yiv8518962352ygrp-lc .yiv8518962352ad {
margin-bottom:10px;padding:0 0;}<\/p>\n

#yiv8518962352 #yiv8518962352actions {
font-family:Verdana;font-size:11px;padding:10px 0;}<\/p>\n

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

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

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

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

#yiv8518962352 #yiv8518962352activity span span {
color:#ff7900;}<\/p>\n

#yiv8518962352 #yiv8518962352activity span
.yiv8518962352underline {
text-decoration:underline;}<\/p>\n

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

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

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

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

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

#yiv8518962352 blockquote {
margin:0 0 0 4px;}<\/p>\n

#yiv8518962352 .yiv8518962352bold {
font-family:Arial;font-size:13px;font-weight:700;}<\/p>\n

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

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

#yiv8518962352 dd.yiv8518962352last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}<\/p>\n

#yiv8518962352 dd.yiv8518962352last p
span.yiv8518962352yshortcuts {
margin-right:0;}<\/p>\n

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

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

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

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

#yiv8518962352 div#yiv8518962352ygrp-mlmsg
#yiv8518962352ygrp-msg p a span.yiv8518962352yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}<\/p>\n

#yiv8518962352 .yiv8518962352green {
color:#628c2a;}<\/p>\n

#yiv8518962352 .yiv8518962352MsoNormal {
margin:0 0 0 0;}<\/p>\n

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

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

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

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

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

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

#yiv8518962352 .yiv8518962352replbq {
margin:4px;}<\/p>\n

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

#yiv8518962352 #yiv8518962352ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}<\/p>\n

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

#yiv8518962352 #yiv8518962352ygrp-mlmsg select,
#yiv8518962352 input, #yiv8518962352 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}<\/p>\n

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

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

#yiv8518962352 #yiv8518962352ygrp-mlmsg #yiv8518962352logo {
padding-bottom:10px;}<\/p>\n

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

#yiv8518962352 #yiv8518962352ygrp-msg
p#yiv8518962352attach-count span {
color:#1E66AE;font-weight:700;}<\/p>\n

#yiv8518962352 #yiv8518962352ygrp-reco
#yiv8518962352reco-head {
color:#ff7900;font-weight:700;}<\/p>\n

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

#yiv8518962352 #yiv8518962352ygrp-sponsor #yiv8518962352ov
li a {
font-size:130%;text-decoration:none;}<\/p>\n

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

#yiv8518962352 #yiv8518962352ygrp-sponsor #yiv8518962352ov
ul {
margin:0;padding:0 0 0 8px;}<\/p>\n

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

#yiv8518962352 #yiv8518962352ygrp-text p {
margin:0 0 1em 0;}<\/p>\n

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

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

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

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

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

  Oi Wendel, Aqui \u00e9 R11 e j\u00e1 tinha feito tudo isso…tanto para RA como JL. Mas n\u00e3o est\u00e1 dando certo. Obrigada! 2015-09-08 10:23 GMT-03:00… <\/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-7537","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\/7537","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=7537"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/7537\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}