How My Ad-Sense Got Approved For My Personal Blog in 2017

I always wanted to write. But, the only problem was I didn't know what to write about. I am not an expert on anything and who would care about my opinion.However, I started a blog in 2015 and wrote 4 posts. Yes, that's right. For the whole year, I just wrote 4 posts and it got buried somewhere. 

In 2016, I got a triumph over my fear of driving. I got my Driving License. Well yes, that was my heroic tale. I was excited and thought of sharing it with everyone. I started another blog to communalize my experience. After that, nothing significant happened in 2016 and hence I did not get much to talk about.
This year(2017), before a tech interview, I was looking for my notes, that I made last time. But soon I discovered that notebook has turned into my daughter's scribbling pad. I thought of starting a Tech Blog where I will keep my notes ready. I opened Blogger to create a new blog and then I found out all my old blogs. I was stunned to see that my driving test blog has so many views! It was an amazing feeling! There are people who are reading my blogs, whom I don't know and who don't know me! There is no judgment and obligation and that's a relief. It occurred to me, that I don't have to be an expert to write. I have my share of stories to tell, my memories to look back.I can voice my opinion and my experiences. I started "My Little Bag Of Experience". So at that point of time, I had 4 separate blogs with 3-4 posts in each and with no or very fewer views for each post. 
I saw the earnings on the blogger left side bar and it was lucrative. Without any prior knowledge, I clicked on the link and applied for Google Ad-Sense for a blog with 2 posts. The status went straight into 'pending approval'. That Blog was a year old and thus I was allowed to apply. I started imagining myself earning a side income, once it is approved in two days. I was ignorant(Read it Stupid) of any policies or eligibility criteria for Google Ad-Sense approval. I did not know how the Ad-Sense works. 
In two days, I got an email which says:
"Thank you for your interest in Google AdSense. Unfortunately, after reviewing your application, we're unable to accept you into AdSense at this time. We did not approve your application for the reasons listed below. 
Insufficient content: To be approved for AdSense and show relevant ads on your site, your pages need to have enough text on them for our specialists to review and for our crawler to be able to determine what your pages are about.... "
My first reaction was "Okay, I need a few more posts!" So, I thought of merging all my blogs into one and I did that labeling each post for different categories.I decided, once I have 50 posts, I would re-apply. I googled "how to get Adsense approved". Well, the search results quashed my hope. I realized, it is impossible to get it approved for my journal. I did a few small changes in the look-n-feel of my personal blog and continued writing. On reaching 50 posts, I reapplied. This time, I was not hopeful. In 2 days, I got the reply.

Now, am I an expert on Ad-Sense after my single account got approved? NO, Off course not! I am here to share what I learned and to answer the questions that I asked. If you are thinking of starting a new blog and looking for answers to your naive queries, you are at the right place. 

Does Google Ad-Sense gets approved for a Personal Blog?

Yes, it may get approved, even for a personal blog.

Do I need to buy a custom Domain?

Not necessarily. Your blogger account can also get approved.

Is there any specific number of Posts required to get an approval?

I did not get that number in any policies or terms and conditions. But, in my case, it got rejected in 2 posts and approved in 50 posts. May be somewhere around 25 posts, it could have got approval. I should have tried.

Does Blog Traffic play an important role in getting Adsense Approved?

I don't think so. I am not yet aware of the tricks to increase blog traffic. I am still working on that. My blog traffic is minimal.

Is Google Adsense worth a try?

Being realistic, I no more consider Adsense as my alternate income. Adsense pays you if someone is clicking an Ad on your page. Well, nowadays, many people are using the browser options to stop appearing ads on their page. Even if Ads are there, who are going to click on those? Even I hardly do it!And then comes the CPC(Cost Per Click). It depends on the Advertisers who are bidding on keywords. What are the conditions and factors?Well, that's another story, I yet to learn.

To me, Google Ad Sense is an approval. I am here to write what I feel. I am learning daily and I am trying to share what I know. Adsense Guidelines is here if you are looking for help.

      "Start Writing, no matter what. The water does not flow until the faucet is turned on"

