Useful Scripts for Vertex Configuration

-- Instance Name
SELECT INSTANCE_NAME FROM V$INSTANCE;

-- Vertex OIC Conf
SELECT * FROM VERTEX_OIC_CONFIGURATION;

-- Vertex OIC OD Conf
SELECT * FROM VERTEX_OIC_OD_CONFIGURATION;

-- Vertex End Point
SELECT 'VERTEX_SERVICE_ENDPOINT', VERTEX_SERVICE_ENDPOINT.*
  FROM VERTEX_SERVICE_ENDPOINT
 WHERE VER_ORACLE_INSTANCE = (SELECT INSTANCE_NAME FROM V$INSTANCE)
UNION ALL
SELECT 'VERTEX_SERVICE_OD_ENDPOINT', VERTEX_SERVICE_OD_ENDPOINT.*
  FROM VERTEX_SERVICE_OD_ENDPOINT
 WHERE VER_ORACLE_INSTANCE = (SELECT INSTANCE_NAME FROM V$INSTANCE);

-- Vertex Regime User
SELECT 'VERTEX_TAX_REGIME_USER', VERTEX_TAX_REGIME_USER.*
  FROM VERTEX_TAX_REGIME_USER
UNION ALL
SELECT 'VERTEX_TAX_REGIME_OD_USER', VERTEX_TAX_REGIME_OD_USER.*
  FROM VERTEX_TAX_REGIME_OD_USER;

SELECT * FROM VERTEX_OIC_VERSION;

SELECT * FROM tax_link_version_history;

SELECT COUNT (*)
  FROM dba_objects
 WHERE status = 'INVALID' AND owner = 'XXVTX';

SELECT DATA_SOURCE_CODE,
       TEMPLATE_TYPE_CODE,
       TEMPLATE_NAME,
       OBJECT_VERSION_NUMBER AS VER
  FROM apps.XDO_Templates_VL
 WHERE (   UPPER (Template_NAME) LIKE '%VERTEX%'
        OR UPPER (APPLICATION_SHORT_NAME) LIKE '%V%T%X%');

  SELECT A.Concurrent_Program_name,
         A.USER_CONCURRENT_PROGRAM_NAME,
         B.Application_Short_Name
    FROM apps.FND_CONCURRENT_PROGRAMS_vl A, apps.FND_APPLICATION B
   WHERE     A.application_id = B.APPLICATION_ID
         AND     B.application_Short_name LIKE 'XXVTX%'
ORDER BY User_concurrent_program_name DESC;

SELECT *
  FROM dba_objects
 WHERE owner = 'XXVTX' AND object_name LIKE '%CUSTOM%';

-- Updates if needed with care
UPDATE vertex_oic_configuration
   SET username = 'sysadmin', password = 'vertex',
           service_end_point =
               'http://:8095/vertex-ws/services';

UPDATE vertex_oic_od_configuration
   SET username = 'sysadmin', password = 'vertex',
       service_end_point =
          'http://:8095/vertex-remote-services/oseriestm/taxdata';

UPDATE VERTEX_SERVICE_OD_ENDPOINT
   SET ver_oracle_instance = ,
       ver_service_end_pt =
          'http://:8095/vertex-remote-services/oseriestm/taxdata';

UPDATE VERTEX_TAX_REGIME_OD_USER
   SET ver_user_name = , ver_pwd =
 WHERE ver_tax_regime_code = ;

UPDATE VERTEX_TAX_REGIME_OD_USER
   SET ver_user_name = , ver_pwd = 
 WHERE ver_tax_regime_code = ;

COMMIT;