\u00a0Por n\u00e3o ser poss\u00edvel remover os itens abaixo:<\/span><\/div>\n

Data Definition Code
\nData Definition Application
\nTemplate Code
\nTemplate Application
\nTemplate Type<\/div>\n

<\/div>\n

Devido a algum erro de digita\u00e7\u00e3o ou para dar um nome mais significativo de acordo com os padr\u00f5es, voc\u00ea n\u00e3o pode alterar esses campos mais tarde. Al\u00e9m disso, voc\u00ea tamb\u00e9m n\u00e3o pode exclu\u00ed-los. A Oracle recomenda desativ\u00e1-los, fornecendo uma data de t\u00e9rmino. Mas muitos desenvolvedores n\u00e3o gostam de deixar as coisas erradas no sistema. Eles gostam de apag\u00e1-los e recri\u00e1-los.
\nPor que a Oracle fez assim?
\nA raz\u00e3o \u00e9 que: o programa concorrente com sa\u00edda XML corresponde ao Nome Curto com o C\u00f3digo do Modelo para descobrir qual modelo de XML Publisher usar para p\u00f3s-processamento. Se voc\u00ea excluir este modelo, o Post Processor n\u00e3o consegue encontrar o modelo e, em seguida, dar erros. Portanto, \u00e9 sempre melhor n\u00e3o dar uma op\u00e7\u00e3o para atualizar ou excluir.
\nA solu\u00e7\u00e3o alternativa:
\n\u00c9 sempre recomend\u00e1vel ir para esta solu\u00e7\u00e3o alternativa em inst\u00e2ncias de desenvolvimento e N\u00c3O em qualquer produ\u00e7\u00e3o ou inst\u00e2ncia UAT. Depois de tornar perfeita a defini\u00e7\u00e3o e o modelo de dados na inst\u00e2ncia de desenvolvimento, voc\u00ea sempre pode migr\u00e1-los para a produ\u00e7\u00e3o por meio de utilit\u00e1rios FNDLOAD e XDOLOADER.
\nAntes da solu\u00e7\u00e3o alternativa, vejamos as tabelas principais que armazenam a informa\u00e7\u00e3o das Defini\u00e7\u00f5es e Modelos de Dados.<\/div>\n

<\/div>\n

XDO_DS_DEFINITIONS_B: table for storing data source definition represented by XML Schema Definition (XSD). Each data source has one or more elements, and this information are stored in XDO_DS_ELEMENTS_B.
\nXDO_DS_DEFINITIONS_TL: translation table for XDO_DS_DEFINITIONS_B.
\nXDO_LOBS: This table is used for storing locale (language and territory) sensitive binary and text files. It is mainly used for storing language layout templates.
\nXDO_CONFIG_VALUES: stores the values of XML Publisher configuration properties entered from the Oracle Applications interface.
\nXDO_TEMPLATES_B: table for template information. Each template has a corresponding data source definition stored in the XDO_DS_DEFINITIONS_B. Each translation of a certain template, not each template, has a corresponding physical template file. The physical template file information is stored in the XDO_LOBS.
\nXDO_TEMPLATES_TL: translation table for XDO_TEMPLATES_B.<\/div>\n

<\/div>\n

Consultas para Defini\u00e7\u00f5es de Dados:<\/div>\n

<\/div>\n

SELECT *\r\nFROM XDO_DS_DEFINITIONS_B\r\nWHERE DATA_SOURCE_CODE = 'XX_DATA_DEF_CODE';\r\n\r\nSELECT *\r\nFROM XDO_DS_DEFINITIONS_TL\r\nWHERE DATA_SOURCE_CODE = 'XX_DATA_DEF_CODE';\r\n\r\nSELECT *\r\nFROM XDO_LOBS\r\nWHERE LOB_CODE = 'XX_DATA_DEF_CODE';\r\n\r\nSELECT *\r\nFROM XDO_CONFIG_VALUES\r\nWHERE DATA_SOURCE_CODE = 'XX_DATA_DEF_CODE';\r\n\r\nDelete the Data Definitions:\r\n\r\n-- API to delete Data Definition from XDO_DS_DEFINITIONS_B and XDO_DS_DEFINITIONS_TL table\r\nBEGIN\r\nXDO_DS_DEFINITIONS_PKG.DELETE_ROW (<DATA_DEF_APP_NAME>,<DATA_DEF_CODE>);\r\nCOMMIT;\r\nEND;\r\n\r\n-- Delete Data Templates, xml schema etc. from XDO_LOBS table (There is no API)\r\nDELETE FROM XDO_LOBS\r\nWHERE LOB_CODE = <DATA_DEF_CODE>\r\nAND APPLICATION_SHORT_NAME = <DATA_DEF_APP_NAME>\r\nAND LOB_TYPE IN\r\n('XML_SCHEMA',\r\n'DATA_TEMPLATE',\r\n'XML_SAMPLE',\r\n'BURSTING_FILE');\r\n\r\n-- Delete from XDO_CONFIG_VALUES (if required)\r\nDELETE FROM XDO_CONFIG_VALUES\r\nWHERE APPLICATION_SHORT_NAME = <DATA_DEF_APP_NAME>\r\nAND DATA_SOURCE_CODE = <DATA_DEF_CODE>;\r\n\r\nQueries for the Templates:\r\n\r\nSELECT *\r\nFROM XDO_TEMPLATES_B\r\nWHERE TEMPLATE_CODE = 'XX_TEMPLATE_CODE';\r\n\r\nSELECT *\r\nFROM XDO_TEMPLATES_TL\r\nWHERE TEMPLATE_CODE = 'XX_TEMPLATE_CODE';\r\n\r\nSELECT *\r\nFROM XDO_LOBS\r\nWHERE LOB_CODE = 'XX_TEMPLATE_CODE';\r\n\r\nSELECT *\r\nFROM XDO_CONFIG_VALUES\r\nWHERE TEMPLATE_CODE = 'XX_TEMPLATE_CODE';\r\n\r\nDelete the templates:\r\n\r\n-- API to delete Data Definition from XDO_TEMPLATES_B and XDO_TEMPLATES_TL table\r\nBEGIN\r\nXDO_TEMPLATES_PKG.DELETE_ROW (<TEMPLATE_APP_NAME>, <TEMPLATE_CODE>);\r\nCOMMIT;\r\nEND;\r\n\r\n-- Delete the Templates from XDO_LOBS table (There is no API)\r\nDELETE FROM XDO_LOBS\r\nWHERE LOB_CODE = <TEMPLATE_CODE>\r\nAND APPLICATION_SHORT_NAME = <TEMPLATE_APP_NAME>\r\nAND LOB_TYPE IN ('TEMPLATE_SOURCE', 'TEMPLATE');\r\n\r\n-- Delete from XDO_CONFIG_VALUES (if required)\r\nDELETE FROM XDO_CONFIG_VALUES\r\nWHERE APPLICATION_SHORT_NAME = <TEMPLATE_APP_NAME>\r\nAND TEMPLATE_CODE = <TEMPLATE_CODE>\r\nAND DATA_SOURCE_CODE = <DATA_DEF_CODE>;<\/pre>\n <\/p>\n<\/div>\n
<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"
\u00a0Por n\u00e3o ser poss\u00edvel remover os itens abaixo: Data Definition Code Data Definition Application Template Code Template Application Template Type Devido a algum erro de… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,138],"tags":[],"class_list":["post-15245","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-sql"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15245","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=15245"}],"version-history":[{"count":1,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15245\/revisions"}],"predecessor-version":[{"id":15246,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15245\/revisions\/15246"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}