Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

FA Error Interactive Report SQL error

edited Aug 4, 2017 5:04AM in Enterprise Service Automation (ESA) - PSFT (MOSC) 2 commentsAnswered

I get the following error when attempting to run the FA Error Interactive Report...

"Error in PeopleCode ScrollSelect processing. (2,213) GM_FA_WRK.FA_SCROLL.FieldChange  PCPC:1863  Statement:36

A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function."

The issue seems to be related to chartfield security. I can see from examining the trace that SCF2 is not getting added to the FROM statement in the SQL query below. SCF2 should be PS_SEC_PROJ_USER.

SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.RESOURCE_ID , A.POST_SEQ_NUM , A.ANALYSIS_TYPE , A.ASSOC_DEPTID , A.ACCOUNT , A.ALTACCT , A.DEPTID , A.OPERATING_UNIT, A.PRODUCT, A.FUND_CODE, A.CLASS_FLD, A.PROGRAM_CODE, A.BUDGET_REF, A.AFFILIATE, A.AFFILIATE_INTRA1, A.AFFILIATE_INTRA2, A.CHARTFIELD1, A.CHARTFIELD2, A.CHARTFIELD3 , A.STATISTICS_CODE , A.BUSINESS_UNIT_GL , (CONVERT(CHAR(10),A.TRANS_DT,121)) , (CONVERT(CHAR(10),A.ACCOUNTING_DT,121)) , A.RESOURCE_AMOUNT , A.PROCESS_INSTANCE , A.FA_ERROR_STATUS

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

PSFT ESA Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center