Read more »

2017 Summer Activities For Kids in Bay Area - Part II

Say Cheers To Sun, Sand, Sea, and Shells!

This Summer we bought a tent, some beach chairs, a beach mat and loads of sunscreen. Every weekend, we explored some new places with my kid and my mom n dad. Sea and Beaches were our most-loved pick.We just left home and then decided where to head to. If I ask my toddler what she wants to do on a weekend, she replies immediately 'SEAAAAAA'! However, we enjoyed a few other places and experiences this summer and you can check in detail here.
We stay at Sunnyvale and visited lots of beaches near by. Santa Cruz, Monterey, Half Moon Bay are gorgeous but crowded and not for every weekend. We were looking for secluded family beaches where we could walk bare foot, soak in cool water and build a sand castle with my daughter. My view is entirely based on the experience we had on that day. Climatic conditions, my daughter's crankiness, traffic together contributed to this decision. Here I am choosing not-so-popular beaches and a few of my personal favorites.
Sunset State Beach, Watsonville: 
We went to this beach after some strawberry picking and just for a few hours. There is a camping site which we didn't explore. There is a paid parking and it was full. As soon as our car reached the gate, another car left, leaving us a golden spot.
The Beach is a wide expanse of soft sand. The water was not so cold. It was not crowded and we got sand dollars. I did not even know about it and was so surprised after collecting a few of them. Lots of birds and it was pretty amazing for a stroll. We could not stay for the Sunset. But we came back satisfied and peaceful.

Pomponio State Beach:

It is located 12 miles south of Half Moon Bay. This Beach is clean, spectacular and a little underrated. There is a perfect mix of tall cliffs and beautiful waves. The parking space was small and paid.We went there in the afternoon on a weekend and there was a lot of space. It was breezy and chilly, at first. But then we got used to it. This place is to sit back and relax and sink in the views and listening to the ripples sound and we just loved it.


San Carlos Beach: 
Small Protected and not so clean. Still, we loved it! Metered parking was available. There was a large green lawn where you can sit and enjoy the view from a distance. But we love water, we love sand. The water was not so cold and no big waves. There was a lot of kelp which makes the water look green. My daughter just enjoyed running up and down to the water. This place is perfect for marine adventurers. Though none of us are divers, we had seen a lot of scuba divers with their diving gears and equipment plunging into the sea. This Beach is located very close to the city and many food places.

Why do I love the Sea? I think, It is because, SEA has something to offer for everyone. It can bring out the child in you. Blue Sky, Blue Sea, the Breeze, the Waves, the Sand in toes- it's a whole package! I love to hear my daughter giggling when the waves touch her toes. I love that she loves the SEA.

Read more »

Lemon-Honey Water - A Magic Potion

"When life gives you a lemon, make a lemonade".

I say, instead of lemonade, make some warm lemon water and gulp it down with some honey. Hey, it's tasty and it has got so many health benefits!

When I was a kid, my mom used to hand me a glass of warm lemon honey water, after I woke up in the morning. That time, I was very prone to catch a cold and it is loaded with Vitamin C.Also, I was not allowed to have Tea/Coffee. So, lemon-honey water was really a great substitute.

The main three ingredients of lemon-honey- water is Lemon, Honey, and some warm Water. Each of the components proves to be super-food for your body. But what the combo does is magical. The medical terms do not make much sense to me. So, I interpreted the benefits, my way.

Boost Immunity and Make Mamma Happy :

I used to drink lemon water during my childhood since my mom wanted to boost my immunity. Lemons are high in vitamin C, which is great for fighting colds. Honey reduces a cough and throat irritation. As per research, “Lemons are very high in bioflavonoids that destroy harmful free radicals that damage blood vessels and cause inflammation.” Well, that's some heavy stuff! But, I liked the taste and my mom was happy to offer something healthy. So it was a win-win for both of us. And now, when my Toddler coughs, a honey stick or a honey pop or just a spoon of honey soothes her throat and gives her some relief at night.

Lose Fat and Lose Your Age:

