Implementing User Profiles : You should define user profile options whenever you want your application to react in different ways for different users, depending on specific user attributes. You can decide whether your end users can view and update options you define at the User level or you can also define the option such that […]
Q. AME is possible in PO approval ?? NO. AME for Req approval Q. Can we create Position heiracchy for Requisition Approval Yes Q. vacation rule has to be created by the same user…if being as a first person in the approver goup the user not able to create vacation rule and goes on leave…then […]
Following scripts used to test Payable open Interface for Invoices contains Project Data: Query for to get PO details: –select * from po_headers_all where PO_HEADER_ID=63845–AND segment1=’NEX060378-002′ –select * from po_lines_all where po_header_id=63845–select * from po_vendors where vendor_id=11813 –select * from po_line_locations_all where po_header_id=63845 –select * from PO_DISTRIBUTIONS_ALL –select * from ap_invoice_lines_interface –commitQuery to Set Org_id: –begin–dbms_application_info.set_client_info(‘169’);–end; –select * from […]
Whenever we Procedure taking too much time to compile and we want to close the session or cancle the compilation we need to kill the session. If we need the PC Name Based Query :: select * from v$session where TERMINAL =’Name of user’s Computer’ Query for when we know the Object Name and we […]
1. Report Name :- Inactive Item Report (Inventory) Customization :- Add one field Transaction Qty to report Short Name :- INVIRSLO Parameter :- Organization,Subinv Break Option,Category Set Name,Inactive From Date Table :- mtl_system_items , mtl_material_transactions , mtl_item_categories, mtl_categories. Solution :- See the parameter listing which is required for the report with […]
Recent Comments