Wednesday, July 11, 2012

Oracle Apps: frm-15004 error while parsing

Oracle Apps error: frm-15004 error while parsing

Cause:
While creating a link between Master and Detail Block when the join details are provided
this error pop's up.

eg:
Master Block:  MASBLK

Detail Block:  DTLBLK

common column: MAP_ID

all the below join conditions I got the frm-15004 error

    MASBLK.MAP_ID = DTLBLK.MAP_ID

    MAP_ID = MAP_ID

    :MASBLK.MAP_ID = :DTLBLK.MAP_ID



Solution:

1. Go to Master and Detail Block Property Palette and check if the below properties have
   correct values
  
   Query Data Source Type:
  
   Query Data Source Name:
  
   This may not be required if your Blocks are based on views
  
2. Change the name of the Item in Detail block from MAP_ID to DTL_MAP_ID and now provide
   the below join condition
  
   MAP_ID = DTL_MAP_ID



at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

No comments: