Is this an EBS instance?
What are the versions you upgraded from/to?
How do you get this error?
Select feature from toad.toad_restrictions where user_name=USER or user_name in ( select ROLE from sys.session_roles)
This looks related to TOAD, so is the issue when you connect from TOAD only? If not, please elaborate more.
This is EBS Instance.
We have upgraded the database from 10.2.0.4 to 22.214.171.124.
We are not facing the above issue from toad.We have got this error from alert log generated in a 2 hour run on ebs instance.The issues which I have posted above is a part of the alert log.
Please apply the patch in the note on a TEST enviornment, and see if the gets resolved.
Performance issue due to FND_CONC_PRIVATE_UTILS.record_temp_file_use with higher invalidations in V$SQLAREA (Doc ID 1526201.1)
Thanks for the document.
Is your issue solved.
an we find the source code(for e.g Concurrent program,Oracle report) by using the SQL's in the Alert log.
I did not clearly understand what you mean by finding the source using SQL in alert logfile.
But if you mean to ask to finding out the SQL coding of any concurrent programs or reports, then Yes you may obtain them by simply running a trace on the respective program.
I mean to say,
We want to find the source for the SQL's which are appearing in the alert log.
In the alert log we are getting multiple SQL's which are resulting into parsing errors.
So is it possible to find the source for these SQL's.
Source means SQL query belongs to which program(for e.g Concurrent program,Oracle Reports,Forms)
Apologies for misunderstanding..
Tue Aug 13 14:13:08 2013
kksSetBindType 16173533-2: parse err=1446 hd=3c73061fb8 flg=100476 cisid=173 sid=173 ciuid=173 uid=173
PARSE ERROR: ospid=15598, error=1446 for statement:
SELECT ROWID,ORGANIZATION_CODE,PADDED_CONCATENATED_SEGMENTS,PRIMARY_UOM_CODE,REVISION,SUBINVENTORY_CODE,TOTAL_QOH,NET,RSV,ATP,ORGANIZATION_NAME,ITEM_DESCRIPTION,INVENTORY_ITEM_ID,ORGANIZATION_ID,LOCATOR_ID,LOCATOR_TYPE,ITEM_LOCATOR_CONTROL,ITEM_LOT_CONTROL,ITEM_SERIAL_CONTROL FROM MTL_ONHAND_LOCATOR_V WHERE (INVENTORY_ITEM_ID=:1) and (ORGANIZATION_ID=:2) order by ORGANIZATION_CODE,SUBINVENTORY_CODE,REVISION, organization_code, padded_concatenated_segments
Assuming you see the above error message in the alert log file, which was your original post, follow the below steps:
1 Get the 'ospid' value from the error
2. Issue the below command:
SQL> select request_id,ORACLE_PROCESS_ID 2 from fnd_concurrent_requests 3 where request_id = 15598;
3. After obtaining the request_id
4, Query it from the front-end using SYSADMIN responsibility
Hopefully this should get you the respective concurrent report/program.