Can Women be still successful even if there is no understanding husband behind her

             Behind every successful Women there is an understanding Husband

We have been hearing a lot about Samantha and Naga Chaitanya's divorce and each one of us judge this issue in our own way, so do you think Naga Chaitanya is not understanding Husband? do you think So Samantha cannot be successful ??

Below is my article about what do we actually mean by understanding Husband or Wife.

We hear popular quotes from famous personalities that "Always behind every successful women there is an understanding husband" I say its absolutely true for Indians,  because this is how is our culture and this is how we are being brought up and developed by the society.

Unfortunately I have to say that it is not Women's capability or intelligence that will make her successful, but its just THE " " understanding husband or understanding in-laws who can make their life.

For instance, if a women tries to take care of in-laws in every possible aspect and tries to keep them comfortable, strain free and happy by taking care of even the minutest needs of them ,respects them and sees that they are not burdened at all to stay with their son and daughter in law, then the society unabashed says that aah see how understanding in-laws she got!!. 

But believe me the reverse never happens ,where one can hear that they got supporting daughter in law. Not to blame any one!!!, because society sees the major chunk of people and decides that only a supporting in-laws are possible but can never be vice versa. 

Even though the entire family are supporting and understanding to each other, but still the word goes like this "she has got a supporting in-laws at home and hence she is successful".

If the husband is taking care of the family very well , spends time with the kids and wife and is a jocular person, then the society again credits the women that she has got an understanding and supporting husband. No one confesses that without a women supporting her man with peaceful environment and supporting him hand in hand and taking care of other small things at home and make a lively and joyful space for him, it is not possible to become a supporting husband. Also I say that we are all part of family and hence its everyone's responsibility to take care of each other, spend time for each other and at the end of the day you get happiness, but then what is that extra qualification we are giving to man by saying supporting husband "". 

Why don't we say the same to women that someone has got supporting wife??. Because we in the society feel that, wife being supporting is not added qualification to her, infact its her duty, responsibility and she is not doing any big deal by being supporting to the family .

But the same is an added qualification for Man in society.

I can say that it is very difficult to find pragmatic society anywhere.

If we think good, do good and chose right path and be moral in our decisions then I hope that every husband will become an understanding husband and every in-laws will become understanding in-laws and at the end every women become successful.

Said and Done all these points, finally I feel that there is nothing called as understanding or supporting Husband or understanding and support Wife to make a Man successful or Women Successful, Its ONLY because of mutual supporting and understanding and more than that being very flexible for each other is that a Man or Women or a husband and wife can become Successful, it can never ever be only one way .

Of course at the end of day we see different kind of people with different mentalities, the statement I pass might not suit to everyone, but if we take in general this is what is being observed everywhere and that is what I tried to present here in this article.

How to Convert Oracle Discoverer reports to BI Publisher reports

 Below are the details about how we can convert the oracle discoverer reports to BI Publisher reports.

1. Login to Oracle Discoverer with the corresponding user details and request the Administrator to assign the required responsibilities needed to view the reports.

2.After the login page you will be directed to select responsibility page where you need to select the responsibility and click on continue button.

3.Click on browse button below to search the report

4.You will find the list of all the reports ,select any report and click on open button

5.You will find the parameter list if the report has parameters, select the values in the parameters and the report will run and produce output

6.Now click on Tools Menu -> Show SQL to get the query written behind the report.

7.Copy the SQL Query , for additional conditions or calculations there are tab pages under available items on top left, you can verify for all those conditions.

8.Now create data xml with the same parameter list as you have seen above and use the query to create select statement in your data xml for BI Publisher report. Add the additional conditions noted in above steps to this select statement and also you can add the conditions.

9.As the Oracle discoverers are excel outputs, you can either build excel layouts or PDF layouts based on the requirement.

Query to get the All Supplier, Site and Bank Details at Site Level with or without bank setup at site level