I think a lean person looks much younger than an overweight person of same age. What do you think? There were plenty of reasons for me to lose those extra pounds. To look fit and young is definitely the primary one. You can check my stories of losing those extra pounds. I included Lemon-Honey water in my diet. It is believed that if you drink some warm water in the morning, it will kick your metabolic rate that means the rate at which your body is burning calories. 'Burning Calories' always rings a bell and if it happens by sipping something tasty, I am IN. Lemons even help to decrease cholesterol and triglycerides.

Radiant Skin and Glowing You:

It is believed that lemon helps in producing Collagen and Collagen is responsible for a glowing healthy skin. Honey is a natural moisturizer. So, the lemon-honey duo is pretty amazing for skin.

Assist Digestion and Energized You:

Warm water, in the early morning, is beneficial to flush out the toxins from your body. Lemon adds a refreshing flavor and tangy taste. Honey makes it yummy,  adding some more benefits. The warm water serves to stimulate the gastrointestinal tract and peristalsis—the waves of muscle contractions within the intestinal walls that keep things moving. Lemons and limes are also high in minerals and vitamins and help loosen toxins, in the digestive tract. Overall, the digestive qualities of lemon juice help to relieve symptoms of indigestion, such as heartburn, belching and bloating.

It is believed that there are many other rewarding benefits that a glass of warm lemon honey water can do! It cleanses your liver, balances pH, reduces stress and so on. But, I just love the refreshing smell of lemon. It can be your first step to a healthy lifestyle. It tastes good. It smells good and it does good to your body. After extracting the juice from the lemon, I just scrub the lemon zest and the skin for a clear skin.

So, A lemon a day keeps all the toxins away!

Read more »

2017 Summer Activities For Kids in Bay Area - Part I

This Summer, we made some of our best memories. My parents were here. My two and a half-year-old daughter spent a lot of quality time with her grand parents, both indoors and outdoors. For her, Monday-Friday is school days and Saturday-Sunday is Ta Ta-Bye-Bye Days.  Yes, every Saturday and Sunday we are out, exploring the trails, beaches, hills or some architecture.
Here, I am quickly highlighting the places and experiences that we loved and felt worth sharing.

Cherry Picking AT Brentwood:
Who doesn't love a red sweet juicy cherry?
And what makes it alluring is the idea-'Pick on your own'.

There are a couple of orchards at Brentwood which is open during the season for Cherry Picking. We picked Bloomfield Cherries. They are closed for 2017 and will re-open in 2018.  Before planning a trip, check out their Facebook Page here or their website.
We went on a Saturday. It was crowded. Parking was a bit problem. But there was some friendly staff who were managing the Traffic.
We were given a few buckets to fill, at the entrance. It was really helpful since my daughter didn't want to share her bucket with anyone.
The orchard was huge! There was Excitement all around. We could hear some giggles and shrieks of the little explorers. There were an abundance of cherries and at lower heights. There were ladders to reach the top one. We tasted a few cherries and soon mastered the art of picking the most delicious one.
My child and my mom were equally thrilled. I was busy running after my little one who was galloping from trees to trees. In between, I caught a sight of my mom jumping and trying to climb a tree to reach the top one. So, overall, it was fun and exhausting. So, we sat in the shades for some time.
Together we picked around 6 pounds of cherries and headed towards the checkout counter. The price was 3.50/lb which could have been a little less. But considering that we had already eaten a lot of cherries at the farm while picking, it was a good deal! We went home tired, but happy. It was a crazy, but 'Cherry-On-Top' kind of day and will surely go back next season.

My Tip: 

• Sunscreen is a Must
• Lots of Water
• Some snacks, if you are visiting with kids 
• You may carry a Mat/Blanket if you want to rest in the shades

Japanese Tea Garden:

