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 FEBRUARY 15, 2019

Applies to:

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

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