![Page 1: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/1.jpg)
Report Registration Process in ORACLE Applications
First we receive the Functional Design Document ( MD - 50 ) from Functional Consultant. Next we analyze the document and start to develop the Component. First we build a query in Back End Tool based on Client Business Requirement. Let us take one example of User Details Query like below
SELECT FU.USER_ID USER_NO ,FU.USER_NAME USER_NAME
,FU.CREATED_BY CREATED_USER ,FU.CREATION_DATE CREATION_DATE
,FU.START_DATE START_DATEFROM FND_USER FU
Once the query is getting unique records then we will design the layout in Report Builder Now we open the Report Builder Tool
Here we can choose Build a new report manually Option and Click on OK
![Page 2: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/2.jpg)
Now drag and drop the SQL Query.
Here we paste our Query which is we developed.
Now click on Connect
Here we can give the credentials like
![Page 3: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/3.jpg)
User Name => APPSPassword => APPSDatabase => VIS
Now click on Connect
Now click on OK
![Page 4: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/4.jpg)
Next go to Layout Model.
Here we Design the Layout of our Report
![Page 5: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/5.jpg)
Now we select all Fields
Click on No Color ( No Fill )
Next click on No Line
![Page 6: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/6.jpg)
Next we compile the Report
![Page 7: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/7.jpg)
Now click on OK Next we save the report with .rdf Extention
Nav => File => Save
Now click on Save
![Page 8: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/8.jpg)
Now Run the ReportNav => Program => Run Paper Layout
![Page 9: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/9.jpg)
Now we are able to see the output of our Report Next we close the output of report Next we transfer the .rdf File from Local Machine to Server Machine. Now we open the WINSCP Tool.
Here we can give the Host Details of the Server
![Page 10: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/10.jpg)
Now click on Login
Here we can choose the location in server machine where we want to move our .rdf File.
![Page 11: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/11.jpg)
Now click on ok
Now we can transfer our file
![Page 12: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/12.jpg)
Now click on Copy
Now the file is available in Server Machine. Next go to Login Oracle Applications
![Page 13: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/13.jpg)
Here we can give the credentials to login
Now Click on Login
Here we can choose System Administrator Responsibility
![Page 14: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/14.jpg)
Now we can Define ExecutableNav => Concurrent > Program > Executable
Now click on the Executable button system open the executable form
![Page 15: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/15.jpg)
Here we can give the Executable Details
Now save the records
These Executable Information is going to below Tables
FND_EXECUTABLES_TLFND_EXECUTABLES
Executable Name is stored in FND_EXECUTABLES_TL Table and Executable Short Name is stored in FND_EXECUTABLES
![Page 16: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/16.jpg)
Once Executables is completed then next we Define Concurrent Program.Nav => Concurrent > Program > Define
Now Click on Define
Here we can give the Concurrent Program Details
![Page 17: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/17.jpg)
Now Save the Records
These Concurrent Program information is going to store Below Tables.
FND_CONCURRENT_PROGRAMS_TLFND_COCNURRENT_PROGRAMS
Concurrent Program Name is stored in FND_CONCURRENT_PROGRAMS_TL Table and Concurrent Program Short Name is stored in FND_CONCURRENT_PROGRAMS Table.
![Page 18: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/18.jpg)
NOTE : Link Between Executable and Concurrent Program is Executable Short Name Find out the below Screen
Once we Complete the Concurrent Program then Next we can Define Request GroupNav => Security > Responsibility > Request
![Page 19: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/19.jpg)
Now Click on Request
Here we can give the Request Group Details
![Page 20: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/20.jpg)
Now Save the Records
These Request Group information is going to store Below Table.
FND_REQUEST_GROUPS
Next we attach our Concurrent Program to this Request Group
![Page 21: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/21.jpg)
Now save the Records
These attached Concurrent Program information is going to store Below Table.
FND_REQUEST_GROUP_UNITS
Concurrent_Program_ID will be stored in Request_Unit_ID Column
To generate the Link Between Concurrent Program and Request Group, we use below Query
![Page 22: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/22.jpg)
Once we Complete the Request Group then Next we can Define Responsibility Nav => Security > Responsibility > Define
Now click on Define
![Page 23: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/23.jpg)
Here we can give the Responsibility Details
Now we save the records
![Page 24: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/24.jpg)
These Responsibility information is going to stored Below Tables
FND_RESPONSIBILITY_TLFND_RESPONSIBILITY
Responsibility Name is stored in FND_RESPONSIBILITY_TL Table and Responsibility Key is stored in FND_RESPONSIBILITY Table.
![Page 25: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/25.jpg)
Next we attach the Request Group to This Responsibility
Once we Complete the Responsibility Then Next we can Define UserNav => Security > User > Define
Now we can click on Define
![Page 26: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/26.jpg)
Here we can give the User Details
Now save the Records
![Page 27: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/27.jpg)
These User Information is going to store Below Table.
FND_USER
Now we can attach the our Responsibility along with AOL Responsibilities.
Now we can Save The Records.
![Page 28: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/28.jpg)
These attached Responsibility information is going to store Below Table
FND_USER_RESP_GROUPS_DIRECT
Next we can change to our Responsibility.Nav => File > Switch Responsibility
![Page 29: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/29.jpg)
Now choose our Responsibility and Click on Ok
![Page 30: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/30.jpg)
Now we submit the program from SRS Window.Nav => View > Request
Now we click on Submit a New Request Button
![Page 31: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/31.jpg)
Now click on OK
Here we can give our Concurrent Program Name
![Page 32: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/32.jpg)
Now click on Submit Button
Now click on NO
![Page 33: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/33.jpg)
Now click on Find Button
Now the program is Completed and status is Normal Now click on View Output Button
![Page 34: Report Registration Steps with effected tables in ORACLE Applications R12](https://reader033.vdocuments.us/reader033/viewer/2022052910/559c24231a28ab6e738b475b/html5/thumbnails/34.jpg)
This is our Final Output of our Report