ORA-24323: Value not Allowed error

I have faced this error while working on Oracle Reports Builder,trying to modify a query in the data model.

The Reasons may be :

1. A mandatory value received incorrect or null data.
2. You are not connected to the database in report builder.

This happens when we are connected to database and for some reason the connection is lost/dropped/disconnected.To overcome this error, completely close report builder and reopen it,else try going to
File -> Connect -> Give the UserName, Password, Database and connect.


Challa.

ORA-01400 Oracle Error FDPSTP failed due to ORA-01400: cannot insert NULL

I have come across this error when working with the Item Master Interface,where the UOM_CODE was not passing in the procedure for validation.

When you encounter an ORA-01400 error, the following error message will appear:
ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_NAME"."COLUMN_NAME")



This is caused when you try to insert a NULL value into a column that does not accept NULL values.

SOLUTION  to resolve this Oracle error is:

1) To Correct your INSERT statement so that you do not insert a NULL value into a column that is defined as NOT NULL.

For example, if you had a table called suppliers defined as follows:

CREATE TABLE suppliers
( supplier_id number not null,
supplier_name varchar2(50) not null );

And you tried to execute the following INSERT statement:

INSERT INTO suppliers
( supplier_id )
VALUES
( 10567 );

You have defined the supplier_name column as a NOT NULL field. Yet, you have attempted to insert a NULL value into this field. Provide the value for this field and try.


Challa.

APP-FND-01564 Oracle error - 20160 in SUBMIT

ORA-4091: table applsys.fnd_concurrent_requests is mutating trigger/function may not see it.

I faced this issue when i tried creating an event alert on FND_CONCURRENT_REQUESTS table.

Solution Description :

You need to disable the event alert trigger going against the fnd_concurrent_requests table, and create a periodic alert instead.

*The trigger will be named ALR_<table_name>_IAR for insert and ALR_<table_name>_UAR for update.*

Make the changes as follows:

1. Login to sql/plus as APPS.
2. Disable the trigger:

sqlplus> alter trigger trigger_name disable;
e.g.
sqlplus> alter trigger ALR_FND_CONCURRENT_REQUESTS_UAR disable;

3. Create a new PERIODIC alert (cannot just convert Event to Periodic) on FND_CONCURRENT_REQUESTS and set the frequency of the Alert according to
your business need 

- e.g. once per business day. 

 This will allow a single email to report multiple request information as specified in the sql select statement.

Challa.

Error 500--Internal Server Error in discoverer.

Sometimes we get error while retrieving the list of values for a Discoverer report in the Application showing 

500 Internal Server Error as shown below.

This can be resolved by following the below steps.

1)Select the preferences on the top right corner of the page.

2)Click on the preferences and a New window will be displayed as shown below.

Here change the value for Cancel list-of-values retrieval after.
(In my case i have changed it to 240 as the column contains very huge data for LOV's.)

3)Change the value and click on apply.

And the issue is resolved.

If the same issue occurs in the Discoverer Desktop (or) Discoverer Plus as shown below.

1) Go to Tools -> Options.

A pop-up will be opened as shown in below screenshot.

2)Click on the Query Governor Tab and change the value for Cancel value retrieval after.
3)Click on OK.

The issue is resolved.

Challa.