{"id":18334,"date":"2019-05-23T09:39:13","date_gmt":"2019-05-23T12:39:13","guid":{"rendered":"https:\/\/orabr.com\/?p=18334"},"modified":"2019-05-23T09:43:54","modified_gmt":"2019-05-23T12:43:54","slug":"-referencia-a-forms-distintos-em-1-valueset","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=18334","title":{"rendered":"Refer\u00eancia a forms distintos em 1 ValueSet"},"content":{"rendered":"

<\/p>\n

 <\/span> <\/p>\n
\n
<\/p>\n
\n
\n
\n
\n
Bom dia a todos.<\/div>\n
<\/div>\n
Algu\u00e9m sabe uma forma de usar em um value set referencias a forms e blocos distintos.<\/div>\n
<\/div>\n
O flexfield na linha da requisi\u00e7\u00e3o de compras <\/span><\/span>\u00e9 usado em 2 forms: cria\u00e7\u00e3o (POXRQERQ) e consulta(POXRQVRQ)<\/div>\n
No forms POXRQERQ o bloco \u00e9 o LINES<\/span><\/div>\n
No forms POXRQVRQ o bloco \u00e9 o REQ_LINES_FOLDER<\/span><\/div>\n

<\/span><\/div>\n
Se no value set uso “:REQ_LINES_FOLDER.ITEM_ID” d\u00e1 erro na tela cria\u00e7\u00e3o<\/span><\/div>\n
Se no value set uso “:LINES.ITEM_ID” da erro na tela de consulta.<\/span><\/div>\n

<\/span><\/div>\n
J\u00e1 tentei via DECODE, NVL, OR, etc. Mas nenhum forma foi bem sucedida.<\/span><\/div>\n
Basta ter a refer\u00eancia ao bloco do outro forms para dar erro:<\/span><\/div>\n

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

APP-FND-01242: Cannot read value from field LINE.ITEM_ID<\/b><\/span><\/p><\/blockquote>\n


<\/b><\/span><\/p><\/blockquote>\n

Cause:  The field LINE.ITEM_ID could not be located or read.<\/b><\/span><\/p><\/blockquote>\n


<\/b><\/span><\/p><\/blockquote>\n

Action:  This error is normally the result of an incorrectly-entered field name string in a trigger, or a field name string that does not uniquely specify a field in your form.  Correct your trigger logic to precisely specify a valid field.<\/b><\/span><\/p><\/blockquote>\n<\/blockquote>\n

<\/p>\n
<\/div>\n
Outra tentativa foi usar uma personaliza\u00e7\u00e3o em cada forms para setar uma GLOBAL.<\/div>\n
<\/div>\n

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

GLOBAL.ITEM_ID := LINES.ITEM_ID ou <\/span>GLOBAL.ITEM_ID := REQ_LINES_FOLDER.ITEM dependendo do forms.<\/div>\n

<\/span><\/div>\n
E no value set usaria :GLOBAL.ITEM_ID para ambos os forms.<\/span><\/div>\n
O problema \u00e9 que na consulta F11 – CTRL F11, n\u00e3o dispara o evento para cada registro antes de executar a query do ValueSet.<\/span><\/div>\n

<\/span><\/div>\n
Algu\u00e9m sabe se tem uma forma de usar “:SYSTEM.CURRENT_FORM”.ITEM_ID dentro do ValueSet?<\/div>\n
Se isso for poss\u00edvel funcionaria para ambos os forms\/bloco.<\/div>\n
<\/div>\n
<\/div>\n
Qualquer ajuda bem nesse sentido \u00e9 bem vinda.<\/div>\n
<\/div>\n
Obrigado.<\/div>\n
Helder Costa Amaral<\/div>\n<\/div>\n

<\/div>\n

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

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

  Bom dia a todos. Algu\u00e9m sabe uma forma de usar em um value set referencias a forms e blocos distintos. O flexfield na linha… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56],"tags":[],"class_list":["post-18334","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18334","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=18334"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18334\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}