Thursday, 29 September 2016

Contract Purchase Agreement in R12

CONTRACT PURCHASE ORDER
 
Contract purchase agreement is a long term agreement that a Customer  will have with their supplier with specific terms and conditions and without indicating the goods and service to be procured.

CPA Will Contain Only Supplier Information and Terms and Conditions for Procurment.

If a Material or Service has to be Procured From Particular Supplier, Then a Standard Purchase Order will made with reference to Contract Purchase order and Receipt is Made.

Navigation :Purchasing, Vision Operations (USA) --->Purchase orders ---> purchase Orders  (OR)  Purchasing Vision Operations (USA) ---> Buyer Work Center ---> Agreements





Enter Header Details of Contract Purchase Agreement Such as Supplier, Supplier Site, Bill to, Ship to .


 

Click on terms for Entering Contract Terms such as Payment, Freight, Carrier, FOB Supplier and Receiver Notes.




Make Note that Amount Agreed has been Defaulted to Amount Limit.

purchasing Uses the Amount Agreed for Approval Management and Amount Limit for Releasing Orders.

We Can add Contract Terms by Clicking Author Contract Terms and Using a Contract Template to Add Clauses.

Then Save the Contract Purchase Agreement and Submit For Approval.

once the Contract Agreement is Approved, Standard Purchase Orders are Created with reference Document Details Containing the Contract Agreement Details. 

 



Wednesday, 21 September 2016

Oracle eAM Overview

An eAM organization must be classified as an Inventory Organization.

 Enterprise Asset Management(eAM) parameters are on the Inventory Parameters tab, within the Organization Parameters

once eAM Parameters or an Asset item is defined, EAM Enabled Check Box in organization parameter Cannot be unchecked.

Oracle Enterprise Asset Management is integrated with Oracle Install Base

Enterprise asset management enables companies to drive maintenance best practices and manage the full asset lifecycle with a complete view of all types of assets and equipment.

Oracle E-Business Suite Enterprise Asset Management solutions enable companies to drive maintenance best practices; empower all workers with easy-to-use self-service applications; and manage the full asset lifecycle with a complete view of all types of assets and equipment, while supporting compliance and corporate governance initiatives throughout the global organization.
  

Oracle Inventory - Item Attribute, Item Defining Attributes

Item attributes are information about an item, such as UOM, Lot Control,Physical Attributes,Buyer List price Etc.,

Item Defining Attributes identifies the nature of a Item .
When u set an item defining attribute to Yes, the item is automatically assigned to the default category of the corresponding functional area.

Following are the Item Defining Attributes.



 
Functional Area Item Defining Attribute
Inventory Inventory Item
Purchasing Purchased Item
Master Scheduling/Supply Chain MRP Planning Method
Cost Management Costing Enabled
Engineering Engineering Item
Order Entry Customer Ordered Item
Service Service Request



Wednesday, 31 August 2016

Seeded Responsibilities of oracle eAM (Entreprise Asset Management)

   While Installing the Oracle eAM, following five responsibilities are automatically created.

1.Oracle Enterprise Asset Management
2.Maintenance User Workbench
3.Maintenance Super User
4.Self-Service Work Requests
5.Self Service Time and Expenses   

Thursday, 25 August 2016

Oracle E Business Suite - How to Enable/Disable "About This Page" in OAF Pages



  There May instances Where the About this Page link in OAF Pages are Hidden. This Can be Removed or Added to a Page Depending Upon the Below Mentioned Setup.

Go to System Administrator Responsibility 

Check and Set the Below Mentioned Profile Option Values

1. FND: Diagnostics
2.Personalize Self-Service Defn

Once these profile options have been changed, users will need to log out and log in for the change to take effect

Monday, 4 July 2016

Query to Find Request Group and Application of a Concurrent Program



    Below Mentioned Query Will Fetch the associated request group and application name for a concurrent program.

I Have Used 'ECO Open Interface'  as Concurrent Program.

SELECT cpt.user_concurrent_program_name "Concurrent Program Name",
  DECODE(rgu.request_unit_type, 'P', 'Program', 'S', 'Set', rgu.request_unit_type) "Unit Type",
  cp.concurrent_program_name "Concurrent Program Short Name",
  rg.application_id "Application ID",
  rg.request_group_name "Request Group Name",
  fat.application_name "Application Name",
  fa.application_short_name "Application Short Name",
  fa.basepath "Basepath"
FROM fnd_request_groups rg,
  fnd_request_group_units rgu,
  fnd_concurrent_programs cp,
  fnd_concurrent_programs_tl cpt,
  fnd_application fa,
  fnd_application_tl fat
WHERE rg.request_group_id            = rgu.request_group_id
AND rgu.request_unit_id              = cp.concurrent_program_id
AND cp.concurrent_program_id         = cpt.concurrent_program_id
AND rg.application_id                = fat.application_id
AND fa.application_id                = fat.application_id
AND cpt.language                     = USERENV('LANG')
AND fat.language                     = USERENV('LANG')
AND cpt.user_concurrent_program_name = 'ECO Open Interface';