Search found 615 matches

by ahmadbilal
Tue Nov 28, 2006 1:09 am
Forum: Reports (Only Oracle Apps Reports)
Topic: Counts of records in Different tables
Replies: 1
Views: 1928

select (select sum(amount) from ra_cust_trx_line_gl_dist_all) Tot_Amt, (select count(*) from ra_cust_trx_line_gl_dist_all) Tot_cnt, (select count(*) from ra_customer_trx_all) Suc_cnt from ra_cust_trx_line_gl_dist_all rctlgda, ra_customer_trx_all rcta where rctlgda.request_id = rcta.request_id select...
by ahmadbilal
Wed Nov 22, 2006 5:04 am
Forum: General / Others
Topic: how to know responsibility from user-conc-pgrm
Replies: 1
Views: 1906

[quote]CREATE OR REPLACE VIEW <b>v_resp_menu</b> (responsibility_id, responsibility_name, LANGUAGE, responsibility_key, application_id, user_menu_name, rgid ) AS SELECT DISTINCT b.responsibility_id, a.responsibility_name, a.LANGUAGE, b.responsibility_key, b.application_id, c.user_menu_name, b.reques...
by ahmadbilal
Wed Nov 22, 2006 1:26 am
Forum: Reports (Only Oracle Apps Reports)
Topic: How to deploy reports in oracle/developer 9i
Replies: 3
Views: 3233

Respected Sir, I have developer 10g and oracle 9i on my system please guide me how to deploy custom reports on web from server and also tell me how to acess reports from client in oracle/developer 9i. Thanks in advance Tahir Satti <i><div align="right">Originally posted by tahir_mehmood -...
by ahmadbilal
Mon Nov 20, 2006 1:41 am
Forum: Oracle Forms & Reports
Topic: Oracle Connectivity Between 2 countries
Replies: 5
Views: 10139

Assalam-o-Alaikum You need Fixed IP first. According to me you go for Replication. Do not connect directly to server which is located at other country for Reporting take care <i><div align="right">Originally posted by mirza_rehan - 18/11/2006 : 05:31:10 AM</div id="right"></i> M...
by ahmadbilal
Sat Nov 18, 2006 7:42 am
Forum: Oracle Forms & Reports
Topic: Oracle Connectivity Between 2 countries
Replies: 5
Views: 10139

Dear Kamran, In Case Of Runtime Env. 1st Of All You Should Check Global Naming Of Your Oracle Database 2nd Route Your machine (DB Server IP From Any ISP) 3rd Create TNS On Clent Mahcine In case Of AS Just Route your Application Server IP from DSL Machine And Cheers Post Result or anyfurther Research...
by ahmadbilal
Sat Nov 18, 2006 5:48 am
Forum: General / Others
Topic: error in query ORA-01476: divisor is equal to zero
Replies: 2
Views: 2009

nvl(colname,1) will solve your problem
by ahmadbilal
Sat Nov 18, 2006 5:45 am
Forum: Application DBA & System Administration
Topic: my need is I insert all other branch data in head
Replies: 2
Views: 1544

Try incremental backup
by ahmadbilal
Sat Nov 18, 2006 5:43 am
Forum: Oracle Forms & Reports
Topic: how get direct print
Replies: 3
Views: 2197

Which Version and output method u r using
by ahmadbilal
Fri Nov 17, 2006 9:26 am
Forum: Operating System
Topic: how to reset admin password in winxp
Replies: 1
Views: 2136

Just Attach Ur HDD to any other machine and drop ur sam file
by ahmadbilal
Fri Nov 17, 2006 2:10 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Share Your Experince About Release 12
Replies: 1
Views: 908

a little shocking......:(
CRM is JAVA Based


http://forums.oracle.com/forums/thread. ... 8&tstart=0
by ahmadbilal
Fri Nov 17, 2006 1:05 am
Forum: Application DBA & System Administration
Topic: DBA Interview Questions
Replies: 0
Views: 1910

DBA Interview Questions

# How many memory layers are in the shared pool? # How do you find out from the RMAN catalog if a particular archive log has been backed-up? # How can you tell how much space is left on a given file system and how much space each of the file system?s subdirectories take-up? # Define the SGA and how ...
by ahmadbilal
Thu Nov 16, 2006 11:46 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Share Your Experince About Release 12
Replies: 1
Views: 908

Share Your Experince About Release 12

Post Info Here About Oracle E Business Release 12

i.e
Diffrence
New Feature
by ahmadbilal
Thu Nov 16, 2006 7:00 am
Forum: Suggestions
Topic: oracle financials
Replies: 2
Views: 1650

Metalink.oracle.com