Monday, July 16, 2012

Oracle Apps: Install Jdeveloper on Oracle Linux on VM

Below set of instructions are to Install Jdeveloper on Oracle Linux on Oracle VM. 

1. Download Oracle Jdeveloper ISO File  from
    http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html

2. Mount the ISO File and Navigate to Shared Folder(/media/<mount folder>) on  Linux VM
    and execute below command
    ./jdk-6u30-linux-x64.bin

3. Once installation is successful to start the Jdevloper execute below command
    cd /home/oracle/Oracle/Middleware/jdeveloper/jdev/bin
     ./jdev



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

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