R12 PA

R12 PA

R 12 PA

Projects

New Tables

None

Changed Tables

Table Name

Feature Area

Brief Description of Change

PA_PROJECTS_ALL

Multi-Org Access Control (MOAC)

Changes to these 3 tables:

· · Default value for ORG_ID has been removed

· · NOT NULL constraint is enforced on ORG_ID column

PA_PROJECT_TYPES_ALL

PA_IMPLEMENTATIONS_ALL

Obsolete Tables

None

New Views

None

Changed Views

View Name

Feature Area

Brief Description of Change

PA_CUSTOMER_SITES_V

Replaced RA backward-compatible views with direct joins to underlying HZ tables.

PA_CUSTOMER_CONTACT_NAMES_V

Replaced RA backward-compatible views with direct joins to underlying HZ tables.

PA_CUSTOMER_RECEIVER_PROJECTS_V

Replaced RA backward-compatible views with direct joins to underlying HZ tables.

PA_STRUCTURES_TASKS_V

Replaced RA backward-compatible views with direct joins to underlying HZ tables.

PA_TASK_CUSTOMERS_V

Replaced RA backward-compatible views with direct joins to underlying HZ tables.

PA_PROJECT_CONTACTS_V

Replaced RA backward-compatible views with direct joins to underlying HZ tables.

PA_PROJECT_CUSTOMERS_V

Replaced RA backward-compatible views with direct joins to underlying HZ tables.

PA_PROJECTS

MOAC

Single Org View Changes for 3 views

· · Drop the single organization view

· · Create a synonym with the same name as the single organization view in APPS schema.

· · Attach policy function to the synonym

PA_PROJECT_TYPES

PA_IMPLEMENTATIONS

PA_TASKS_WBS_V

Replaced RA backward-compatible views with direct joins to underlying HZ tables.

Obsolete Views

None