If you are a true admirer of 'Green', this is the right place for you! It is amazing to find out so many shades of greens together. Japanese Tea Garden is located in San Francisco Golden Gate Park. Plants, pond, fishes, cute bridge, Japanese architecture, hot steaming tea - this place has it all.
We visited this place on a Saturday. We reached past 12 noon. Traffic was bad and we had to spend some time to locate a parking spot. This place is a gem for those interested in nature photography. Even, a mobile phone click would be gorgeous. We walked around for some time, watched the fishes swimming in the pond, took a few clicks and we were contented. The garden has an entry fee which is a little expensive, considering the size of the garden. Beautifully landscaped, calm n peaceful, well maintained, this horticulture gem is surely worth a visit.  You can check out the details here if you are planning a visit.

My Tip:

• Reach a bit early to avoid the traffic and parking issues
• There is a cafe for Tea and Coffee inside the Japanese Tea Garen and a few Food Trucks were around in the Golden Gate Park
• Entrance fee is worth investing if you are planning to spend some time inside.

Golden Gate Park:
We didn't want to spoil the serenity of the Japanese Tea Garden for long, by our excited and enthusiastic toddler.That's why we headed to explore the other areas of the Golden Gate Park. It is HUGE and we were able to cover only a fraction of it. But what we liked most is the Rose Garden, a beautiful collection of all possible shades of roses.
It is located on the back side of De Young Museum and the best part is it's Free. We took some snaps and then we just sat there intoxicated by their fragrance. Most of the flowers have a plaque indicating the scientific name and type. This place is magical. 
We had some ice cream and warm Churros. There is a play area with some slides and a few structures, near by, where my daughter had her share of fun. There is a trail surrounded by trees and we played some hide-n-seek. We spent around 5-6 hours. At the end of that sunny day, we were tired and my daughter was sleepy. We carried a picnic basket and didn't try the food there. But there were a couple of options near the museum. This place has a lot more to offer. Plan ahead since it is very difficult to cover all the attractions on a single trip. Check the details here.

My Tip:

• We didn't see any Diaper changing  station in the restroom, which was a little inconvenient
• This park is absolutely Stroller-Friendly. 
• We didn't see any water fountains. So, it is advisable to carry your own water.

                                                                                                         Continued to Sea and Sand

Read more »

Play a Game and Teach Colors to Kids

Me: 'Color Color'
My Daughter: 'What Color?'
Me: 'I want Pink!'
A pink cereal goes into her mouth. 

We started playing this color game when my daughter was a year old. I didn't know how to teach her colors. But soon it became a hit. We played it anytime, anywhere. Now, she is a PRO. It is difficult to catch a child's attention and then to hold it for some time is an another challenge. So, how to teach an infant something new? Play a GAME! Play it often!

Initially, she didn't pay much attention. But, after repeating the same game with different props, she started participating. She got the understanding that those are called colors and each one of them has got a name. However, it took a few more months to match the right color with the right name!
We played the 'Color Color' game every time we were surrounded by colors -  While picking her dress or the spoon or while playing in a garden with different color flowers or during driving when I ask for some color and she looks outside and keeps searching for it unless she finds it. It is FUN!

I heard many parents using a flash card to teach colors. It didn't help me at that age. But later, when she was a little older and knew all the colors, we played flashcards. We played color sorting game with multi color straws. I just gave her a colorful pack of straws and asked her help to sort it out in bundles of the same color. She tried, she failed, she did it. Best part, it kept her occupied for some time.

Now, my girl is 2 years and 10 months and will be celebrating her 3rd Birthday in two months.  She has already asked for a pink cake, purple balloons, and a red dress. A few days back, we were shopping for a swim suit for her. My husband picked one and asked  her  "You like this blue one?" She stood there with her hands on her waist and said: " No daddy, that's not blue, that is TURQUOISE". My husband was speechless, amazed and proud. And I just smiled.

Read more »

My 5-Steps Program To Reduce Those Extra Pounds

I remember I had a weighing scale. I searched for it everywhere and finally got it hidden behind some boxes in the closet. I put it on the bathroom floor and stepped on it. It showed 149.6 pounds. I  got my phone and quickly converted it to kilograms and then I just screamed. I was devastated. It was a month of January, just after the holiday season. I am only 5 feet in height and I calculated my BMI which was way high than expected. In short, I was OVERWEIGHT! Check yours here.

