Monday, May 6, 2013

PO Matching

For Matching
--------------------

  fnd_global.apps_initialize(user_id      => 3532,
                             resp_id      => 53496,
                             resp_appl_id => 200);
  mo_global.set_policy_context('S', 215);
  AP_RECT_MATCH_PKG.AP_AMT_RECPT_MATCH  


For Validating
------------------------

AP_APPROVAL_MATCHED_PKG.Exec_Matched_Variance_Checks


Contains queries for validating matched invoices


--------------------------------------------------------------
       IF (p_po_release_id IS NULL)   THEN

          SELECT nvl(sum(nvl(aid.amount, 0)), 0)
          INTO   l_matched_amount
          FROM   ap_invoice_distributions aid,
                 po_distributions pd
          WHERE  pd.po_distribution_id = aid.po_distribution_id
          AND    pd.po_header_id   = p_po_header_id
          AND    aid.invoice_id    = p_invoice_id
          AND    aid.line_type_lookup_code  IN ('ITEM','PREPAY');

       ELSE

          SELECT nvl(sum(nvl(aid.amount, 0)), 0)
          INTO   l_matched_amount
          FROM   ap_invoice_distributions aid,
                 po_distributions pd
          WHERE  pd.po_distribution_id = aid.po_distribution_id
          AND    aid.invoice_id    = p_invoice_id
          AND    pd.po_release_id  = p_po_release_id
          AND    aid.line_type_lookup_code IN  ('ITEM','PREPAY');

       END IF;

Wednesday, March 13, 2013

Buying Land in GOA



