R12: Grants Accounting Several Invalid GMS and PA Objects Will Not Compile (Doc ID 1576049.1)

Last updated on JANUARY 21, 2016

Applies to:

Oracle Grants Accounting - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

The following database views in the apps schema have been invalid for some time after an 11i to R12.1.3 upgrade and will not compile:

1. apps schema views:
GMS_AP_DISTRIBUTIONS_V
GMS_ASI_COMMITMENT_BASE_V
GMS_BUG_2238663_CDL_V
GMS_MIG_STATUS_CMT_BASE_V
GMS_MIG_STATUS_COMMITMENTS_V
GMS_STATUS_COMMITMENT_BASE_V
GMS_STATUS_PROJECTS_BASE_V1

PA_COMMITMENT_TXNS_1

2. apps schema packages:
GMS_BALANCE_TEMP

PA_PROJECT_BILLING_STATUS

 
Is it possible to resolve these invalid objects?
 

Solution

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