गारपीट

                                                ।। गारपीट ।।                             


आल्या पावसाच्या धारा,
सरा  मांडला पसारा,
उभं पिक रानामधी,
गेल्या  नासवून गारा. 

झाला   फुलाले अघात,
समधि गळाली रे पानं
पाणी पाणी चोहीकडे 
तरी जळाली रे मनं 

                                                       काही माणूस भी गेले 
                                                       काही तुटले छप्पर 
                                                       कुठे जीवाच्या भयाने 
                                                       पार हंबरती गुर 

                                                       कुठे गहू कुठे कांदा  
                                                       कुठे दाळिंब अंगूर 
                                                       कुठे गळा लागे फास 
                                                       खेळ नियतीचा क्रूर 

ऐक माझ्या देवा 
माझं एकच गाऱ्हाणे 
इडा पिडा हि जाऊदे 
एवढ  एकच मागणे 

नको हिरे मोती 
हवी कष्टाची पावती 
सुखी ठेव बळीराजा 
सुखी ठेव काळी माती …. 

                                    --अविनाश 

मनाचे मनाशी पटेना कुणाशी
कुणाला कळेना हि चूक! कुणाची

मुकी भावना हि डोळ्यात पाणी
मुक्या आसवांची मुकी हि कहाणी
मुक्यानेच बोलू मुक्या साजानाशी
मनाचे मनाशी ….

जुनी भेट आपली नव्याने आठवते
पुन्हा भेटीसाठी नवी सांज झुरते
का ऐकू येत नाही साद तुझ्या कांकनाची
मनाचे मनाशी ….


                                         -- अविनाश

Oracle APPS Create Responsibility and User in Oracle EBS

How to create Responsibility and User in Oracle EBS

How to Create a Responsibility?

Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User.

Step 2: Go to Application Administrator.

Step 3: Go to Security then Responsibility then Define

Step 4: Enter the Data in the opened Window.

Note: Above Information of Responsibility is stored in FND_RESPONSIBILITY Table.

How to Create a User?

Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User.

Step 2: Go to Application Administrator.

Step 3: Go to Security then User then Define

Step 4: Enter the Data in the opened Window.

Note: Above Information of User is stored in FND_USER Table.

User Responsibilities stored in FND_USER_RESP_GROUPS Table.

Use of Who Columns in Oracle APPS table

Oracle APPS : WHO COLUMNS

WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the WHO columns in a Table when a DML operation s (i.e. INSERT, UPDATE) performed.

Steps required to Track WHO Information in our form

  1. ALTER the table by adding WHO columns in the table.
  2. Open TEMPLATE.fmb in form Builder.
  3. Perform all the pre‐requisites to develop a form.
  4. Include all the WHO columns in the Data Block with NULL Canvas.
  5. Call FND_STAND.SET_WHO procedure in Pre‐Insert and Pre‐Update triggers
      at Block Level.
  6. Save and Compile the Form.
  7. Perform all the pre‐requisites to register the form

Note: 1. WHO Columns need not register with the table registration option.
          2. Table registration will be done only for KFF and DFF columns.
          3. For Form development table registrations not required.

To Show the Module Form Directory Path
1. In PRE‐FORM Trigger change the module name from FND to specific module
short name (i.e. EX, INC, PPR, etc.,).

2. Save and Compile the form.

Debug OAF Page

How to Debug OAF Page

We can enable logging by setting the below profile option:-

Option: 1)
• FND: Debug Log Enabled profile set to ‘Yes’
• Turn on low level statement logging for a single user to monitor
• FND: Debug Log Level= Statement



Option: 1)
Another way of gathering the same info is the following:

1)  Enable profile option FND: Diagnostics 
2)  Add following at the end of existing page URL,   &aflog_level=Statement&aflog_module=*

• Use '*' for wildcard, not '%'. '%' is a special URL character)

Example:
• http://host:port/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE&aflog_level=STATEMENT&aflog_module=pa

