1. Form the query in Toad.
2. Compile the query by either pressing 'F9' or 'right click =>execute =>complie all'.
3.Once compile successfully, Navigate and log in to oracle Apps responsibility,
Application developer => Executable.
4. Create the executable program and select 'executable name' as package or procedure name (as per requirement).
5. Copy the short name and navigate to concurrent => Program.
6. Paste the short name as executable name.
7. Give/forward the program name to the DBA, who will attach the program to the request group to a particular responsibility.
8.Once attached, we can run the request from SRS window on the attached responsibility.
2. Compile the query by either pressing 'F9' or 'right click =>execute =>complie all'.
3.Once compile successfully, Navigate and log in to oracle Apps responsibility,
Application developer => Executable.
4. Create the executable program and select 'executable name' as package or procedure name (as per requirement).
5. Copy the short name and navigate to concurrent => Program.
6. Paste the short name as executable name.
7. Give/forward the program name to the DBA, who will attach the program to the request group to a particular responsibility.
8.Once attached, we can run the request from SRS window on the attached responsibility.
No comments:
Post a Comment