Dear All
I have a master detail scenario.Master is form and detail is editable table.Please understand that Detail VO is without any bind parameter or view criteria.Once I make random edits in the detail table and commit
it throws following exception
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement:
SELECT * FROM (SELECT GlmainChequesEO.AMOUNT,
GlmainChequesEO.AMOUNT_FC,
GlmainChequesEO.BANK,
GlmainChequesEO.CATEG,
GlmainChequesEO.CHQ_DATE,
GlmainChequesEO.CHQ_NO,
GlmainChequesEO.COMPANY_ID,
GlmainChequesEO.ID,
GlmainChequesEO.TEMP_ALLOC_AMT,
GlmainChequesEO.TEMP_ALLOC_AMT_FC,
GlmainChequesEO.TRAN_ID
FROM GLMAIN_CHEQUES GlmainChequesEO) QRSLT WHERE ((COMPANY_ID = ? AND TRAN_ID = ?) AND COMPANY_ID = ? AND ID = ?.
Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 3.
Link between the GlmainChequesEO To GlmainEO is created using parameters COMPANY_ID and TRAN_ID. My detail table key fields are COMPANY_ID ,ID
What I understand is that during commit it re executes the VO and the primary key parameter ID (Position 3) is not passing internally by the ADF.Can any one throw some light please!!
Ash