Oracle Apps Techno Functional................

Overview:  Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite. It provides a new approach to report design and publishing by integrating familiar desktop word processing tools with existing E-Business Suite data reporting. At runtime, XML Publisher merges the custom templates with the concurrent request data extracts to generate output in PDF, HTML, RTF, EXCEL (HTML), or even TEXT for use with EFT and  EDI  transmissions Basic Need for XML : Consider the following scenarios We have a RDF report with tabular layout which prints in English New Requirements: User1 wants the same Report needs to be printed in Spanish User2 wants the Same Report needs to be printed in chart format User3 wants the Same Report output in Excel User4 wants the Same Report output to be published on intranet or  internet User5 wants the Same Report output eliminating few columns and adding few other A new RDF needs to be created for...

BI XML Publisher Reporting (oracle Apps R12) : Steps : Generate the Query in TOAD and omit the duplicates. SELECT fu.user_name, fr.responsibility_name, furg.start_date, furg.end_date,        fu.email_address, fa.application_name, fr.responsibility_id,        fa.application_id, hou.NAME   FROM fnd_profile_option_values fpov,        fnd_profile_options fpo,        hr_operating_units hou,        fnd_responsibility_tl fr,        fnd_application_tl fa,        fnd_user_resp_groups_direct furg,        fnd_user fu   WHERE fpov.profile_option_id = fpo.profile_option_id    AND fpov.application_id = fpo.application_id    AND fpo.profile_option_name = 'ORG_ID'    AND fpov.profile...