Friday, October 9, 2009

What are Steps for Report Development in Apps?

Steps for Report Development....

1. Develop the report as per client requirement using the Report-6i tool.
2. Move the report (.rdf) file from local machine to respective path in the server. If client have the CUST_TOP then move into Cust_Top else move it to the related Standard Top.Custom Top - CUST_TOP/ 11.5.0/ Report/ US/ .rdf Standard Top - PO_TOP/ 11.5.0/ Report/ US/ .rdf (For PO report)
3. Create “Executable” for that report (After log on to Oracle Applications and Select “System Administrator” responsibility)
4. Create “Concurrent Program” and attach Executable to Conc. Prgm. and define Parameters and Incompatibles if any.Concurrent Program: It is an instance of the executable file along with parameters & incompatible.
5. Create “Request Group” and attach Conc. Prgm. to Request Group.Request Group is nothing but a collection of Conc. Prgms.
6. Create “Responsibility” and attach the Request Group to Responsibility.
7. Create “User” attach Responsibility to User” so that the user can run this Conc. Prgm. form the “SRS Window” (Standard Request Submission).Note: All the Conc. Prgms. should run from the SRS window (Even if we run from Back-End)By default the user has the rights of System Administrator or Application Developer responsibilities
Every form in Oracle Applications contains 3-Types of Fields.1. Yellow color – Mandatory2. Green Color – Read-Only3. White Color – Optional
User Creation:Open IE and type path of Oracle Application in address bar enter User Name and PasswordUser Name: OPERATIONSPassword: WELCOMESelect System Administrator Responsibility
Select Security / User / DefineGive the required information and Save.
Switch the user to newly created User.Note: When we create any User, the User stored at FND_USER. We can find throughHelp >Record-History >FND_USER
Column Name: To find all column names: Help >Diagnostics >ExamineWHO Columns: 4 types of who columns for each table in Oracle ApplicationsCreated ByCreation DateUpdated ByUpdated Date