My Oracle Support Banner

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 APRIL 26, 2019

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:

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.