Tuesday, July 17, 2012

Oracle Apps: R12 Payment Document Setup

Following steps are needed to Create a New Payment Format in Oracle Payables R12 and associate it with Payment Document.

Step 1: Create XML Template

Payables Manager > Setup > Payment > Payment Administrator > Formats > XML Publisher Format Templates

    Click 'Create Template'
        Enter valid name, Code, Application (= Payments)
        Type = RTF
        Data Definition = Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
        Default File Language = English
        Default File Territory = UNITED STATES
       
    Upload your RTF File

Step 2: Create Payment Format

Payables Manager > Setup > Payment > Payment Administrator > Formats > Formats
    Select Type = Disbursement Payment Instruction

    Click on Create
        Enter Code, NameType = Same as above
        Data Extract = Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
        XML Publisher Extract = XML Template name created in Step 1

Step 3: Create Payment Document

Payables Manager > Setup > Payment > Bank Accounts

    Query up your Bank Name. It is assumed that your Bank has already been setup in AP.
    Select the Bank Account and click on Manage Payment Documents.
    Click on Create

    Enter:
    Name: XXXX Check Payment Document
    Paper Stock Type: Blank Stock or Prenumbered Stock
    Format: Enter Format defined in step 2
    First Available Document Number:
    Last Available Document Number
    Enter any other information that you may need.
    Click Apply

Step 4: Create Payment Process Profile

Payables Manager > Setup > Payment > Payment Administrator > Payment Process Profiles

    Click on Create
    Enter:
    Code
    Name
    Payment Instruction Format: As defined in Step 2
    Processing Type: Printed
    Payment Completion Point: When the Payment Instruction is Formatted
    Default Payment Document: Document created in Step 3
    Payment File: Send to Printer
    Check the box ‘Automatically Print After Formatting’ (Note: You mau choose not to check this box initially – it will help in testing)
    Default Printer: Valid oracle printer name

    Click Apply



For making Payments use the above created Payment Process profile


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

.

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