PAXTRAPE/PATXMAS: ORA-00957 Error When Performing Billable Adjustments on Expenditure Items in Expenditure Inquiry or Mass Adjust

(Doc ID 1275603.1)

Last updated on MARCH 06, 2018

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
PAXTRAPE.fmb - Form: Expenditure Inquiry
PATXMAS - Concurrent Program: PRC: Adjust Expenditure Items

Symptoms

In 12.1.3, when trying to adjust the billable or capitalizable status of one or more expenditure items an unexpected error occurs.

The issue occurs whether the expenditure item is adjusted individually in the Expenditure Inquiry form (PAXTRAPE.fmb), or by using the "Mass Adjust" button and running the concurrent program PRC: Adjust Expenditure Items

In the Expenditure Inquiry form (PAXTRAPE) the following error appears:

ORA-01403: no data found
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-00957

In the concurrent process log for "PRC: Adjust Expenditure items" (PATXMAS) the following appears in the log file:

REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-00957: duplicate column name
ORA-06512: at "APPS.PA_ADJUSTMENTS", line 7247

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-00957: duplicate column name
ORA-06512: at "APPS.PA_ADJUSTMENTS", line 7247

Changes

Adjusting the billable or capitalizable status of one or more expenditure items:

Billable to Non-Billable
Non-Billable to Billable
Capitalizable to Non-Capitalizable
Non-Capitalizable to Capitalizable

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