a) If you intend to buy land;
  Check ownership documents (I & XIV form, registered sale Deed, partition deed of inheritance etc.
  Check/ask of nil encumbrance certificate issued within /less than 6 months.
  v Check land use of the property as per Regional Plan or Outline Development Plan as the case may be.
OR
 Ask for land use/zone certificate from Town and Country Planning Department , Government of Goa/Planning and Development authority of respective area in which said property is located.
v Check whether the land has tenants or Mundcars. 
F Tenanted lands cant be used/developed for non Agricultural uses, as per the land use Act,1991.
v Check for any encroachments on the land.
v Check for Forest Conservation Act’s application to said land .
v Check for whether the land is classified as “Rice” in property document such as I & XIV form. (Paddy fields are generally not permitted for development.
(b) If you are buying sub divided plots;
v Check for approved sub division plan by Competent Authorities of Goa such as PDA, Town and Country Planning Department, Village Panchayat.
v Check for Final NOC issued by Competent Authority.
F (There is a practice of issuing provisional NOC for sub division to allow the developer to carry out works like roads, gutter, water lines and electric lines and also obtain Conversion Sanad from Dy.Collector etc., and then submit for Final NOC for division. Finally approved plots are ready for construction of houses/Bungalows).
 Buy only Finally approved plots
Check for NOC for Sale plots to be procured by the seller from the PDAs. This is applicable to PDA areas only section 49 (6) of TCP Act which makes it mandatory to produce NOC for sale at the time of Registration of Sale Deeds/documents).
a) Buying flat/House/Bungalows?
v Check for approved plans from Competent Authorities;
Town and country Planning Department, PDAS (If it is located in planning areas of Panaji, Margao, Mapuca, Mormugao and Ponda town areas), Village Panchayats, and Municipal Authorities.
v Check for licence from village Panchayat/Municipal Council of the respective area in which the property is located.
F If it is an old house/bungalow of more than 25 years, the above may not be insisted.
v Insist with the builder to give a set of all land related documents and full set of approved plans.
v At the time of Final possession check for occupancy certificate from Village Panchayat/Municipal Council.
b) Constructing a House/Bungalow/any building
F You need to make an application to local Village Panchayat or Municipal Council depending on location as the case may be. 
The application shall be made in prescribed form (schedule-II). 
The application shall be accompanied by ownership documents such as (i) I & XIV form (ii) Registered Sale deeds (iii) Partition deed (registered). Building plans prepared by a registered Architect or Engineer, RCC drawings, survey plan approved sub division plan ( if the plot is from a sub divided property), Sanad copy. 
F (Some areas/ buildings of historical importance Socio-cultural importance are earmarked as “Conservation area/zones” and Preservation areas”. The details of such zones can be obtained from notified Outline Development Plans of Planning and Development Authorities. As per PDA (Development Plan) Regulations 1989/2000, applications for construction/development in Conservation zone/areas have to be referred to a designated Conservation Committee appointed by the Government by the TCP Department/PDAs after scrutiny of proposed as per regulations applicable to these zones depending on the areas/towns in which they are located.
vd) If the land is located within 500 mts from High Tide Linefrom the sea or 100 mts from the river banks, the area is classified as “Coastal zone”. This coastal zone attracts CRZ regulations.
All approvals for any construction/development has to precede approval from “Goa Coastal Zone Management Authority” located at Saligao plateau, Bardez Taluka, Goa. It is advisable to check and confirm CRZ status of the land before buying any land and if it is a premises offered by any seller, you must check its approval status.
F (Currently there is a ban on any kind of developments in the CRZ areas due to a direction issued by the Hon’ble High Court of Bombay at Panaji. A survey is under way for determining the unauthorized developments in this zone).
e) Conversion Sanad from Dy.Collector/Addl.Collector.
-Application to be made in prescribed form to Dy.Collector or Addl. Collector in triplicate.
-Documents to be enclosed.
Survey Plan.
-I & XIV form or ownership document
-Location and site plan of the area proposed for conversion.
a. F Cutting of any Hilly land or filling of low lying fields is an cognizable offence under Section 17-A of TCP Act. However, you can obtain an NOC before cutting any Hilly land or filling of low lying land from Chief Town Planner.
b. F Developing any sloppy land having slope of more than 25 % is prohibited in Goa.
c. 200 mts from High Tide Line along the coast of Goa is totally prohibited.
d. F Areas along rivers and creeks on both sides of the banks are covered under CRZ regulations up to 100 mts from the river bank or width of the river/ creak, at respective point, which ever is less.
e. F Forest Conservation Act and Tree Act are applicable in Goa. Other than Government forest lands, even privately owned lands with certain density of forest trees are considered as “Private forests” which attracts F.C.A. (please consult Forest department for details).
f. F “Farm house” is permitted in a holding up to a built up area of 5% of the holding is 4000 m2 (This is permitted even in orchard zones and Agricultural zones, except wet paddy fields).
g. F For any further clarification/consultation/advice on any individual case/land/application, you may approach the Senior Town Planner of North Goa and South Goa at the address given below:
(1) Mr.S.T.Puttaraju,
Senior Town Planner,
South Goa District Office,
Ocia Complex, Margao
Phone Nos.
(O) 0832- 2705785,
0832 – 2734089 & Fax.
2) Mr James Mathew,
Senior Town Planner,
North Goa District Office,
Mapuca.
Phone nos.
(O) 0832 – 2262444

Friday, February 22, 2013

financial Planning Blogs

http://bachhat.blogspot.com/2010/11/should-life-insurance-be-taken-from.html

http://www.tflguide.com/2011/03/best-term-insurance-plan-india.html

http://www.onemint.com/2011/03/09/claims-data-for-life-insurers-in-the-december-2010-quarter/

http://freefincal.com/ - good financial calender

www.fundsindia.com - mutual funds 

Stocks
http://kiraninvestsandlearns.wordpress.com/tag/sanjaybakshi/

Rules of Thumb

Source


Saving & Investing rules of thumb

1. What should be my asset allocation or how much equity should I have?
This is the most common rule of thumb which is used in investment world. Rule saysEquity percentage in your portfolio should be equal to 100 minus your age or in other words debt should be equal to your age. For eg if you are 30 you should have 30% of your investments in debt & 70% (100 – your age) in equity. This doesn’t take care of riskappetite, risk tolerance or how far your goals are.
2. How much emergency fund I should have?
Emergency Fund helps people in case of sudden loss of income, medical emergency etc. Thumb rule says one should have emergency fund equal to 3 to 6 months of monthly expenses. You can keep it at 3 month if you are a government servant but in case of private job or profession you should keep it on the higher side of the range. Make sure you don’t use this amount for day to day needs/wants. For retired person emergency fund should be equal to 1 year of expense.

Retirement rules of thumb

