My Oracle Support Banner

INVALID VIEW DEFINITION CSI_INSTANCE_ACCTS_RG_V AFTER APPLYING PATCH 13736252 (Doc ID 1452816.1)

Last updated on JUNE 28, 2021

Applies to:

Oracle Installed Base - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

In 11.5.10.2
  
CSI_INSTANCE_ACCTS_RG_V view definition supplied in Patch 13736252 (csivrg.odf version 115.14.11510.5) is incorrect. Using this file, view is created incorrectly. Doing a describe on the view from sqlplus will show:
  
ERROR:
------------
  ORA-24372: invalid object for describe
  
Column data type for all of columns as "UNDEFINED". As a result, dependent objects are invalid (ie ASO_UTILITY_PVT and ASO_PRICING_FLOWS_PVT )
  
  
EXPECTED BEHAVIOR
  ----------------------------------
CSI_INSTANCE_ACCTS_RG_V is created with correct definition.
  
STEPS TO REPRODUCE
  -------------------------------------------
(1.) Apply Patch 13736252
(2.) Check invalid objects, dependent objects such as ASO_UTILITY_PVT and ASO_PRICING_FLOWS_PVT are invalid.
(3.) View CSI_INSTANCE_ACCTS_RG_V is invalid and dependent objects are invalid as well (e.g. ASO_UTILITY_PVT and ASO_PRICING_FLOWS_PVT )
  
  WORKAROUNDS
  ===========
  Manual workaround is to recreate the view manually using the command:
  
CREATE OR REPLACE FORCE VIEW "APPS"."CSI_INSTANCE_ACCTS_RG_V"
  ("CUSTOMER_PRODUCT_ID",
  
  "REFERENCE_NUMBER",
  
  "CURRENT_SERIAL_NUMBER",
  
  "PRODUCT",
  
  "PRODUCT_DESCRIPTION",
  
  "QUANTITY",
  
  "UNIT_OF_MEASURE_CODE",
  
  "ACCOUNT_ID",
  
  "ACCOUNT_NUMBER",
  
  "LINE_INST_DETAIL_ID",
  
  "SYSTEM_ID", "ORIGINAL_ORDER_LINE_ID")
  AS
  SELECT cii.instance_id customer_product_id,
  cii.instance_number reference_number,
  cii.serial_number current_serial_number,
  si.concatenated_segments product,
  si.description product_description,
  cii.quantity quantity,
  cii.unit_of_measure unit_of_measure_code,
  cia.party_account_id account_id,
  acc.account_number,
  cii.last_txn_line_detail_id line_inst_detail_id,
  cii.system_id,
  cii.last_oe_order_line_id original_order_line_id
  FROM MTL_SYSTEM_ITEMS_KFV SI,
  HZ_CUST_ACCOUNTS ACC,
  CSI_ITEM_INSTANCES CII,
  CSI_I_PARTIES CIP,
  CSI_IP_ACCOUNTS CIA
  WHERE CII.INSTANCE_ID = CIP.INSTANCE_ID
  AND NVL(CII.ACTIVE_END_DATE, (SYSDATE+1)) > SYSDATE
  AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'
  AND CIP.RELATIONSHIP_TYPE_CODE = 'OWNER'
  AND CIP.INSTANCE_PARTY_ID = CIA.INSTANCE_PARTY_ID
  AND CIA.RELATIONSHIP_TYPE_CODE = 'OWNER'
  AND CIA.PARTY_ACCOUNT_ID = ACC.CUST_ACCOUNT_ID
  AND CII.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID
  AND SI.ORGANIZATION_ID =
  CII.INV_MASTER_ORGANIZATION_ID
  AND CIP.PARTY_ID NOT IN ( SELECT INTERNAL_PARTY_ID FROM
  CSI_INSTALL_PARAMETERS);
  
  Recreating manually, the view was correct, and dependent objects compiled successfully.

Changes

 Applied Patch 13736252

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.