Below query is used to retrieve the supplier, site and bank details of all the suppliers  belonging to particular org_id, also to retrieve the supplier and site information if no bank account is setup for a particular site. 

If a site does not have any bank account setup then only supplier and site details are displayed.

SELECT * FROM (select  distinct 

    asp.vendor_name "VENDOR NAME",

    asp.segment1 "VENDOR NUMBER",

      /* Supplier Site Information */

    assa.vendor_site_code "SITE CODE" ,

     assa.pay_site_flag   "PAY SITE FLAG",

    assa.purchasing_site_flag "PURCHASE SITE FLAG",

    assa.rfq_only_site_flag   "RFQ SITE FLAG",

    assa.ADDRESS_LINE1 ,

    assa.ADDRESS_LINE2,

    assa.ADDRESS_LINE3,

    assa.city,

    assa.state,

    assa.zip,

    assa.country,

     /* Bank Information*/

    NULL "ACCOUNT NUMBER",

    NULL "ACCOUNT NAME",

    NULL "Bank Account Type",

    NULL ext_bank_account_id,

    NULL bank_account_num,

    NULL  ext_bank_account_iban_number,

    NULL bank_account_name,

    NULL bank_account_name_alt,

    NULL bank_account_num_electronic,

    NULL  bank_account_end_date,

   NULL bank_branch_name,

   NULL bank_branch_name_alt,

   NULL branch_number,

   NULL branch_party_id,

   NULL bank_name_alt,

   NULL bank_name,

   NULL bank_number

FROM ap_supplier_sites_all assa,

  apps.ap_suppliers asp

 WHERE assa.vendor_id              = asp.vendor_id

and asp.segment1 = NVL(:P_VENDOR_NUMBER,aps.segment1)

and assa.org_id=:P_ORG_ID

MINUS

SELECT

/*Supplier Information*/  

distinct 

    aps.vendor_name "VENDOR NAME",

    aps.segment1 "VENDOR NUMBER",

      /* Supplier Site Information */

    assa.vendor_site_code "SITE CODE"   ,

     assa.pay_site_flag   "PAY SITE FLAG",

    assa.purchasing_site_flag "PURCHASE SITE FLAG",

    assa.rfq_only_site_flag   "RFQ SITE FLAG",

    assa.ADDRESS_LINE1 ,

    assa.ADDRESS_LINE2,

    assa.ADDRESS_LINE3,

    assa.city,

    assa.state,

    assa.zip,

    assa.country,

     /* Bank Information*/

    ieb.bank_account_num "ACCOUNT NUMBER",

    ieb.bank_account_name "ACCOUNT NAME",

    ieb.bank_account_type "Bank Account Type",

    ieb.ext_bank_account_id,

    ieb.bank_account_num,

    ieb.iban ext_bank_account_iban_number,

    ieb.bank_account_name,

    ieb.bank_account_name_alt,

    ieb.bank_account_num_electronic,

    ieb.end_date bank_account_end_date,

    ext_branch.bank_branch_name,

    ext_branch.bank_branch_name_alt,

    ext_branch.branch_number,

    ext_branch.branch_party_id,

    ext_bank.bank_name_alt,

    ext_bank.bank_name,

    ext_bank.bank_number

FROM

    apps.hz_parties hzp,

    apps.ap_suppliers aps,

    apps.hz_party_sites site_supp,

    apps.ap_supplier_sites_all assa,

    apps.iby_external_payees_all iep,

    apps.iby_pmt_instr_uses_all ipi,

    apps.iby_ext_bank_accounts ieb,

    iby_ext_banks_v ext_bank,

    iby_ext_bank_branches_v ext_branch

WHERE

        hzp.party_id = aps.party_id

    AND        hzp.party_id = site_supp.party_id

    AND        site_supp.party_site_id = assa.party_site_id

    AND        assa.vendor_id = aps.vendor_id

    AND        aps.enabled_flag ='Y'

    AND      ( aps.end_date_active IS NULL OR aps.end_date_active > SYSDATE)

    AND        iep.payee_party_id = hzp.party_id

    AND        iep.party_site_id = site_supp.party_site_id

    AND        iep.supplier_site_id = assa.vendor_site_id

    AND        ieb.bank_id = ext_bank.bank_party_id

    AND        ieb.branch_id = ext_branch.branch_party_id

   AND        ipi.instrument_id = ieb.ext_bank_account_id

   AND        iep.ext_payee_id = ipi.ext_pmt_party_id  

   and       (assa.inactive_date is null OR assa.inactive_date >SYSDATE  )                             

    AND        assa.org_id = :P_ORG_ID

   AND    aps.segment1= NVL(:P_VENDOR_NUMBER,aps.segment1)

  ) order by 1

 

            Trekkenture Camp @Mathapalli 

                      Siddipet Telangana 

