Search found 2062 matches

by admin
Fri Apr 21, 2006 3:47 am
Forum: Oracle Databases
Topic: Database Access Authorization
Replies: 2
Views: 2632

Here is a very userful link explaining database control methods, http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96524/c23acces.htm#3114 For ERP you should read metalink notes, Best Practices for Securing Oracle E-Business Suite (Note 189367.1) E-Business Suite Recommended Set Up for Client/...
by admin
Fri Apr 21, 2006 1:00 am
Forum: Oracle Forms & Reports
Topic: Attendance Sheet of selective Number of Sessions.
Replies: 5
Views: 3122

There are two ways to do this,

1- Use conditional formating and hide/display on the basis of parameter passed.

2- Use a temp table and insert values at runtime while using dynamic sql.

Hope it would be helpful.
by admin
Thu Apr 20, 2006 6:19 am
Forum: Suggestions
Topic: Read Please Software
Replies: 0
Views: 1569

Read Please Software

You can get read please software and install it to read Oracle manuals for you. Well it is not only for Oracle just it is to read lines from a file. Recommended for reading Oracle manuals. Hope you will like this idea.

http://www.erpstuff.com/Portal_Links.as ... &cattitle=
by admin
Thu Apr 20, 2006 2:43 am
Forum: General / Others
Topic: Oracle Messenger
Replies: 3
Views: 3876

Oracle Messenger

Download the screen short of Oracle Messenger and see how it looks.


[img]/images/icon_zip.gif[/img] <b>Attachment:</b> Oracle Messenger.zip <i>( 8747bytes )</i>
by admin
Thu Apr 20, 2006 2:24 am
Forum: General / Others
Topic: New to Financials
Replies: 2
Views: 2304

AoA,
First you should have Finance knowledge and if you don't have then it would be bit trouble. Now if you have Finance background then start with GL.... thks
by admin
Thu Apr 20, 2006 1:59 am
Forum: Oracle Forms & Reports
Topic: Running sum in form
Replies: 10
Views: 9833

Just paste the code of post_query in when_validate trigger of your sal field. Only issue you will face is when you will change the previous records. But hope now you can develop a logic to resolve even this issue. thanks
by admin
Thu Apr 20, 2006 1:16 am
Forum: Oracle Forms & Reports
Topic: "genrate to file" option in reports runtime error
Replies: 7
Views: 4677

This is a reported bug but as I don't have the version of your reports so would ask you to do the following. If your reports version is older than 6.0.5.36 then you will have to upgrade your reports. * fact: Oracle Reports Developer 6.0.5 * fact: Reports Runtime Previewer * symptom: Generate to File...
by admin
Thu Apr 20, 2006 1:08 am
Forum: Oracle Forms & Reports
Topic: Running sum in form
Replies: 10
Views: 9833

Pl download the file as a sample. There may be other way but I got the result in this way so...



[img]/images/icon_zip.gif[/img] <b>Attachment:</b> running_sum.zip <i>( 4276bytes )</i>
by admin
Wed Apr 19, 2006 7:43 am
Forum: Oracle Forms & Reports
Topic: date range problam
Replies: 1
Views: 2035

You can use lexical to build where query and on parameter selection you should select option 1 or option 2. Now in the pre report trigger you have to do like, if option 1 v_query := between 1 and 15; else v_query := between 16 and last_day(sysdate); end if Here is the use of last_day example, SQL> s...
by admin
Tue Apr 18, 2006 9:37 am
Forum: Oracle Forms & Reports
Topic: "genrate to file" option in reports runtime error
Replies: 7
Views: 4677

Pl provide some detail about the steps you are performing to get the result?
by admin
Tue Apr 18, 2006 9:35 am
Forum: Oracle Databases
Topic: Oracle Basic Functions Tutorial
Replies: 2
Views: 7604

Oracle Basic Functions Tutorial

I have tried to explain oracle basic functions with descriptive and same function with demonstration. Well this is not the complete list of all functions so you should consider it a very basic document for reference or practice purpose. I have demonstrated all the functions using Oracle 9i release 9...
by admin
Tue Apr 18, 2006 12:54 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Customized reports?
Replies: 2
Views: 2845

Now I would like to have requirements for this report or any output sample required. Secondly if someone already have this customized report he/she can email me and then we all should work on that in order to improve it. thanks
by admin
Mon Apr 17, 2006 7:08 am
Forum: Oracle Forms & Reports
Topic: About Oracle Terminal
Replies: 1
Views: 2400

by admin
Mon Apr 17, 2006 5:18 am
Forum: Polls
Topic: Future of ERP's
Replies: 0
Views: 3042

Future of ERP's

Which of the following ERP you think will survive till 2015? (MS Excel the major competitor of all ERP's.)
by admin
Mon Apr 17, 2006 5:09 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Customized reports?
Replies: 2
Views: 2845

Customized reports?

Here I would like to have your input to get a list of required customized reports to users other than oracle standard reports. Thanks