3. How much money will I need in retirement or how much corpus I should build?
You should have 20 times your income saved for retirement and plan to replace 80 percent of pre-retirement income. But here retirement means a retirement at age of 60 & life expectancy of 80 – and a conservative lifestyle. But now things have changed & you would have dream/planned lot of things for retirement.
4. How much I need to invest every month to achieve retirement goal?
“Indians are great savers” sorry “Indians were great savers”.  New generation is in some different mood they would like to enjoy the present & have no idea about future. If you have just started to work & would like to have a very simple lifestyle & retirement at age of 60 you can do it with saving (read investing) 10% of your income. If you are planning for an early retirement start with 20% savings. Other rule says if you are in early 30s Save 10% for basics, 15% for comfort, 20% to escape. If you are late by decade add 5% more in each category.

Insurance rules of thumb

5. How much insurance should I have?
Here insurance means insurance. Rule says one should have sum assured of 8-10 times of his yearly income. I think this rule is far from perfect but still can be used as starting point. This does not take care of any of your goals, liabilities & even complete expenses. Some modified version of this rule says that if you are in early 30s insurance should be 12-15 times of your annual income & if you are in 50s take 6-8 times.

Loan/liability/home rules of thumb

6. How big should be my House?
The value of house should be equal to 2-3 times of your family annual income. So if you & your spouse are earning total Rs 20 lakh – you should buy a house in Range of Rs 40-60 Lakh.
7. Maximum EMI that I can have?
Ideally 0 will be the best answer but few of the big assets like home require some loan to buy them. Experts agree that your EMIs should not be more than 36% of Gross Monthly Income at any point of time. It should be even lesser when you are close to your retirement. If you want to talk about home loan EMI, it should not be greater than 28% of your gross income. Now TENURE of loan is missing here – for tenure read No. 6 & 8 rules of thumb.
8. Rules of thumb for buying a car
This is one of the biggest purchases after your home. And this is depreciating asset – today morning you purchase a car for Rs 10 lakh & by the evening it will be worth Rs 8-9 Lakh. After 5 years it will not be even of half value but still you keep buying cars regularly – buy at 10, sell at 4 & loose 6. (repeat the cycle) There are few rules that you can follow:
  • Value of car should not be more than 50% of the annual income of the owner.
  • Purchase a used car or buy a new & use it for 10 years.
  • While buying car with loan stick to 20/4/10 – Minimum 20% down payment, loan tenure not more than 4 years & EMI should not be higher than 10% of your income.

Rate of return Rules of Thumb

9. In how many years my amount will double?
It’s a very simple & most common rule – if you divide 72 by rate of return you will get the number of years in which your money will double. For Eg. If you expect a rate of return of 12% you money will double in 6 years (72/12=6) & what about if rate of return is 8% – 72/8=9 years. This can also be used in reverse order at what rate your money will double in 5 years – 72/5=14.4%
Rules similar to rule of 72:
Rule of 114 & 144
These can help you in how many years your money will be triple (114) or quadruple (144) at some rate of returns.
Rule of 70
You know it or not but inflation is your biggest enemy – rule of 70 will tell you in how many years value of money will be half. You just need to divide 70 with rate of inflation so if rate of inflation is 7% – 70/7=10 years. So in 10 years your Rs 100 note will be worth Rs 50.
10. Rule 10/5/3
This is a US rule of thumb which says in long term you can get 10% return from equity, 5% return from bonds (let’s say FDs) & 3% from the t-bills (liquid funds – these returns are more or less close to the range of inflation). Indian economy is growing at some different pace & even inflation numbers are different. Can we safely say if inflation is 6% (t-bill rates) we can get 8% from the fixed deposits & 12% from the equity or in other words – in long term equities will deliver twice the return of inflation. Try combining Rule of 72 with this rule – you will get some amazing numbers.
Some time Rules of thumb will give you false sense of security or wrong guidance – so take them with pinch of salt.

Monday, February 18, 2013

Workflow Activity Status


http://oracleapps4u.blogspot.in

