testoag

Functional Security In ORACLE APPS User End user, using the application front end interface. Responsibility Privileges to the user. Menu Hierarchal arrangement of Sub Menus and Functions . Sub Menu Hierarchal arrangement of functions. Functions A Function calls a form. Form A Form is a GUI (Graphical User Interface). For More Information Visit on  www.OracleAppsGuide.com  Or Subscribe your email-id on OracleAppsGuide

Lookup Customization Levels , Lookup Type and difference between "LOOKUP" Or What is "LOOKUP" User Ø   Insertion of new codes is allowed Ø   Updating of start date, end date, and enabled fields is allowed Ø   Deletion of codes is allowed Ø   Updating of tag is allowed Extensible Ø   Deletion of lookup type is  not  allowed Ø   Insertion of new codes is allowed Ø   Updating of start date, end date, enabled fields, and tag is allowed  only  if the code is not 'seed data' Ø   Deletion of codes is allowed  only  if the code is not 'seed data' Ø   Updating of module is  not  allowed System Ø   Deletion of lookup type is  not  allowed Ø   Insertion of new codes is  not  allowed Ø   Updating of start date, end date, and enabled fields is  not  allowed Ø   Deletion of codes is  not  allowed Ø   Updating of tag is  not  allowed Ø   U...

APP-PO-14624: Source organization is missing or invalid. At the time of creating an internal requisition with Source name Inventory and entering the Organization name that time this error occurs. Firstly check whether used Item should be ‘Transactable’, ‘Stockable’ & ‘Internal order enabled’ at both level Source and destination Organizations. Go to Inventory > Items > Master Items > Find the Item. Now go to Inventory tab and check attribute ‘Stockable’ and ‘Transactable’ are checked or not (It should be).And In Order Management tab, check ‘Internal Orders enabled’ attribute is available. Careful –: If Item attribute ‘Internal ordered’ is enabled then we cannot enable “Internal Orders enabled” attribute. Unless all the above three attributes are enabled we cannot Proceed with the Internal Requisition. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide

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