Invalid objects: INL_IR_SOURCE_LINES_V, INL_PO_SOURCE_LINES_V, INL_RMA_SOURCE_LINES_V and INL_ENTER_RECEIPTS_V

(Doc ID 1317456.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle Landed Cost Management - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Mar-2013***

Symptoms

On : 12.1.2 version,
The following invalid objects were detected after Automated Build applied the patch:

APPS VIEW INL_IR_SOURCE_LINES_V
APPS VIEW INL_PO_SOURCE_LINES_V
APPS VIEW INL_RMA_SOURCE_LINES_V
APPS VIEW INL_ENTER_RECEIPTS_V


***************Additional Error Information**********************

INL_IR_SOURCE_LINES_V - VIEW
----------------------------
ORA-04063: view 'APPS.INL_ENTER_RECEIPTS_V' has errors 0 0


INL_PO_SOURCE_LINES_V - VIEW
----------------------------
ORA-04063: view 'APPS.INL_ENTER_RECEIPTS_V' has errors 0 0


INL_RMA_SOURCE_LINES_V - VIEW
-----------------------------
ORA-04063: view 'APPS.INL_ENTER_RECEIPTS_V' has errors 0 0


INL_ENTER_RECEIPTS_V - VIEW
---------------------------
ORA-01790: expression must have same datatype as corresponding expression (PO_LINE_NUMBER)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to SQLPLUS
2. Compile view
3. Get error:
ORA-01790: expression must have same datatype as corresponding expression (PO_LINE_NUMBER)

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