testoag

Document Sequence Go to  Order management Responsibility < Orders, Returns < Sales Order  Make a sales Order for Check the Sales Order Number for Mixed transaction type. Now Sales Order Number Series are 1000. And we want to start sales order number with 1. Now Go to Setup < Documents < Define Define sequence with the name “ Doc_Seq_Mixed” And create a sequence with initial value ‘1’. Note -: You can manage it accordingly and if you want to make it manual then select TYPE Manual . Now Save it. Go to Setup < Documents < Assign Select Categories Mixed for Transaction Type “MIXED”. Select Ledger name “ Vision Operation (USA) ”. Now Go to Assignment tab . Assigned Define sequence “Doc_Seq_Mixed”. Note -: If there are any existing Sequence for the particular time period then firstly fill end date for that sequence. Now Again Create the Sales Order and check the Series number for transaction type “MIXED”. Thus we can change the sequence number for any transac...

Error: - APP-PER-50022: Oracle Human Resource Could Not Retrieve a Value For The User Type Profile Option. Please ensure it is set the property for your responsibility. Solution-:      (1)  Go to System administrator > Profile > System       (2) Now Search “ HR: User Type ” Profile option at Responsibility level with Respective Responsibility. And Click On FIND Button. Now Select HR: User Type Value “HR with Payroll User” (you can choose another option as well accordingly). And SAVE. Now check your responsibility, error removed. Go ahead with your next step and enjoy Oracle Apps. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.

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...