After Migration From 11i To R12.2.5, Po_lines_locations_merge_v Is Invalid (Doc ID 2132968.1)

Last updated on MAY 01, 2016

Applies to:

Oracle Purchasing - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Using Purchasing, Version 12.2.5 -


Actual:
PO_LINE_LOCATIONS_MERGE_V is invalid causing other objects to remain as invalid.

Expected:
PO_LINE_LOCATIONS_MERGE_V will need to be validated along with several other dependent objects.

Error:



Replication Steps:
The issue can be reproduced at will with the following steps:
1. Upgrade from 11.5. to 12.2
2. Find the invalid objects - PO_LINE_LOCATIONS_MERGE_V




Reviewing the adodfcmp logs - see the following -

ALTER TABLE PO.PO_LINE_LOCATIONS_ALL ADD ( OUTSOURCED_ASSEMBLY NUMBER NOT

NULL )

ODF Comparison Utility error:

The following ORACLE error:

ORA-01758: table must be empty to add mandatory (NOT NULL) column

occurred while executing the SQL statement:

ALTER TABLE PO.PO_LINE_LOCATIONS_ALL ADD ( OUTSOURCED_ASSEMBLY NUMBER NOT

NULL )

Connecting to APPS......Connected successfully.

ODF Comparison Utility error:

Cause

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 hundreds of Community platforms