Codepack Generation Tool using OAF

I have developed a tool to generate a tool using OAF which helps in creating codepack. Codepack is something which is created for a RICE component, can consist of SQL, PL/SQL , AOL and OAF, Workflow objects.

This tool reduces lot of human effort as while development we never bother to create objects through scripts rather we go to editor and create objects. Here user will have the privilege to randomly objects and tool will create script for you.

For all, it uses FNDLOAD to create ldts for all AOL objects and OAF, it creates a zip file. Moreover to create or compile database objects and upload AOL ldts in the target or destination instance, a shell script will be created too and all these will packaged in a .tar file. The same .tar has to be unzipped in the target and install shell script has to be executed by DBA in order to migrate all database and AOL objects in the target instance.

The tool can be called CEMLI Generation tool as well.

Capabilities:

1. Automated CEMLI Codepack Generation.
2. Compliance to Standard EBS Development.
3. Version Control Tool.
4. Codepack Repository.
5. Project Document/ Artefacts Repository.
6. Time/ Cost Efficient.
7. Fast & Easy Download.
8. Robust & Easy Customization.

Skills Used:

1. OAF
2. UNIX Shell Scripting
3. SQL & PL/SQL
4. Oracle EBS

Future Enhancements:

1. Deployment of Codepack.
2. Logging of Deployment.
3. File Comparison.

A few snapshots has been given below:

Create Codepack:

Search and list Objects:

Update to add/delete objects:

Version increased and another codepack being created:

List all CodepacksA�Again and Download:

Compare Files and Download:

This is proprietary tool of Raja Dutta, the sole owner and developer of this product. It doesn’t belong to any organization. If any organization is using without intimating Raja Dutta, comes under Cyber Law under the act of Plagiarism or copyright breach.

Thank you.