Oracle EBS11i: IC_LOTS_MST and PO_VEND_MST

EBS11i: IC_LOTS_MST and PO_VEND_MST Today I have been asked to extract data from 'LOT/SUBLOT  Function' from OPM Inventory responsibility e.g. I have to show Item_no, Lot, Vendor and Creation_Date where onhand quantity of that particular item must exists. IC_LOTS_MST and PO_VEND_MST I wrote query: select item_no,lot_no,ilm.vendor_lot_no,        (select vendor_no         from po_vend_mst...

Read More

ORA-00600: internal error code, arguments

ORA-00600: internal error code, arguments ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause:This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition. Action:Report as a bug - the first argument is the internal error number Yesterday I was working on report in Oracle Report...

Read More

VNCserver graphics problem [Solved]

VNCserver graphics problem [Solved] 1- Kill exsisting session of vnc    vncserver -kill :<port> 2- vi .vnc/xstartup --Follow the following convention uncomment lines having * -- Here * is used for highlighting purpose. #!/bin/sh # Uncomment the following two lines for normal desktop: * unset SESSION_MANAGER * exec /etc/X11/xinit/xinitrc [ -x /etc/vnc/xstartup ] && exec /etc/vnc/xstartup [ -r $HOME/.Xresources ] && xrdb $HOME/.Xresources * xsetroot -solid grey * vncconfig -iconic & * xterm -geometry 80x24+10+10...

Read More

ADPATCH how to apply patch

How to apply a Patch? Step 1 -Download the patch from metalink. It is better to check the table 'AD_BUGS' if the patch is already applied then no need to apply again. you can check list of applied patches as follows: select *    from ad_bugs  where bug_number = 'patch_number'; if this query returns any row then it means this patch is already applied. to see the difference between 'AD_BUGS' and 'AD_APPLIED_PATCHES' please...

Read More