Posts

Quality Cost and Delivery - Oracle Purchasing

Hello Friends, This is another blog, sharing with you guys more informative and quite useful for you hopefully. :) Well this is one feature we have discovered while working in oracle purchasing.  Just finish of one implementation and got chance to share this nice concept with you.  First of all, I would like to thank my friends Kedar Deshpande and Amit Agarwal - Oracle apps experts who are the thought worker of this concept.  To begin with  This topic is about identifying best supplier based on 3 factors (Quality, cost and Delivery) Concept Supplier Quality Cost and Delivery (Acronym SQCD or QCD). Functionality is to identify best supplier based its transaction history on 3 factors 1)     How Cost effective material provided, 2)   How was Quality of a material on basis of material rejection ratio during GRN. If collection plan is attached to material then based on material specifications provided by supplier; Material is inspecte...

Search on Master-detail table in OAF

Search on Master-detail table in OAF Hello friends, Oracle application framework provides me another opportunity to work on and to get more acquainted with. So here I am eager to share another short article on OAF.  Just finished a project on OAF and came across various fact and findings about the framework. You guys may have come across master – detail relationship in OAF and ‘how-to’ behind that as well.  I have recently read articles on how to insert a row into child table. Well this article is quite a different one. While developing an application, there might be a requirement wherein we need to work on master detail relationship.  In my case, the requirement was to develop the search page having result table including master and detail table records.  The user may enter any search criteria that may fall under master table and/or detail table. Depending upon the search performed by the user, the master and detail table records must be populated. For...