I was not sure where to start from. To clear my head, I just went out for a walk. I don't enjoy working out in a gym. I can't diet. So, what options do I have? The only thing I like is to walk in the open air and I decided that is what I will start with. Today, after 7 months, I am 130.8 pounds, still overweight as per the calculation. But, I know, I can bring it down within a few more months because I have learned the key to weight loss.
If you are in a similar situation and looking for some possible solutions, you are at the right place. Here are my ways of losing those extra pounds:

1. Have some devastating and heart breaking experience: 
It is YOU who have to be willing to take a step forward to weight loss. If you want to do it, you can do it.  For that, you need some humiliating experiences which will inspire you to take the step. If you are happy with yourself and want to do it since your doctor asked, you are not ready yet. So, the first step to weight loss is 'Be Ready'.  Check mine in the below-related posts:
1. Overweight - Who me?
2. When are you due?

2. Get a Weighing Scale:
Weigh yourself and set a possible target. Yes, that's what I did! I decided to lose 10 pounds. So, set a target and start working on it.

3. Cut on SUGAR: 
For me, the most challenging part was to cut on sugar.However, it was the most rewarding one too! I love desserts. I love anything which is sweet. It was really difficult to watch those box of muffin and ignore it. But I did! I limited my sugar intake to 2 teaspoons daily with coffee. Within 3 days, my scale was showing 2 pounds less! It was an exhilarating feeling. Those 3 days, my husband and my daughter had to bear with my terrible mood. But, when I saw my sacrifice really got paid, it raised my hope and determination. But, I didn't see any visible change in myself. And after the initial 3 pounds, my weight got stuck there and  I had to take the next step.

4. Get a Fitness Tracker:
I have a whatsup group of my college friends. A friend brought up if anyone using a Fitbit. I googled to check what it is. When I replied that I had to google it, everyone laughed and thought it was my excellent sense of humor. I didn't bother to rectify them that it was my terrible sense of ignorance. But when I googled it, I liked it. I bought 2 of them on Valentine's Day. One for my husband and one for myself. Since then, I only take it off for charging. I just love it! I am not a person who can spend hours in a gym. But I can walk and I love it. I like to walk on roads, at the park, on the hiking trails, in open air. Oxygen makes me alive and fresh. I think everyone has their own share of likes and dislikes. Find out yours and stick to it! So walking daily and the cut on sugar helped me to reduce a few more pounds. I started fitting into my old clothes and that is pure happiness. But then the weight loss process was slow. So, what next?

5. Reduce Solids and Increase Liquid Intake:
I decided to try on some healthy eating habits. I tried not to make it a punishing experience, but a rewarding one. I started having a glass of warm lemon-honey water in the morning. I take my breakfast, usually 2 slices of wheat bread and egg and coffee.  I started drinking lots of water and even milk when I feel hungry, in-between meals. Initially, I didn't curb any meals. But, I took charge of the in-between-meals snacking. I replaced my sugar cookies with fruits and milk. It worked magic.

These 5 steps may not turn you into a slim trim model, but you will surely see a different YOU. This is just the beginning. Still, I surrender to the cravings for those Oreos, muffins, chocolate and ice cream, but not daily. I have reduced almost 20 pounds in these 7-8 months, yet there is a long way to go.  I will share anything interesting that works for me. It may work for you too!
Let's join hands to "wake up with determination and go to bed with satisfaction."

Read more »

My Reason To Lose Those Extra Pounds - "Overweight - Who Me?"

A free health check-up camp was organized at my work.
Stand in a queue; 
Get a blood test done; 
Get your blood pressure checked; 
Get a Report Card; 
Get it analyzed.
Sounds simple, right? Also, it was free! So, I went there and waited for my turn. 

My blood pressure looked great! Then, the smiling lady who was taking the test, pricked my finger with my permission. Took the blood on a slide and put it in that device for test results. She frowned, looked back at me and smiled nervously. She pressed a few buttons. Uh ho, my heart sank. That Bad huh? The lady told apologetically that there was some error in reading and the results were void. She had to prick me again. Not a good sign, however, I agreed. She took the test again and the results came. She took my weight and filled the report card with all the details and I was sent to the next queue to check the results.

