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 laterInformation 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
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 |