Search This Blog

Wednesday, August 13, 2008

Increase Session Timeout Time

The session when kept inactive for certain period gets inactive and hence we need to relogin again.
It sometimes become frustating when working on a test instance and makes us login again and again. This can be avoided by setting a profile option.

Profile "ICX_SESSION_TIMEOUT" can be used to increase the session timeout time.

10 Comments:

Lakki Reddy Sreehari Reddy said...

HI suresh,
working on import itrm programs.
while running this program, i am getting following error.

TRANSACTION ID : 35495489
ORGANIZATION ID : 161
TABLE NAME : MTL_ITEM_REVISIONS_INTERFACE
COLUMN NAME : ITEM_ID
MESSAGE NAME : INV_IOI_REV_NO_ITEM
ERROR MESSAGE : The revision entered is for an item that does not exist in MTL_SYSTEM_ITEMS nor MTL_SYSTEM_ITEMS_INTERFACE.

i verified revision in MTL_SYSTEM_ITEMS_INTERFACE and revision is 000.

Suresh Vaishya said...

Ignore this error message. This is raised because the item is not loaded and has some error.

Lakki Reddy Sreehari Reddy said...

Hi suresh,

Because of above errors,
Item not uploaded into MTL_SYSTEM_ITEMS_B.

Suresh Vaishya said...

Its actally reverse. Query against mtl_interface_errors table using transaction_id and request_id to get more details on error.

For every item that fails loading this message is displayed on revision table.

Lakki Reddy Sreehari Reddy said...

Hi Suresh,

i am getting following error.
Because of this error, i am unable to unsert items.

ERROR :
==============
The PRIMARY_UNIT_OF_MEASURE or PRIMARY_UOM_CODE is not a valid Unit of Measure in MTL_UNITS_OF_MEASURE or the two values are not in agreement.
================================
I am running Item import fro two languages

for english(US) : UOM_code='EA' amd primary_unit_of_measure='EACH'

fot german(D) : UOM_code='EA' amd primary_unit_of_measure= 'Stück'

for english, item import running fine.
But, for german, Item import giving above error.

Lakki Reddy Sreehari Reddy said...

Hi suresh,

I ithink, for german,
primary_unit_of_measure= 'Stück'.

please verify stuck. STUCK using some special symbols ( 'U' in 'STUCK').

I think because of that special character, item program giving errors?

Suresh Vaishya said...

I think you are correct but not sure how you can fix this problem.

Lakki Reddy Sreehari Reddy said...

hi suresh,

In code,i used like :
V_UOM :=to_char('Stück');

But its not working.

You have any idea, to handle special characters in IMPORT ITEM Program?

Lakki Reddy Sreehari Reddy said...

please advice on this issue.

Lakki Reddy Sreehari Reddy said...

Hi Suresh,

I discussed with my friends.
Thety told, 'Stück' is not a special symbol. its a german language("EACH" IN ENGLISH). Oracle apps supports multilanguage. So, we can upload 'Stück'through item import.

But for this is am getting ablove error.Not able to upload item if UOM='Stück' and i am able to upload remaining UOMs.

Please give me advice.

Copyright (c) All rights reserved. Presented by Suresh Vaishya