Financial Management - PSFT (MOSC)

MOSC Banner

9.1 RUN_CNTL_AR - Fatal SQL error, issues

edited Mar 28, 2013 5:44AM in Financial Management - PSFT (MOSC) 3 commentsAnswered
Complete error
"A fatal PeopleCode SQL error occurred. Please consult your system log for details."
"SQL error in Exec. (2,280) RUN_CNTL_AR.BUSINESS_UNIT.SaveEdit  Name:chk_BUPrompt  PCPC:1255  Statement:13
Called from:RUN_CNTL_AR.BUSINESS_UNIT.FieldEdit  Statement:3
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed."

More

Error Position:  62   Return:  904 - ORA-00904: "OPRID": invalid identifier 

 Statement:  select 1 from ps_sp_buards_nonvw where business_unit = :1 and OPRID = :2

Original Statement:  SELECT 1 FROM %table(SP_BUARDS_NONVW) WHERE BUSINESS_UNIT = :1 AND OPRID = :2

PSAPPSRV.25691 (182)         1-562    15.12.16    0.000074 ErrorReturn-> 280 - SQL error in Exec. (2,280) RUN_CNTL_AR.BUSINESS_UNIT.SaveEdit  Name:chk_BUPrompt  PCPC:1007  Statement:11

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center