Showing posts with label oracle apps technical. Show all posts
Showing posts with label oracle apps technical. Show all posts

Conditionally disable DFF components in Oracle apps

A frequent requirement in most Oracle Applications implementations is to be able to conditionally disable one of the components of a Descriptive Flexfield (DFF). DFFs follow the “all or none law” for a given DFF context. If a DFF is displayed, it is enabled and can be changed. The only exception to this rule is when the entire record is read-only. However, if your DFF is using five attributes, there is no mechanism to disable one attribute out of the five attributes. Also, since the DFF window is a user exit call, you cannot disable any attribute field by using set_item_property. We’ll show you how to protect DFF using CUSTOM.pll.
Read more »
at 8:09:00 AM
Labels: , , , , , , ,

Oracle Purchasing Important Queries

--Purchase Order, Requisition and Receipt Details Query

SELECT prh.segment1 requisition_number,
       prl.line_num requisition_line_num,
       ph.segment1 po_num,
       pl.line_num po_line_num,
       rsh.receipt_num receipt_num,
       rsl.line_num receipt_line_num,
       pll.line_location_id,
Read more »
at 10:58:00 PM
Labels: , , ,

Oracle apps interview questions and answers

I have browsed thru many sites for some good oracle apps interview questions. I’ve spent hours in doing so, but could not get the best one. I’ve ended up in preparing some list of questions after searching the net.


Hope these will be useful for my oracle apps friends around the world. Happy Reading.
Usually questions will be asked on PL/SQL, AOL, technical & functional topics of oracle apps. So i will cover all the 3 topics.

 ------------------------
We provide sample demo projects with all the relevant code.

If you are interested to get the Sample projects, please drop me an email (oracleapps4all@gmail.com) it will include the following:

NOTE: This service is NOT FREE

1. Code + technical design + Functional requirement docs
2. 2 Interfaces (Inbound-1 & outbound - 1)
3. 2 Reports (RDF with XMLP)
4. 2 form customization
5. 1 conversion
  1. Following are the interview questions:
at 12:57:00 AM
Labels: , , ,
Subscribe to: Posts (Atom)