Share in Whatsapp 

On Saturday 13^th November we went to a Trekking camp at Mathappalli village near Siddipet Telangana district which is 80 km from Hyderabad organized by Trekkenture.

Excited for the camp we started from Kukatpally at 11:00 A.M. and ORR, we passed through the famous shamirpet Maisamma temple and reached Mathapalli Village at 1:00 P.M. 

Our Trekking camp is hosted at the large forest kind of space. The Trekking hosts Ajit Sir and Bharathi Mam welcomed us with tilak and flowers wishing for a nice stay over the weekend. Surprise for the kids they got to blast lot of balloons to cheer up the kids, followed by a casual introduction with each other. We all were super hungry after travel of almost 1 and half hour, the lunch provided was more than my expectation as generally in the camp we are more inclined to physical activities than munching on food, but to my surprise the lunch was simply superb with all the delicious items in the menu like paneer, Butter naan, rice, other items and yummy gulab jamun as dessert.

Now its turn to choose our tents which were laid in the lush green meadows and they made choosing tent easy by asking kids to select their tent. We dumped our luggage’s in the tents and they asked us to take a break of 1 hour or so and get ready for trek. We took all the required things like torch, water bottles, hand towels and whatever we need to feel comfortable for almost 3 hours to walk in the woods.

While walking we came across the rocks which looked just like burger with patty in between, kids just loved that burger rock and then we moved on to see some ancient beautifully intricate rock paintings which depicted their hunting scene. Even though this painting was done centuries back but still the pictures were intact. Next we headed deep into the thick trees and meadows to reach the beautiful trekking place, we started to hike the steep hill, kids and adults were like Oh My God can we do this, but we supported each other, had lot of fun while climbing, it was both adventurous and fun to climb with kids. Finally, we made it to the hill top. All the efforts we put in has gone just like a jiffy when we saw the breath taking view from top of the hill. This hill is surrounded by river body with cloudy winters added to this the reddish rays during sunset covered the sky and reflecting in the water made the scene magnificent. It was a breathtaking view for all of us, hold on your breath when I describe you next scene, in this weather what would it be if we crave for a cup of hot tea and snacks to munch on and make the scene unforgettable, don’t you think we are expecting too much, yes it too much but we are so lucky that the Trekkenture people arranged us with nice tea and snacks, kids were overjoyed to enjoy the snacks on hill top there are no words to describe their excitement.

 We returned back to camp from there freshened up thinking for a quite evening, but we did not knew that we had more exciting things to look for, any clues what it is , even we had no clue that we are going to get to see wonderful stargazing in the dark nights .The Trekkenture people got telescope for us , we got to see the Saturn , no wonder when we saw the rings of the Saturn through telescope it was wow moment for us  and for kids it was amazing to see the planets with their eyes and map it with what they saw in books all the time, next planet we got to see was our favourite moon , it looked so different from telescope and the moon was looking spectacular, magnificent and all the words which we can add to describe it, the view of the holes and close look at the moon just made it an experience of astronaut landing on the moon , I am not exaggerating but this is what happened to all of us.

