Mapping of application with database

[gokul]

Hi All,

Is it Possible to find out the a column in application mapped with the database table

Eg:
In Simple Order ID,Source Location,Destination Location and Early Pick up dates are there i don't know the corresponding back end table's column for this, In this case is there any possible ways to find out the link between the application column and the backed table column.

[bob_romijn]

Re: Mapping of application with database

Hi Gokul,

To me it sounds the following:

- Enter an order through the screen.
- Look into the database tables where it is stored.

You have to have the data dictionairy for that.

Order releases are stored in ORDER_RELEASE for example.

Best regards,

Bob

[bmj_23]

Re: Mapping of application with database

Hi,

Basically two ways as I see it:

1. Through experience
2. Turn on the UI / SQL logs and when you enter something via the UI, check the logs to see what the insert / update / delete commands are doing.

[gokul]

Re: Mapping of application with database

bmj

thanks for ur rep, may i know where the log will be.

[chrisplough]

Re: Mapping of application with database

Hello,

After enabling UI / SQL Logs within the OTM application, the output will go to the glog.app.log files by default, which are in the $OTM_HOME/logs directory on your OTM App server. You can also choose to split these off into separate log files, if you choose.

--Chris