You don't have to be a specialist to comprehend that test results. It was just an expected range and where you stand. What caught my attention first was it was ticked at "overweight". What? That's rude!

My turn came. The lady took the report from me and without even looking at it, blurted out ''It seems like You don't exercise?, So, First of all, You need to add some exercise to your daily schedule." A forced smile pursed my lip and I nodded. I was thinking that marking the "Overweight" check box was rude! She continued talking about the changes required in my lifestyle. But all I did was sitting there all hurt and angry. The only question that keeps on poking my mind  - ' Overweight Me! How did that happen?'

Series of images flashed in front of my eyes. That mandatory dessert that I eat daily after each meal; the butter loaded leftovers that I eat after my daughter's meal; the chocolate bars that I finish in excuse to cure my mood; the sodas that I drank instead of water ;I realized EVERYTHING I did was wrong and it is only me who did that to myself! It was an awakening moment for me and another reason to stop and think what I have done!

Read more »

My Reason To Lose Those Extra Pounds - When are you due?

"When are you due?"
"Excuse Me?"
"You are pregnant, right?"
"Ummm No, I have a 2-year-old girl and not planning anything right now."
Some embarrassing smiles and the conversation ended right there.


That was a scene from my life, a few months back. I was new at my work. I was in the cafeteria billing queue, holding a  plate full of spaghetti and fried chicken and fruits. Another girl, who was on the same project, was standing right before me with a salad bowl. After the conversation, which ended abruptly, she paid for her salad as fast as she could and ran away from there. I was left alone with a heavy-heart wondering what just happened!

I came back to my desk and googled 'how to react if someone has mistaken by your belly size, that you are pregnant?' I got lots of results. That was a little comforting to know that I am not alone. I read that we should love our body the way it looks. My body did an incredible job when I gave birth to my baby. I should pat myself for that and believe in myself. After reading a few article, I was again feeling all better and proud. I finished my meal with a smile and was happy that I ordered those crispy chicken.  

Now, a little bit about myself.  I am Indian, Bengali, a Foodie and a Mom. Well, that defines who I am! Being an Indian, I love rice, spices, ghee. Being a Bengali, I love potatoes and lots and lots of sweets. Being a Foodie, I love to add something special to each of my meals. Before each meal, I get a vision what exactly I want to eat. Is that what you called a craving? Then yes, I am a Born Pregnant. Yummy food can make me happy and a salad bowl can turn me all Grumpy. And now comes the best part. Being a Mom, I eat all my kid's leftovers. I don't eat on time and eat whenever I have time. Before my daughter was born, I was told to eat for two. After my daughter was born, I was told to eat more to heal up fast and produce lots and lots of breast milk. Well, I did, I listened to everybody!

The outcome is here,  after 2 years, I couldn't stop eating. I ended up in a queue of voracious eaters and 6-months-pregnant-belly. So, that's me! Did something similar happen to you? Congratulations! You have already moved a step ahead on the way to losing those extra pounds.

Read more »

Lockbox in AR

AutoLockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. A lockbox operation can process millions of transactions a month. AutoLockbox eliminates manual data entry by automatically processing receipts that are sent directly to the bank. 

AutoLockbox is a three step process: 

1. Submit Import: During this step, Lockbox reads and formats the data from your bank file into AutoLockbox tables using an SQL *Loader script.

2. Submit Validation: The validation program checks data in the AutoLockbox tables for compatibility with Receivables. Once validated, the data is transferred into QuickCash tables. At this point, we can optionally query the receipts in the QuickCash window and change how they will be applied before submitting the final step, Post QuickCash. 

3. Submit Post QuickCash: This step applies the receipts and updates your customer's balances. 

These steps can be submitted individually or at the same time from the submit Lockbox Processing window. After we run Post QuickCash, Receivables treats the receipts like any other receipts; 

Lockbox Process Flow

Lockbox Interface Table:

