Error while applying 26776327:R12.JAI.B ORA-00903: invalid table name

(Doc ID 2324544.1)

Last updated on NOVEMBER 07, 2017

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 ACTUAL BEHAVIOR
---------------
Error while applying GST Settlement patch 26776327:R12.JAI.B ORA-00903: invalid table name

occurred while executing the SQL statement:

CREATE OR REPLACE FORCE VIEW APPS.JAI_STL_TRX_HDRS_V ("ROW_ID",
"STL_HDR_ID", "TAX_REGIME_ID", "TAX_REGIME_CODE", "TAX_REGIME_NAME",
"REGISTRATION_NUM", "REGISTRATION_TYPE_CODE", "SETTLEMENT_PERIOD",

EXPECTED BEHAVIOR
-----------------------
Patch application should complete successfully

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Apply patch 26776327:R12.JAI.B
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, user cannot apply the Settlement patch

Changes

 

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