The combination of order type/line type/item type determines the line workflow.
If you leave Item Type blank, the workflow applies to all item types for the line type (unless they have a specific assignment in this form).
In Process Name, select the workflow that Oracle Order Management should use for the order type/line type/item type combination.
If you do not assign a workflow to a configured item type, the configured item does not use a workflow.
You can perform all standard processing including orders, returns, drop-ship orders, Orders for configured items, and orders for assemble-to-order items using seeded workflows.



Check Order line Workflow Activity Status
  SELECT COUNT (1)
        INTO ln_completed_lines
        FROM wf_item_activity_statuses a,
             wf_process_activities b,
             oe_order_lines_all c
       WHERE a.process_activity = b.instance_id
         AND b.process_item_type = 'OEOL'
         AND b.activity_name = <‘Activity_Name’>
         AND activity_status = 'COMPLETE'
         AND item_key = TO_CHAR (c.line_id)
         AND c.header_id = pin_order_header_id


Submit the OEOH & OEOL (Header & line workflow) from database:
BEGIN
wf_engine.Background (itemtype=>'OEOH', -- ‘OEOL’
                      minthreshold => NULL,
                      maxthreshold => NULL,
                      process_deferred => TRUE,
                      process_timeout=> FALSE,
                      process_stuck => NULL);
END;
When an order header workflow is error out, how to retry the workflow for the order?
Go to workflow administrator, provide the item key (header_id) and submit to retry the WF for the corresponding order.



Friday, February 15, 2013

Wednesday, January 30, 2013

RICE/CEMLI Terminology

Source



RICE/CEMLI Terminology

In my Oracle career I often hear confusion over RICE/CEMLI terminologies, what they stands for ? what is the meaning of...blah blah blah....so with the help of my very good friend Charan, I have decided to write my take on this.

AIM (Applications Implementation Methodology) => During packaged ERP(enterprise resource planning) implementations, Clients often have additional requirements apart from the existing (standard) business process, for which they need to create/change theVanila system (Unchanged ERP Implemented system) processes, and its these changes that come under RICE/RICEW components. AIM is the methodology/standards/published guidelines, which Oracle suggests it's Clients to follow while developing
RICE/RICEW components for their business requirements.

RICE stands for Reports, Interfaces, Conversions, Enhancements / Extensions
-----
 > Sometimes extended to FRICE > F for Forms
                                         -------
                                        OR 
                                        RICEW > W for Workflow.
                                         -------

Forms/Reports/Workflows : Create/Change existing forms/reports/workflows available in  ERP system to  meet the Clients business requirements.

Interfaces : Linking (Programs) between other systems to ERP system in order to synchronize the Data.They can be Manual, Batch or Real-Time. Interfaces can be either outbound or inbound. An outbound interface reads data from Oracle Apps tables and usually creates output files in the third party tool specified format. An inbound interface reads data from flat files (usually) and calls Oracle APIs to upload data into Oracle Apps.

Conversion : It is converting the data structure and data design of legacy system data to satisfy the customer’s business rules before importing it into Oracle .It is like a one time run of an inbound interface except that the amount of data processed during conversion could be potentially huge since all the required data from the legacy system would be transferred to Oracle.

Enhancements/Extensions : Please see below.

>> In R12 RICE components have been extended to CEMLI components.
                                                                             --------

CEMLI Stands for Configurations/Customization, Extension, Modification, Localization, and Integration.


Configurations : Configure the existing, pre-built application features according to your client's requirement.Changing setups and profile values can be the example of configurations.

Customization : Customization means altering/changing the standard objects or creation of custom object to meet client's business need. It may be Extensions or Modifications.

Extensions : Extension means creating custom code from scratch, existing objects (views, packages and java classes etc) can be used. It is having different behaviour from seeded one.

Modifications : Modifications is enhancing/changing the existing code to meet the client's requirements. It is the modification of seeded behaviour.

Localization :  It is to define the different legislative support provided by oracle Applications based on country/region/language requirements.

Integration : It can be Data Integration or Application Integration, options for these two are Open Interface tables, APIs, EAI(Enterprise Application Integration Tools), BPEL, AQ, EDI etc.

             >> Apart from these there is one more term and that is Personalization.

Personalization : Tailoring the layout or visibility of page content to meet client requirements is Personalization. Changing the user interface (UI) look-and-feel, making any field visible/enabled/disabled/mandatory/non mandatory comes under Personalization.