1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Field mappings of Oracle Apps from Screen to Database

Discussion in 'Oracle Apps Technical' started by vellankinandu, Jan 29, 2010.

  1. Hi,

    I am new to Oracle Apps. We have R12 implemented. I previously worked on Siebel

    In Oracle Apps, How do we know the database field Name, when we are given Screen Name. This is a common process in Siebel. But Not sure how to get it in our app.

    Please help.

    Regards
    Raghu
     
  2. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    hi nandu, i am learning oracle apps 11.5.10 version.

    to the table name do the following steps
    put the cursor, which field do u want to find and do the following---
    F11 -> ctrl + F11 -> help menu -> record history
    here u get the object name. copy that ( if u have toad tool itz better) and paste in toad
    put the cursor on that name and press F4. one window appears on top of window it shows whether it is table or view. if it is table stop, if it is view, select script tab from that window and find the tables from "from" clause. and continue the process till u find the tables menu.

    to know the fields, put the cursor on the field and do the following
    F11 -> ctrl+F11 -> help menu -> diagnostics -> examine.
    here u find the block name and item name.

    in this manner u can find the table name, block name, field name k
     
  3. kcchan888

    kcchan888 Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Any Programs or Programming can do the automation - Map data fields from screen to database.
    e.g. Using Forms Developer or Report Developers
     
  4. kcchan888

    kcchan888 Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Any command or programs can print out the data fields from screens to tables data mapping
     
  5. durgareddygade

    durgareddygade Active Member

    Messages:
    38
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    Hi nandu,
    I think u got the answer for kiran replay.That is for forms belongs to D2K.
    Here i am adding some more points which may help to u..

    for eg:- in 11i suppliers form developed in D2K forms ,In R12 it is a OAF Form in which u are not able to see help menu.
    in this case u need to go for about this page option which is below that page.
    in that by clicking on viewobject u can see the what are the tables effected for particular form.
     
  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    we won't get the exact database field what exactly looks at screen. As kiran suggested you can check them in help-->diagnostics-->examine by placing in the field what you want. If you are looking for OAF Page then as suggested by durga you can see them in about this page option.