Posts

Query to Get On-hand Stock at Organization, Subinventory, Locator for the lot and non Lot Items

SELECT     mp.organization_code,     mpoq.subinventory_code,     mil.segment1|| '.'|| mil.segment2|| '.'|| mil.segment3|| '.'|| mil.segment4 locator,     msib.inventory_item_id,     msib.segment1 item_number,     msib.description,     msib.inventory_item_status_code item_status,     msib.primary_uom_code,     SUM(mpoq.primary_transaction_quantity) onhand_qty,     mpoq.secondary_uom_code,     SUM(mpoq.secondary_transaction_quantity) sec_onhand_qty,     mln.lot_number,     TO_CHAR(mln.expiration_date,'DD-MON-RRRR') expiration_date,     mms1.status_code lot_status,     msib.organization_id FROM     mtl_system_items_b msib,     mtl_item_status mis,     mtl_item_locations mil,     org_organization_definitions mp,     mtl_lot_numbers mln,     mtl_onhand_quantities_detail mpoq,     mtl_material_statuses_tl mms1,     mtl_material_statuses_tl mms2,     mtl_material_statuses_tl mms3,     mtl_secondary_inventories msi WHERE     1 = 1  

Query to find Legal Entity, Organization, Company Code

This summary is not available. Please click here to view the post.

Unable to launch the Java Virtual Machine Located at path: ..\..\jdk\jre\bin\client\jvm.dll

When you run the SQL Developer or Jdevloper for first time you may see the below error ERROR: Unable to launch the Java Virtual Machine Located at path: ..\..\jdk\jre\bin\client\jvm.dll SOLUTION: 1. go to Control Panel->System->Advanced System Settings->Environmental Variables 2. Update the 'Path' setting to include the following directory: '<jdev home dir>\jdevbin\jdk\bin' 3. Reopen the jDeveloper.
Image
OAF: The program can't start because MSVCR71.dll is missing from your computer. In one of my project, in one machine we were not able to open the Jdeveloper  (Version 10.1.3.5 -  Patch 19170592  ) which we downloaded from the Metalink Note. This post is to help those who face this issue and don't know what to do to fix this. OA Framework - How to Find the Correct Version of JDeveloper for OA Extensions to Use with E-Business Suite 11i or Release 12.x (Doc ID 416708.1) After downloading  p19170592_R12_GENERIC.zip , unzipped the contents into  C:/oracle/Jdev10.1.3.5 . After that when we tried to open the Jdeveloper using  C:/oracle/Jdev10.1.3.5/jdevbin/jdev/bin/jdevW.exe , we were getting the below error. " The program can't start because MSVCR71.dll is missing from your computer. Try reinstalling the program to fix this problem. " Fix:   You just need to copy the  msvcr71.dll  file from  C:/oracle/Jdev10.1.3.5/ jdevbin/ jdk /bin  to  C:/oracle/Jdev10.1.3.5/

Creating (AOL objects) Function,Menu,Request group,Responsibility,Concurrent Program,Users,Flex fields,Value sets,Profile Options from Application and with API Script (Backend)

Image
AOL is a collection of pre-built application components and facilities and it consists of forms, subroutines, concurrent programs and reports, database tables and objects, messages, menus, responsibilities, flex filed definitions, various guides and library functions . Objective: §    Register custom Application components. §    Understand the security authorization features of Oracle Applications. §    Run concurrent programs using Standard Report Submission. §    Design and implement Key and Descriptive Flex fields. §    Define and modify user profile options. Agenda: §    Setting Up Your Application. §    Flex fields. §    Profiles. Setting Up Your Application: §    Oracle Applications and custom applications that integrate with Oracle §    Applications need to have a particular directory structure where its §    Components must be available. Those components are, 1.        Forms 2.        Menus 3.        Programs 4.        Reports. R