So, we had some fun games where parents and kids were involved we enjoyed those new type of games a lot and then we had an impressive and lavish dinner again out of my expectations, which included roti’s, fries (to enjoy nice chilly weather) , to add to this weather nice rasam made the meal complete followed by double ka meetha sweet. After the dinner we just enjoyed gathering sharing our hobbies , likes with each other at the camp fire and the returned to tent for a good night sleep.

 Next day we woke up at 6:00 A.M and enjoyed the cold misty mornings with dew drops on the plants. We had nice tea, boost and biscuits and surprisingly kids are ready before us for morning walk in the nature, they were more excited than us, so we started off and this time our walk was through nice ponds, water bodies, lakes. When we were passing through greenery we saw many birds like cuckoo, lapwing, ibis, red mantled sallebag, hycleus, wasp, lady birds and many more birds, the Trekkenture hosts had good knowledge about all these birds and we also learnt about different types of trees and their uses from them, it was like nature and biology lessons to kids with fun. We also saw weavers bird nests there were many to amaze us. We also went deep into the woods to find an ancient laksmi narasimha swamy temple , lot of monkey to watch for. Kids enjoyed the morning trek a lot looking at blooming buds, flowers, honey bees , I can say that they were very close and in the lap of nature ,This experience is just rare sight for most of us living in concrete jungles but we are lucky to gather all this memories with us . 

By this time all the kids became good friends of each other and we are back to camp for morning breakfast . It was always exceeded expectations from Trekkenture camp .Good amount of walk through nature increased the appetitie of kids, generally this generation kids when coming to eating they are very choosy and reluctant, but this time it was surprising to all the parents that they had more than what they generally they eat for breakfast. The yummy spread also tickled their taste buds and we enjoyed it like a brunch. 

Finally to conclude we were loaded with good memories, friends and nature experiences, taking back with us for life time from this Trekkenture.

Please follow below link for more details to contact Trekkenture 

 https://telanganatoday.com/promise-of-weekend-adventure-for-both-kids-and-their-parents.

 

How to Verify WEBADI Setup and How to Modify the existing WEBADI setup

                                

     Navigation and Path to verify the custom/core WEBADI setup.

                 1. Navigate to responsibility "Desktop Integration Manager" ->Manage Integrators

                   2. When you click on Manage Integrators and search window open up, Provide  the Integrator name and click on Search in the Integrator Name field

                 3. Click on the pencil Update button for the integrator you wish to see or modify the setup, click on Next button until you see the Interface Attributes for the integrator you selected.

               4. For each field or attribute that you see there are "Default Type" and Default Value".

              5. If you want to make changes to the attribute click on pencil update icon and you will see Interface Attribute Definition page which shows more fields that you an update according to your requirement.

              6.You can attach new LOV, change prompt name, validation type and other fields.

             7.After making the changes click on save button and this saves the Integrator definition and its attribute definitions.

Query to select the Integrator related packages.

SELECT BIT.USER_NAME WEB_ADI, BA.ATTRIBUTE2 "PACKAGE", BCT.USER_NAME "VIEW"
  FROM BNE_INTEGRATORS_TL BIT,
       BNE_ATTRIBUTES BA,
       BNE_CONTENTS_TL BCT
 WHERE --substr(BIT.INTEGRATOR_CODE,1,length(BIT.INTEGRATOR_CODE)-5)||'_P0_ATT' = BA.ATTRIBUTE_CODE
    BIT.APPLICATION_ID = BCT.APPLICATION_ID
   AND BIT.LANGUAGE = 'US'
   AND BCT.LANGUAGE = 'US'
   AND BA.ATTRIBUTE1 = 'PROCEDURE'
   AND BIT.APPLICATION_ID = BA.APPLICATION_ID
  -- AND BCT.CONTENT_CODE = substr(BIT.INTEGRATOR_CODE,1,length(BIT.INTEGRATOR_CODE)-5)||'_CNT'
  -- AND BIT.USER_NAME LIKE 'XX Test Create'
  and bit.integrator_code='XX Integrator'
   order by BIT.USER_NAME;