You can see the log on screen by using by below code in your controller OR in Application ModuleImpl

For AM

getOADBTransaction().writeDiagnostics(this, "I am in the Application Module", 1);

For Controller

 pageContext.writeDiagnostics(this, "I am in Controller PFR", 1);

राजकुमार

                      ।।   राजकुमार  ।।

सुंदर रातीला
सुंदर पहाटे 
सुंदर झाली सकाळ ,

सुंदर राज्यात
सुंदर राजाचा
सुंदर राजकुमार .

                                        अल्लड वाऱ्याची
                                        अल्लड झुळुक
                                        अल्लड ही सायंकाळ,

                                        अल्लड चालणे
                                        अल्लड बोलणे
                                        अल्लड त्याचा रुबाब.

रंगीत फुलाची 
रंगीत पाकळी
रंगीत आला सुवास,

रंगीत मनात 
रंगीत विचार
रंगीत त्याचा अभास.
                           
                                      भन्नाट गाण्याच
                                      भन्नाट संगीत
                                      भन्नाट सूर ताल,

                                      भन्नाट देशात
                                      भन्नाट राणीचा
                                      भन्नाट राजकुमार…।


                                                                      --अविनाश काळे

 

Use CUSTOM.pll for forms customization

What is the CUSTOM Library

- Standard oracle liabrary supplied with Oracle Applications

- Allows customer to enhance standard functionality of the oracle Applications

- Every forms based screen will access CUSTOM.pll

- Ideal point to create business rule which affects entire organization

- This is the Only method supported by Oracle for Oracle Applicaitons enhancements

How to Use the CUSTOM Library

Since the CUSTOM library is a typical Forms PL/SQL library, it can include standard PL/SQL logic, Oracle Forms

built-in commands and may have other Forms PL/SQL libraries attached to it. The base CUSTOM library is located

in the $AU_TOP/resource directory on your forms server.

Explore the CUSTOM.pll using the Oracle Forms Designer module to examine the sample code that exists in library. Once any enhancements are made, the library must be generated into an executable library (CUSTOM.plx) that then can be used by the Oracle Applications Forms runtime module. Since the CUSTOM library is loaded once for a given session, a user must log out of the application and sign-on again before any changes will become apparent. It is suggested that you also place a copy of the CUSTOM library in your customization directory as a safety precaution.

Since the CUSTOM library’s standard location is in the $AU_TOP/resource, it can be

overwritten during an upgrade of the Applications. Once enhancements are implemented, the CUSTOM library is accessed by the Oracle Applications based upon ‘events’. The ‘events’ define the occasions when the Applications will look into the CUSTOM library for additional code to execute.

Some events are generic:

        WHEN-NEW-FORM-INSTANCE – initially entering a form

        WHEN-NEW-BLOCK-INSTANCE – entering a zone (or block) within a form

        WHEN-NEW-ITEM-INSTANCE – moving into a new field within the form

        WHEN-NEW-RECORD-INSTANCE - creating a new record

        WHEN-FORM-NAVIGATE – navigating thru a form using the mouse

        WHEN-VALIDATE-RECORD – saving (committing) the information to the database

        EXPORT – triggered by using the Export feature

Some events are field specific

        ZOOM – Pre -11 feature for moving to another form and querying up specific records

Some events are form specific

       SPECIALn - (where n is a number between 1 and 45) used to generate entries in the ‘Special’ menu of the

                         tool bar and the code is triggered by selecting a menu choices from the ‘Special’ option on the toolbar

       KEY-Fn – (where n is a number between 1 and 8) triggered by pressing the corresponding function key

Some events are application specific:

       Application Object Library

           WHEN-LOGIN-CHANGED – when a user logs on as a different user

           WHEN-RESPONSIBILITY-CHANGED – when a user changes responsibilities

           WHEN-PASSWORD-CHANGED – when a user changes their password