Friday, June 14, 2013

Tennis Elbow


The following racquet specifications can put a racquet in the DANGER ZONE for contributing to TE. Let us check the specifications of your racquet (or check for yourself) to see if it is a racquet that falls in the DANGER ZONE.

1. Weight - Racquets less than 11oz. (Healthwise the ideal weight would be in the 12oz + range)
2. Balance - Racquets that are weighted head heavy are more prone to causing TE
3. Stiffness - Racquets with a stiffness/flex rating of 69 or higher can contribute to TE
4. Length - Racquets longer than 27" can also contribute to TE


Monday, June 10, 2013

Query for TXN TYPE ACTION & SOURCE

 SELECT COUNT(*)
 ,      mmtt.organization_id
 ,      mtt.transaction_type_name
 ,      meaning action
 ,      transaction_source_type_name
 ,      mmtt.transaction_type_id
 ,      mmtt.transaction_source_type_id
 ,      mmtt.transaction_action_id
 FROM   mtl_material_transactions_temp mmtt
 ,      mtl_transaction_types mtt
 ,      fnd_lookup_values_vl lkp
 ,      mtl_txn_source_types src
 WHERE  organization_id IN (2448,2434,2435)
 AND    mtt.transaction_type_id = mmtt.transaction_type_id
 AND    mmtt.transaction_source_type_id = src.transaction_source_type_id
 AND    lkp.lookup_type = 'MTL_TRANSACTION_ACTION'
 AND    lkp.lookup_code = TO_CHAR( mmtt.transaction_action_id )
 GROUP  BY
        mmtt.organization_id
 ,      mmtt.transaction_type_id
 ,      mmtt.transaction_source_type_id
 ,      mmtt.transaction_action_id
 ,      mtt.transaction_type_name
 ,      meaning
 ,      transaction_source_type_name

How to Enable Personalization link for OAF Pages

Profile Name
Value
FND: Personalization Region Link Enabled
Yes
Personalize Self-Service Defn
Yes
Disable Self-Service Personal
No

Friday, June 7, 2013

Material Workbench : Cost Group Transfer

Source

The "Cost Group Transfer" option is greyed out when trying to access it from the Tools Menu on Material workbench . How does one enable it ?




Check the Responsibility setup to see if the function "Material Workbench Cost Group Update" was excluded 
a. Login as System Administrator
b. Navigate : Security > Responsibility
c. Query up Responsibility
d. Check to see if the function "Material Workbench Cost Group Update" is present in the Exclusion list
e. If yes, Remove it and save the changes and the Cost group transfer option will be enabled in the Tools menu in Material workbench form
Or
Check the menu attached with the custom responsibility. See if the function Material Workbench Cost Group Update has "Grant" Option Checked

a. Login as System Administrator
b. Navigate : Applications > Menu
c. Query up menu attached with the Responsibility
d. The scroll down to see if the function "Material Workbench Cost Group Update" has the "Grant" option checked.
e.  If its unchecked, check the Grant option and the Cost group transfer option will be enabled in the Tools menu in Material workbench form

Thursday, June 6, 2013

Move Order Issue Transaction for LPN

Move order has a config item of mixed transaction type.

.> Master is Move Order Transfer while one or more Child lines are Move Order Issue

.> Master is Move Order Issue while one or more Child lines are Move Order Transfer


After the Pick Load is complete.

.> Complete the issue lines using INV_PICK_WAVE_PICK_CONFIRM.PICK_CONFIRM.

Pass only the mmtt records as parameter and not the move order records

.> Now the Config LPN will have only the move order transfer items, while the
  move order issue items would have been issued out.
 
.> Since the integrity of the Config LPN has been destroyed, we will have to
   unpack the items from the config LPNS
 
.> Insert into the MTI with the transaction type 88 Container UnPack
   If there are any serials or lots associated with the config LPN
   populate the MTSI or MTLI
 
.> After successfully completing the unpack, we need to clear the task of all
   the references of the config LPN
   update mmtt set lpn_id = null, allocated_lpn_id = null        

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