Related Tables:

BNE_INTEGRATORS_B

BNE_INTEGRATORS_TL

BNE_ATTRIBUTES

BNE_CONTENTS_TL

BNE_LAYOUTS_B

 

How to display the OA Framework Page attachment image stored in FND_LOBS table in the BI Publisher report output

 Problem: 

The attachments in the form images that are uploaded from OA Framework Pages will be stored in FND_LOBS tables, How to display these images in the BI Publisher report output.

Solution: 

Step 1: First we need to identify the record in fnd_lobs table .

        select FILE_ID,FILE_NAME ,FILE_DATA    from fnd_lobs where file_id = 695482.

        The file_data column actually contains the image content.

Step 2: Now the data that is stored in file_data column of fnd_lobs table is of type BLOB and we cannot display the BLOB data type directly in BI Publisher reports and we need to convert them to CLOB.

Step 3: create function to convert blob to clob

CREATE OR REPLACE FUNCTION APPS.BLOB_CLOB_TEST(p_source BLOB)
RETURN CLOB IS v_result CLOB;
BEGIN 

DBMS_LOB.createtemporary(lob_loc=>v_result,CACHE=>FALSE,dur=>0);
Wf_Mail_Util.EncodeBLOB(p_source,v_result);
RETURN (V_RESULT);
END BLOB_CLOB_TEST; 

Step 4: Use this function in the below SQL query to get the CLOB data type for column file_data.

            select FILE_ID,FILE_NAME ,BLOB_CLOB_TEST(FILE_DATA) IMAGE_FILE

    from fnd_lobs where file_id = 695482

Step 5: Use the query written in Step 4 in BI Publisher data xml.

Step 6: Display the element IMAGE_FILE in the RTF with below syntax in the field.

        <fo:instream-foreign-object content-type="image/jpg" height="1.25 in" width="1.5                 in">  <xsl:value-of select=".//IMAGE_FILE"/>  

Step 7: Run BI Publisher program and the output will show the image.

Concurrent program end in ERROR with "Program was terminated by signal 11'

  Issue: The concurrent program ends in error and the error message in the log file is "

Program was terminated by signal 11"

Cause of the Issues: This issue is occurred mostly in custom programs or the core programs.

custom programs: The reason for the error in custom programs is if you are calling core API's or submitting the core standard concurrent programs and those programs are upgraded to include additional parameters and if you are not including those parameters in your package or program then you get the error.

Core/Standard Programs: The reason for the error in standard programs is, if you have upgraded only the core programs and not packages, then either the program or the package which is not addressing the additional parameters exists then you get this error.

Solution: Identify the backend programs/packages or scripts which are calling with missing parameters added during changes or upgrade by Oracle and then add those parameters and retest the issue. The issue should be resolved.

Query to find the Operating Unit Name for the Journal Ledger created in Oracle Apps General Ledger

 Below is the query which gives details about legal entity name, ledger name and operating unit name 

SELECT * FROM XLE_LE_OU_LEDGER_V where ledger_id in (select ledger_id from gl_je_headers where name ='Journal Name' and description like 'Journal%Import%230808858%')

How to develop BI Publisher reports with mulitple spread sheets Excel Layout Outputs

       BI Publisher reports  Multiple spread sheet Excel Layout Outputs

Below are the steps to develop the Excel Layouts for BI Publisher report Excel outputs.

1. First open a new Excel sheet.

2. Design the Data XML with Groups and data elements as you create for any other BI Publisher outputs.

3. In the Excel sheet, Name the first spread sheet as 'Customers',the second spread sheet as 'Sites','Site Uses' and Contacts.

