testoag

Error:- APP-SQLAP-10771: Could not reserve record. Solution :- Step (1) Run the query given below- : SELECT vlo . object_id , vlo . session_id , substr( dbo . object_name , 1 , 40 ) OBJECT_NAME FROM v$locked_object vlo , dba_objects dbo WHERE vlo . object_id = dbo . object_id AND dbo . object_name like 'AP_%' ORDER BY dbo . object_name ; Output look likes-: OBJECT_ID SESSION_ID OBJECT_NAME 41097 495 AP_INVOICES_ALL Step (2)  Now again Run the Query given below-: SELECT l . * , ao . owner object_owner , ao . object_name FROM SYS . all_objects ao , v$lock l WHERE l .TYPE = 'TM' AND ao . object_id = l . id1 AND ao . object_name in ( 'AP_ALLOCATION_RULES' , 'AP_ALLOCATION_RULE_LINES' , 'AP_INVOICES_ALL' , 'AP_INVOICE_DISTRIBUTIONS_ALL' , 'AP_INVOICE_LINES_ALL' ); Output:- ADDR KADDR SID TYPE ID1 ID2 LMODE 00000003BDC546F0 00000003BDC54748 495 AE 352852 0 4 REQU

How can increase session timeout in oracle apps Using ICX:Session Timeout . “ICX:Session Timeout” Profile Option For Change the session Timeout.       (1)     Got to System Administrator --< Profile --< System        (2)     Find Profile name “ ICX:Session Timeout”   Now you can change Session Timeout accordingly in minutes. Other Related Profile option For  “ ICX ”. Parameter Default Recommendation ICX:Session Timeout None 30 (minutes) ICX: Limit Time 4 (hours) 4 (hours) ICX: Limit Connect 1000 2000   “ICX:Session Timeout” Profile Option For Change the session Timeout. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide

Example of $FLEX$ Syntax Used In Value Set ($flex$ in oracle apps) Example of using “ :$FLEX$.Value_Set_Name” to set up value sets where one segment depends on a prior segment that itself depends on a prior segment. Suppose you have a three-segment flexfield where the first segment is Country , the second segment is State , and the third segment is District . You could limit your third segment's values to only include Districts that are available for the Address specified in the first two segments. Your three value sets might be defined as follows:  Segment Name               Country_Segment Value Set Name              Country_Value_Set Validation Table              Country_Table Value Column                Country_NAME Description Column      Country_DESCRIPTION Hidden ID Column        Country_ID SQL Where Clause        (none) Segment Name              State_Segment Value Set Name             State_Value_Set Validation Table             State_Table Value Column