Oracle Apps Different Types of Purchase Order

A Standard Purchase Order is one time purchasing to buy goods or services.You can create PO when you know the Item, Price, Delivery schedule and Payment terms

A Blanket Purchase Agreement it’s a long time agreement where you don’t know about Quantity, Price and required Delivery schedule. The Quantity and Price fields will be disabled when you make Blanket Purchase Agreement. You have to enter a Price. The required Quantity, Delivery Schedule and final Price will be informed to the Supplier by creating Blanket Releases against the Blanket Purchase Agreement.

A Planned Purchase Order it’s a long time agreement where you are not sure about the required delivery schedules. You know the details like Item, Price, Delivery Schedule and Payment Terms. In the Planned purchase order you have to enter a Need-By date, but this date that you enter will be treated only as a tentative date. The exact date on which the shipments are to be delivered is informed to the Supplier by creating Schedule Releases against the Planned purchase order.

A  Contract Purchase Agreement is document which gives standard term and conditions created. You do not know even the item that is to be purchased. The only information that you provide in a Contract Purchase Agreement is Supplier, Supplier Site, Payment Terms and Agreement Control details. Standard Purchase Orders are created by referring to the Contract Purchase Agreement when something is to be purchased against this Contract Purchase Agreement.

Oracle Apps How to Find the Concurrent Request

Hi Folks

Below is the query to find out the Concurrent Name.

select a.user_concurrent_queue_name

from fnd_concurrent_queues_vl a,

FND_CONCURRENT_QUEUE_CONTENT b,

fnd_concurrent_programs_vl c

where a.concurrent_queue_id=b.concurrent_queue_id

and b.type_id = c.concurrent_program_id

and c.user_concurrent_program_name=:RequestName

To get the PR Action History Details

Hi Floks

How to get PR action history from the back-end?

Below is the query.

select hr.name ORG_NAME,prh.segment1 Requisition_Number,prh.AUTHORIZATION_STATUS,pah.LAST_UPDATE_DATE,pah.CREATION_DATE,pah.OBJECT_ID,

       NVL2(pah.ACTION_CODE,'COMPLETE','PENDING')Action_Status ,pah.ACTION_CODE,papf.full_name,pah.ACTION_DATE,pah.NOTE

from po_requisition_headers_all prh,po_action_history pah, per_all_people_f papf,hr_all_organization_units hr

where papf.person_id = pah.employee_id 

and pah.object_id = prh.REQUISITION_HEADER_ID

and prh.org_id = hr.organization_id

and prh.AUTHORIZATION_STATUS = 'IN PROCESS'

and prh.segment1 = :'PR_Number'

order by pah.LAST_UPDATE_DATE desc

Oracle Apps - How do get Requisition details based on PO Number

HI Folks

Below is the query to get Requisition details based on PO Number

select prha.segment1 Requisition_Number,poh.*

from po_requisition_headers_all prha,

     po_requisition_lines_all prla,

     po_req_distributions_all prda,

     po_distributions_all pda,

     PO_HEADERS_ALL poh

where poh.po_header_id =pda.po_header_id

and pda.req_distribution_id = prda.distribution_id

and prda.requisition_line_id = prla.requisition_line_id

and prla.requisition_header_id = prha.requisition_header_id

and poh.segment1 = :PO_Number

Check User's Profile Value

HI Folks,

To check user profile value's through query.

 SELECT   p.user_profile_option_name, '3 - User', u.user_name, v.level_value,

         v.profile_option_value

    FROM fnd_profile_option_values v, fnd_profile_options_vl p, fnd_user u

   WHERE v.profile_option_id = p.profile_option_id

     AND (v.level_id = 10004 AND u.user_id = v.level_value)

     AND u.user_name = :'User_ Name'

--AND P.USER_PROFILE_OPTION_NAME LIKE '%FND: View Object Max Fetch Size%'

ORDER BY 1, 2, 3

Oracle Apps Delete Lock from Serial Number

HI Folks

Below is the query to delete the Lock from the serial number

Sometimes it happen when user unable to find the Serial Number in Transact move Order Status

Cause :- May be the serial number group_mark_id = null , line_mark_id = null, lot_line_mark_id = null, is not Null

Below is the query to Set null for the particular Serial Number

  

update mtl_serial_numbers  msn

   set group_mark_id = null ,

       line_mark_id = null,

       lot_line_mark_id = null,

       last_updated_by = :USER_ID ,

       last_update_date=sysdate

 where current_status = :CURRENT_STATUS

   and serial_number in (:SERIAL_NUMBER )

   and inventory_item_id = :INVENTORY_ITEM_ID

   and not exists (select fm_serial_number

                     from mtl_serial_numbers_temp msnt,

                          mtl_material_transactions_temp mmtt

                    where msnt.fm_serial_number = msn.serial_number

                      and msnt.transaction_temp_id = mmtt.transaction_temp_id

                      and mmtt.organization_id = msn.current_organization_id

                      and mmtt.inventory_item_id = msn.inventory_item_id)

   and not exists  (select fm_serial_number

                      from mtl_serial_numbers_interface  msni,

                           mtl_transactions_interface mti

                     where msni.fm_serial_number = msn.serial_number

                       and msni.transaction_interface_id = mti.transaction_interface_id

                       and mti.inventory_item_id = msn.inventory_item_id

                       and mti.organization_id = msn.current_organization_id)