4. Navigate to Tool Bar of Excel sheet and click on the Menu Formulas -> Name Manager. Click on New and provide the Name field as 

"XDO_?ACCOUNT_NUMBER?.The name of the element in the data xml should be exactly same as the Name field you give.

In the example: The DATA XML element should be

<element name="ACCOUNT_NUMBER" value="ACCOUNT_NUMBER" />

In Excel sheet field it should be "XDO_?ACCOUNT_NUMBER?

The "Refers to" field will point to the field in the excel sheet where you want the data to appear. You can manually change it to refer to any field in excel sheet.

Note: You should provide a dummy name in the field where you are expecting data to be populated .

5. Once you define all the elements in the group in Excel, now you should define which group all the elements defined in the excel belongs to by clicking Name Manager in tools menu -> New -> Name Field ='XDO_GROUP_?G_CUST_ACCT?' and the Refers to field should define the all the fields from first field to last field.

In the below screenshot it shows that all the elements defined from cell A18 to AM18 belongs to group G_CUST_ACCOUNT.

6. Similarly create another spread sheet called as "Sites", repeat steps 4 and 5 to define new site elements and group which belong to sites.  

Note: The group names and element names should always be same as data xml element names and group names.

7.Finally by default you should create one spreadhseet called as "XDO_METADATA"

7.Save the file as Microsoft Excel 97-2003 Worksheet (.xls)

How to Resolve SQL Injection /Second Order Injection Attack in PL/SQL

When the PL/SQL Code is detected with SQL Injection Error, How to Resolve?

SQL  Injection is simple type of attack and can be avoided with basic coding practices.

Below are some of the ways of best coding practices.

Avoid Dynamic SQL's rewrite them into static SQL.

If you must use dynamic SQL, try not to construct it through concatenation of input values. Instead, use bind arguments.

If you cannot avoid input concatenation, you must validate input values

1. Execute Immediate: This should not be used as it is vulnerable for hacker and hence should be replaced with DBMS_SQL for dynamic execution of the sql queries.

2. Parameters: If the concurrent program is using a procedure which has  a parameter that can be hacked by the user, then you need to sanitize the parameter using .

You can filter the input values using DBMS_ASSERT Functions.

DBMS_ASSERT .QUALIFIED_SQL_NAME is used to verify that the string is a simple SQL name.

DBMS_ASSERT .ENQUOTE_LITERAL should be used if you want to pass the character variable values in quotes. This is used to enclose the string literal within single quotation marks

How to Maintain an Easy Life at Villa Just Like Apartment Life

 

                      HOW TO MAKE LIFE AT EASE @ VILLA

Have you ever experienced the conversation where someone buys a new villa and was excited to share the news with friends or families and the reaction you often see from others is Congratulations!!!!!, We also planned to buy a villa but turns out maintaining a villa was not so easy as we thought it was.

It will be fascinating to buy and become a proud owner of a big house. If you also plan to  manage the big independent home, then it will surely be a magnificent home to live a happy and a healthy life.

When you wish for something then you own it and have a will to find ways to Enjoy.

Below are few easy things that you can plan everyday to  reduce strain

1. Reduce the trips to first floor which needs climbing stairs frequently.

2. Take Bath once a week , in each washroom , this way you can maintain all the washrooms without the need of any maid or help.

3. Have a Basket with rope , this helps to pass on the needed things to upper floors.

4. Book Urban clap for home cleaning every 6 months as a package, this helps to restrain yourself from too much of cleaning ,which might have impact on your health in future.

5. Have a used clothes bin near every wash room.

6. Spend at least 5 minutes of time for each bedroom in the morning which includes quick make over of the bed, arranging misplaced items .

7. Do not use the age old cloth curtains for windows they need lot of maintenance efforts of washing .You can go for latest trend of roller blinds, which only needs dusting and at the same time gives chic look to home with customizations and is also lot maintenance free.

That's all it takes ,bingo!! you are done for the day.