When you run the Import step of AutoLockbox, Receivables stores receipt data from the bank file in the Lockbox Interface table AR_PAYMENTS_INTERFACE. 

Read more »

Oracle Autoinvoice Interface Tables

AR Invoice Interface Tables

• RA_INTERFACE_LINES_ALL

- This table stores transaction header and line information.

- AutoInvoice uses Transaction Flexfields to uniquely identify each transaction that we import  into Receivables.

- AutoInvoice always uses the Line Transaction Flexfield structure for both the Link-to and Reference information when importing invoices

• RA_INTERFACE_DISTRIBUTIONS_ALL

-  If we do not use AutoAccounting, we must enter accounting distributions for the transactions.

- If the accounting distributions are for transactions that use accounting rules, we must enter the percentages, but not the amounts.

- If the accounting distributions are for transactions that do not use accounting rules, we can enter either the percentages or amounts, depending on the value we entered for the batch source.

- Distributions in this table are linked to the appropriate transaction lines in the ra_interface_lines via the transaction flexfield. Though the distribution for 'REC' account class is at the invoice level, it may be linked to any transaction line of the invoice in ra_interface_lines. AutoInvoice will then correctly transfer all distributions to RA_CUST_TRX_LINE_GL_DIST_ALL.

• RA_INTERFACE_ERRORS_ALL

- This table stores information about interface lines that failed validation and were not imported into Receivables tables.

- Receivables uses the information in this table to generate the AutoInvoice Validation Report - - AutoInvoice identifies all errors for each transaction line, thus reducing multiple validation and correction cycles. When we resubmit AutoInvoice, the program deletes the errors for each line selected for processing. When all of the records have been successfully processed, AutoInvoice purges any remaining data in this table.

- Use the Interface Exceptions window to view all of the errors in

 RA_INTERFACE_ERRORS_ALL.

• RA_INTERFACE_SALESCREDITS_ALL

- This table stores sales credit information for the transactions.

- This table must be populated if the AutoAccounting is set up to derive segment values based on the salesrep. If AutoAccounting does not depend on salesrep, then the value we enter in the Required Salesrep field of the System Options window and Allow Sales Credits field in the Transaction Sources window will determine whether we must enter sales credit information.

Read more »

Sequence Of Firing Triggers In Oracle Forms

Navigational events occur at different levels of the Form Builder object hierarchy (Form, Block, Record, Item). Navigational triggers fire in response to some navigational events in the below order:

- Logon Triggers are fired first in below sequence:

1.PRE-LOGON
2.ON-LOGON
3.POST-LOGON

- After that, Pre Triggers are fired

1. PRE-FORM

2. PRE-BLOCK

3. PRE-TEXT-ITEM

- After that, WHEN-NEW Triggers are fired

1. WHEN-NEW-FORM-INSTANCE

2. WHEN-NEW-BLOCK-INSTANCE

3. WHEN-NEW-RECORD-INSTANCE

4. WHEN-NEW-ITEM-INSTANCE

- After this focus is on the first item of the Block. If we type some data and press the tab key following trigger will fire in sequence

1.KEY-NEXT-ITEM (This trigger is present on the item level).

2.POST-CHANGE (This trigger is present on the item level).

3.WHEN-VALIDATE-ITEM (This trigger is present on the item level).

4.POST-TEXT-ITEM (This trigger is present on the item level).

5.WHEN-NEW-ITEM-INSTANCE (Block Level Trigger).

- After That, POST TRIGGERS are fired

1. POST-BLOCK
2. POST-FORM

Read more »

Applying for an L2 EAD(Employment Authorization Document) on your own

Form I-765

I was talking to a friend recently and she is also working in US with L2 EAD. She had applied for EAD for the first time with the help of the lawyers at her husband's company. Well, it was sponsored by the company itself at that time. She got an EAD in FEB, 2015 for 2 years and she had to apply for renewal a few months back. During the conversation, it came up that she had to pay a $1000 for the renewal. I was surprised because I remember to pay around $400 for the same and then we realized that she had paid the rest for the lawyers' fees. That's why I thought of writing my experience of getting an EAD without paying anything extra.

