http://chandramouly.com Mon, 24 Mar 2008 22:41:13 +0000 http://backend.userland.com/rss092 en One of my friend started a tech blog(venkat's techlog), he is a linux geek and it was coincident to see another site which is just named techlog.org (group of microsoft enthusiasts who own this site). I got this info when I just googling and wiki'ing about techlog... All the best Venkat! http://chandramouly.com/2008/03/24/techlog/ To convert from CUSTOM.pll to CUSTOM.pld f60gen module_type=LIBRARY module=CUSTOM script=YES userid=apps/apps To convert back from CUSTOM.pld to CUSTOM.pll f60gen module_type=LIBRARY module=CUSTOM parse=YES userid=apps/apps To convert from CUSTOM.pll to CUSTOM.plx f60gen module_type=LIBRARY module=CUSTOM userid=apps/apps http://chandramouly.com/2008/02/12/pll-to-pld-plx-conversion-oracle-apps-forms/ WFLOAD 0 Y {UPLOAD | DOWNLOAD | UPGRADE | FORCE} [@:] [] To upload workflow definition for sample modified custom workflow customwf.wft WFLOAD apps/apps O Y UPLOAD customwf.wft To download a workflow definition from database and write it as a flat file in the disk. This is a common case that we ... http://chandramouly.com/2008/02/04/oracle-workflow-definitions-download-upload/ To query a specific table in oracle apps: SELECT * FROM ALL_TABLES WHERE TABLE_NAME = 'AP_INVOICES_ALL' -- Name of the table To query a specific column with or without table name: SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME ... http://chandramouly.com/2008/01/06/oracle-apps-useful-sql-scripts/ Even though we have search engines, so many user guides to browse, metalinks and oracle forums. Running some piece of code and getting it executed is pain. I was facing some issues in running the OE order creation API which I couldn't figure out for sometime, then this blog link ... http://chandramouly.com/2008/01/04/oe_order_pubprocess_order-sales-order-creation-api/ This post will explain you how, where, what on BIP. See the above screenshot, you can download the BIP Enterprise edition and BIP Desktop tool everything FREE! from the Oracle website, here. First lets discuss about the BI Publisher Desktop a.k.a Template Builder for Word, unfortunately its available only for Windows and ... http://chandramouly.com/2007/11/07/bip-getting-started/ This may look crazy, but as a developer I am in need of this, I need a Trash where I can go and look all useless scripts developed by other developers, architects during their dev phase, testing phase, etc., This may reduce my development time in creating all the scripts ... http://chandramouly.com/2007/11/03/trash-20/ Yes! I moved from Hyderabad, India to California. Things are slowly getting settled down here, new company, new culture and new place. Started blogging after long time, but from now I hope it will be in top gear! :) http://chandramouly.com/2007/10/30/im-in-transition/ Most likely I will be attending Barcamp-LA4 - TBD. http://chandramouly.com/2007/10/09/barcampla-4/ XML - eXtensible Markup Language is more like HTML and its mainly used to describe your data. The user can define their own tags. Eg: <author>, <city_name>. Its one of the World Wide Web (W3C) consortium recommendations. XML is widely used nowadays to bridge the gaps between different platforms, distributed data sharing ... http://chandramouly.com/2007/06/14/introduction-to-xml/