Category: Oracle Apps Development

Useful Oracle Apps Queries

Mar 2, 2012

—

by

Arun Raj

in Oracle Apps, Oracle Apps Technical, SQL

Below are a list of SQL Queries that will be useful during your day to day activities. 1. Concurrent Programs Assigned to a Request Group SELECT fcpv.concurrent_program_name SHORT_NAME ,fcpv.user_concurrent_program_name CONC_PROG_NAME ,frg.request_group_name REQ_GROUP_NAME FROM fnd_concurrent_programs_vl fcpv ,fnd_request_groups frg ,fnd_request_group_units frgu WHERE fcpv.concurrent_program_id = frgu.request_unit_id AND fcpv.enabled_flag = ‘Y’ AND frgu.request_group_id = frg.request_group_id AND frg.request_group_name = ‘&request_group_name’;…
XML Publisher Report from XML Data Template

Jul 31, 2010

—

by

Arun Raj

in Oracle Apps, Oracle Apps Development, Oracle Apps Technical, XML Publisher

How to develop a xml publisher report without using a rdf or sql or pl/sql concurrent program. We can do the same using xml data template as well. This blog explains a simple xml publisher report developed using the xml data template.