This Link https://www.uscis.gov/i-765 has all the information needed for applying an EAD.  I just printed the I-765 Form and the checklist and took a print of all the required documents and wrote a cheque and sent across to the address and got my EAD in 3 months. So, I had applied for L2 EAD for the first time on August, 2015. I got my EAD copy on November, 2015. My current EAD is valid till Oct, 2017 and I applied for renewal recently. 

So, below is the step by step directions to apply for a L2 EAD or renewal of L2 EAD.

1. Download the form I-765 from Form I-765 (PDF, 289 KB). Take a print.

2. Download the instruction sheet to fill the I-765 form from Instructions for Form I-765 (PDF, 332 KB)

3.  Download the form G-1145 to get an email notification or a notification on your mobile number once received.  Form G-1145, E-Notification of Application/Petition Acceptance (PDF, 229 KB)

4. Fill in the I-765 form.
    For fresh application:
    Tick off ' Permission to accept employment' at 'I am applying for:' section
    Put I-94 Number at 10 (Alien Registration Number)
 
   For renewal application:
   Tick off ' Renewal of my Permission to accept employment' at 'I am applying for:' section
   Put A- Number at 10 (Alien Registration Number)
The Eligibility Criteria, for L2 EAD is a(18)

5. Check for filing fees at https://www.uscis.gov/forms/our-fees and write a cheque for the same amount. As of today's date, the fee is $410.

6. Get ready with the below supporting documents:

• Filled Application form I-765
• Filing Fee Cheque for $410
• A copy of I-94 (front and back)
• A copy of last EAD copy (front and back) for renewal
• 2 recent color photographs
• L1 Visa copy
• L2  Visa copy
• L1 I-94
• Marriage Certificate Copy

7. Send all the documents to the USCIS lockbox address. Address depends on the category that you have chosen.For category a(18) address is available at : USCIS Phoenix and Dallas Lockbox facilities chart

8. Check the EAD status at https://egov.uscis.gov/casestatus/landing.do

Edit1: Got my renewed EAD copy in exactly 2 months. But since my L2 Visa was valid for 1 year (11 months to be precise), got my EAD for 11 months this time.

Read more »

Kill Session in Oracle

Retrieve session identifiers and session serial number (which uniquely identifies a session's objects):

select sid, serial# from v$session where username = 'USER'

kill the session:

alter system kill session 'sid,serial#'

Disconnect the session:

alter system disconnect session 'sid,serial#' post_transaction;

alter system disconnect session 'sid,serial#' immediate;

Read more »

Collection and Record In Oracle

A collection is an ordered group of elements, all of the same type. 

In a collection, the internal components are always of the same data type, and are called elements. We can access each element by its unique subscript. e.g. Lists and arrays.

A record is a group of elements, which can be of different types. 

In a record, the internal components can be of different data types, and are called fields. We can access each field by its name. A record variable can hold a table row, or some columns from a table row. Each record field corresponds to a table column.

PL/SQL has 3 collection types as below:

• Index-by tables, also known as associative arrays,  are sets of key-value pairs, where each key is unique and is used to locate a corresponding value in the array. The key can be an integer or a string.
•  Nested tables hold an arbitrary number of elements. They use sequential numbers as subscripts. We can define equivalent SQL types, allowing nested tables to be stored in database tables and manipulated through SQL.
• Varrays (short for variable-size arrays) hold a fixed number of elements (although we can change the number of elements at runtime). They use sequential numbers as subscripts. We can define equivalent SQL types, allowing varrays to be stored in database tables. They can be stored and retrieved through SQL, but with less flexibility than nested tables.

Collection Type	Number of Elements	Subscript Type	Dense or Sparse	Where Created
Associative array (or index-by table)	Unbounded	String or integer	Either	Only in PL/SQL block
Nested table	Unbounded	Integer	Starts dense, can become sparse	Either in PL/SQL block or at schema level
Variable-size array (varray)	Bounded	Integer	Always dense	Either in PL/SQL block or at schema level

Read more »