---
title: "Oracle Custom Analysis"
slug: "how-to-define-my-oracle-custom-analysis-project"
updated: 2021-12-29T13:27:58Z
published: 2021-12-29T13:27:58Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://success.panaya.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle Custom Analysis

Panaya can provide Code Correction activities with easy to contextual code snippets according to your definitions of impacted objects. In order for Panaya to generate Correction & Unit Test activities for your Custom Analysis project, you will need to define the areas of potential impact for the particular custom changes. This solution supports Code Objects and Sub-Objects for both your standard and custom code. You can then easily scope your test plan according to Panaya's recommended priorities. To define your changes for your Oracle Custom Analysis project -

1. [Log in to Panaya](/docs/javascript%3Avoid(0))
2. Click on the **Setting button**![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1640730346169.png)

If multiple Systems are configured, use the drop-down list to select the relevant System![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1640730386156.png)
3. Select to **View & Manage** Custom Analysis, under the **Oracle Development** section  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1640730392047.png)
4. Select Add Change and begin filling in the details of the change as follows -  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1640730398584.png)  
**Type**  
Use the drop-down list to select the object type that has been changed (e.g. column, view, package)  
  
**Owner (module)**  
e.g. SQLGL  
  
**Object**  
Fill in the object name according to the selected Type (e.g. GL_CODE_COMBINATIONS)  
**Important!**

  - Code Objects (Packages, Procedures, and Functions) will only be analyzed where the APPS is used for the Owner field
  - Data Objects e.g. Tables, Views will only be analyzed where the exact modules are used for the Owner field

  
**Sub Object**  
Only required for certain Object Types. i.e. for Object Type "Column" - the Object would be Table and the Sub Object is the Column Name.  
e.g. SEGMENT2  
  
**Category**  
Change / Obsolete / Deleted  
Select the nature of the change you are about to implement.  
The correction activity in Panaya will be generated according to the defined change so you can later easily scope or filter by this criteria.  
  
**Complexity**  
Simple / Medium / Complex  
Use this field to define the expected complexity  
  
**Work (H)**  
Define the expected work hours  
  
**Priority**  
Low / Medium / High  
  
**Solution**  
Use this free text field to describe how to fix the issue  
  
**Delete**  
Use the delete button to remove a change from the list  
Remember to Save to apply changes  
  
**Include**/ **Exclude from Analysis**  
Check or uncheck to include or exclude the change from the Custom Analysis  
Remember to Save to apply changes
5. You can also use the **Edit in Excel**option to Add or Edit changes using an Excel spreadsheet. Fill in the rows in the spreadsheet, save it locally and then drag it back to the drop area or browse and locate.  
  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1640730410038.png)
6. Once complete, click **Save**to apply changes. You need to [re-upload your Custom Code](/v1/docs/how-to-extract-upload-your-custom-code-using-the-code-box) to Panaya for any changes to take effect in your Custom Analysis project. [Click here to learn how to create a new project](/v1/docs/how-to-create-a-new-project-1)  
  
Once you [upload your Custom Code](http://success.panaya.com/CloudQuality-Suite/Code-Box/70724239/How-to-extract-upload-your-custom-code-using-the-code-box.htm), Panaya will create new Correction & Unit Test activities that are associated with the defined impacted objects.

**Note**  
The Comments column is a used as validation and will display the status of the added change - Analyzed / Not Analyzed / Missing Data  
Use the Display filter to view valid or invalid changes