When Using Update Lines Function In BEE Spreadsheet Interface Error "ORA-00904: "LOOKUP_CODE": invalid identifier" (Doc ID 2083341.1)

Last updated on NOVEMBER 29, 2015

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Test : 12.1.3 version, Element Types, Links, Entries

When attempting to to load batch into BEE Spreadsheet
the following error occurs.

ERROR
-----------------------
7/31/15 2:01 PM AJPRequestHandler-HTTPThreadGroup-22 ERROR BneBaseSQL.executeBneQuery: Query: select BATCH_ID,BATCH_LINE_ID,BATCH_LINE_STATUS,OBJECT_VERSION_NUMBER,ASSIGNMENT_ID,ASSIGNMENT_NUMBER,ATTRIB_CATEGORY,ATTRIB1,ATTRIB2,ATTRIB3,ATTRIB4,ATTRIB5,ATTRIB6,
ATTRIB7,ATTRIB8,ATTRIB9,ATTRIB10,ATTRIB11,ATTRIB12,ATTRIB13,ATTRIB14,ATTRIB15,ATTRIB16,ATTRIB17,ATTRIB18,ATTRIB19,ATTRIB20,ENT_INFO_CATEGORY,ENTRY_ADDL_INFO, ENTRY_FUR_INFO,ENT_INFO1,ENT_INFO2,ENT_INFO3,ENT_INFO4,ENT_INFO5,ENT_INFO6,ENT_INFO7,ENT_INFO8,ENT_INFO9,ENT_INFO10,ENT_INFO11,ENT_INFO12,ENT_INFO13,ENT_INFO14,
ENT_INFO15,ENT_INFO16,ENT_INFO17,ENT_INFO18,ENT_INFO19,ENT_INFO20,ENT_INFO21,ENT_INFO22,ENT_INFO23,ENT_INFO24,ENT_INFO25,ENT_INFO26,ENT_INFO27,ENT_INFO28,ENT_INFO29,ENT_INFO30,
DATE_EARNED,PERSONAL_PAYMENT_METHOD_ID,SUBPRIORITY,BATCH_SEQUENCE,CONCATENATED_SEGMENTS,COST_ALLOCATION_KEYFLEX_ID,EFFECTIVE_DATE,EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,
ELEMENT_NAME,ELEMENT_TYPE_ID,ENTRY_TYPE,REASON,SEG1,SEG2,SEG3,SEG4,SEG5,SEG6,SEG7,SEG8,SEG9,SEG10,SEG11,SEG12,SEG13,SEG14,SEG15,SEG16,SEG17,SEG18,SEG19,SEG20,SEG21,SEG22,SEG23,
SEG24,SEG25,SEG26,SEG27,SEG28,SEG29,SEG30,VAL1,VAL2,VAL3,VAL4,VAL5,VAL6,VAL7,VAL8,VAL9,VAL10,VAL11,VAL12,VAL13,VAL14,VAL15,error_message from pay_webadi_bee_content_v WHERE BATCH_ID=:RSQLP1 and ELEMENT_TYPE_ID=:RSQLP2 order by BATCH_SEQUENCE
7/31/15 2:01 PM AJPRequestHandler-HTTPThreadGroup-22 ERROR BneBaseSQL.executeBneQuery: Args : 20673484, 7176
7/31/15 2:01 PM AJPRequestHandler-HTTPThreadGroup-22 ERROR BneBaseSQL.executeBneQuery:

Stack trace: java.sql.SQLSyntaxErrorException: ORA-00904: "LOOKUP_CODE": invalid identifier
ORA-06512: at "APPS.PAY_PAYWSQEE_PKG", line 1438
ORA-06512: at "APPS.PAY_PAYWSQEE_PKG", line 1585


7/31/15 2:01 PM AJPRequestHandler-HTTPThreadGroup-22 ERROR BneXMLComponent.getXML() Could not open download control based on Content Key 801:PAY_BEE_UPD_CNT Due to oracle.apps.bne.exception.BneSQLException: Cannot execute SQL Statement.

7/31/15 2:01 PM AJPRequestHandler-HTTPThreadGroup-22 ERROR BneXMLComponent.getXML() Stack Trace: oracle.apps.bne.exception.BneSQLException: Cannot execute SQL Statement.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load batch in BEE Spreadsheet


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms