Friday, 29 November 2013

Purchasing Interview FAQ



Q. AME is possible in PO approval ??
NO. AME for Req approval

Q. Can we create Position heiracchy for Requisition Approval
Yes

Q. vacation rule has to be created by the same user...if being as a first person in the approver  goup the user not able to create vacation rule and goes on leave...then any other way, by  which we can handle that out of scope

Q. Can I get the recording version of yesterda's session?
No.

Q. Where did we do setups for taxes
Ebiz Tax

Q. Is AME diff in 11i and R12
Conceptually, AME is same or 11i and R12 but the look and feel and navigation is  completely different.

Q. Any profile for confidentiality of Quotation?
No. Anybody with access to quote and quote analysis screen has access to quotations

Q. when we delete approved record, if it is by other user, will he be notified for the same
No.

Q. How to protct cofidentialiy and modification of quot from others
- to prevent access to quote screen
- make the quote screen read only

Q. is there any work flow proces behind this?
no

Q. Can we have PO without RFQ or quotes for that matter.
Yes. We can have PO with RFQ and quotes. But its not a good practice.
Purchase Manager can be questioned why he gave order to some supplier. He will always have 2-3 quotes with him.

Q. but for blanket type of PO do you think quotes are required?
2 ways to determine price for an item
            - Quotations  - document provided by vendor to supply at a price
            - Blanket PO - agreement between vendor and us

Q. If we dont want other buyer can see qout of other buyer even they have access to RFQ screen ??
only related buyer only can see his Quot not other one which is not related to him ??
Personalization. Without personalization, its not possible.

Q. Can we copy Catalog RFQ to Standard quotation?
Yes. Copy Catalog RFQ to Catalaog quote or Standard quotation. Copy Bid RFQ to Bid quotation.

Q. Can you show us Creating PO from Requisition having RFQ as Source Doc.
RFQ cannot be source doc. We can have Quote as Source and we will be creating PO from Req using Quote as Source.

Q. Yes but not for release.
Question not clear

Q. What about negotion process in this ??
Negotiation is possible in Oracle Sourcing. Out of Scope.

Q. Are u going to take Planned Purchase order
Yes. That will be covered later.

Q. Will we cover Schedule release VMIand Consigned.?
Out of scope. Inventory related. Kindly attend Inventory training.

Q. Is there  any analytics available in this release to freeze the minimum quote automatically?
No. Quote analysis and approval is a manual process. No automation is provided.

Q. Can you cover the Advance Pricing intergration in Purchasing?
This will be covered conceptually. There wont be any practicals on the same.

Q. What about Bill of distribution??
Sourcing Rules  - ASL is required. Will cover Sourcing rules later.

Q. Sourcing means for RFQ ??
Selecting the Source of Supply of material.

Sourcing - Sourcing Rules - automatically create PO from requisitions

Q. While using ASL for Commodity theall items listed under that commodity will get imapcted . believe it's true can u confirm .
Yes. I will show you guys a chart

Q. How the Supplier status behave differently in Global & Local ASL?
Local ASL will override Global
Local (M1) - debarred Global - Approved

PO for M1 - will not allow
PO for M2 - should allow

But local is specific to that org not for others. so for M2 it should allowed.

Q. what is category level supplier?
The supplier will be ASL for all items which fall under that category.

Q. then where do we define that?
That is defined in ASL

Q. Where do we define the range of items under that category?
Linked while defining Items

Q. AND is approved for Item not for category so Item shoud be presidance. and it should allowed. Item shoud have more presidance then category.
NO. Category is having higher precedence. So, if a Supplier is debarred for a category then he is debarred for all items under that category.

Q. Can we create Req to Release Item if is not matching on Requisition and BPA. but ASL is set.
Question is not clear

Q. what if allocation for ASL is <100 %
For manual PR, 100% allocation does not matter. 100% allocation is required only for planned orders. For manual PR the PO will be raised against the supplier with highest allocation.

Q. What does Sourcing Assignment signify?
Sourcing Assignment will determine which supplier to source an item for a given ORG

Q. If we have one org then can we do transaction in Master Org
Yes. No restriction. Best practice that we should not do any transaction in Master Inv Org.


Q. What isTCA??
Trading Community Architecture. Covered in AR. This is party, customer relationship and stored in HZ tables.

Q. How intercompany sourcing happens and how PO will be managed in two companies?
Internal Requisition/Internal Sales Orders

Q. What is the need to add the price into price list...when we have given price for the item in Inventory setup?
Price that we mentioned is the Purchase list price. But for OM, it picks the price from Price list.

Q. While giving the value in Price list...do we add our all the cost and profit in that
For internal items, the transfer price is calculated based on the cost + the transfer options.

Q. What does create internal order conc request do?
Create internal order request will transfer the IR info to OM interface tables.

Q. Why is the cost zero for Internal Orders?
We did not enter any cost for the item, so the cost was zero.

Q. could you please show this cost thing by raising external sales order?
Out of Scope. OM class is required.


Q. Cost is zero for internal sales order, however you told that it will be 10% addition of the cost of that item then why it is not 10 % addition in the cost?

Q. Why is the cost of the Item zero?
The cost of the Item was zero because we did not enter the cost of the item.

Q. Where do we enter the cost?
We enter the cost while defining the Item.

Q. How does the price default while creating IR?
The price of the item while creating IR, is the cost of the Item.

Q. Can you clarify where we set up zero cost for an Item for IR?
We did not specify the zero for IR. If we do not enter the cost, it will be considered as zero.

Q. Can we change PO Currency?
Yes. We can change PO currency. It defaults from supplier setup but we can change it.

Q. Can you explain what is confirming order ?
Sometimes, the Purchase manager requests for certain items over phone. Then he sends the PO just to confirm the verbal order. If the vendor thinks that this is a duplicate order and delivers double, it could cause problem, so he sends a PO with a message that it is confirming order.

What is Difference Between Blanket release and Planned Release?
Blanket release is against blanket purchase agreement and planned release is against planned orders.

Under what Circumstance we'll use Blanket and Planned Agreement
In blanket, the price of the agreement is fixed but the quantity is not fixed. We get price breaks in Blanket for volume discounts.
In planned, the shipment is tentative. It does not have any price breaks so no volume discounts.

So, blanket is for high volume transactions.

Q. For planned orders, Schedule is available but blanket is for as and when required?
The schedule in planned Orders is just tentative. The actual schedule is determined later.
Blanket can have an effective date range. Planned does not have any effective date range.

Q. Can you cover Advance Pricing?
Not in scope.

Q. What is the way for adding items or modify BPA from supplier point of view..are they need have oracle apps installed with Oracle iSupplier portal?
They will have access to Oracle iSupplier portal which is a web based application. No installation is required.

Difference Between Oracle 11i and R12

what are the major difference between oracle 11i and R12 ?


Que: what are the major difference between oracle 11i and R12 ?
Ans :
Ø      11i only forms basis application but R12 is now forms and HTML pages.
Ø      11i is particularly in responsibility and operating unit basis but R12 is multi operating unit basis.
Ø      11i is particularly in set of books using and R12 using in ledgers.
Ø      11i in MRC Reporting level set of books called reporting set of books but in R12 reporting ledgers called as reporting currency. Banks are using at single operating unit level in 11i and ledgers level using in R12.
Differences between R12 & 11i.5.10 New R12 Upgrade to R12 – Pros and Cons Pros:
o       Sub-ledger Accounting – The new Oracle Sub-ledger Accounting (SLA) architecture allows users to customize the standard Oracle accounting entries. As a result of Cost Management's uptake of this new architecture, users can customize their accounting for Receiving, Inventory and Manufacturing transactions.
o       Enhanced Reporting Currency (MRC) Functionality – Multiple Reporting Currencies functionality is enhanced to support all journal sources. Reporting sets of books in R12 are now simply reporting currencies. Every journal that is posted in the primary currency of a ledger can be automatically converted into one or more reporting currencies.
o       Deferred COGS and Revenue Matching – R12 provides the ability to automatically maintain the same recognition rules for COGS and revenue for each sales order line for each period. Deferred COGS and Deferred Revenue are thus kept in synch.
Cons:
o       Resources – Availability of knowledgeable resources
o       Maturity – Though R12 is around since 2007, not all the modules are mature enough meaning modules like E-B Tax have many bugs being fixed by Oracle development.
o       Integration with customized applications – In a customized environment, all the extensions & interfaces need to be analyzed because of the architectural changes in R12
      R12 Features and differences with 11.5.10 – Inventory / Cost Management
o       Multi-Organization Access Control (MOAC) - Multi-Org Access Control enables uses to access multiple operating units data from single responsibility. Users can access reports , Concurrent programs , all setup screens of multiple operating units from single responsibility without switching responsibilities.
o       Unified Inventory - R12 merges Oracle Process Manufacturing OPM Inventory and Oracle Inventory applications into a single version . So OPM users can leverage the functionalities such as consigned & VMI and center led procurement which were available only to discrete inventory in 11i.5.10.
o       Inventory valuation Reports -There are a significant number of reports which have been enhanced in the area of Inventory Value Reporting
o       Inventory Genealogy - Enhanced genealogy tracking with simplified, complete access at the component level to critical lot and serial information for material throughout production.
o       Fixed Component Usage Materials Enhancement – Enhanced BOM setup screen and WIP Material Requirement screen that support materials having a fixed usage irrespective of the job size for WIP Jobs, OSFM lot-based jobs, or Flow Manufacturing
o       Component Yield Enhancements - New functionality that provides flexibility to control the value of component yield factors at WIP job level. This feature allows the user to include or exclude yield factor while calculating back flush transactions.
o       Periodic Average Cost Absorption Enhancements – Enhanced functionality for WIP Final Completion, WIP Scrap Absorption, PAC WIP Value Report, Material Overhead Absorption Rule, EAM work order, and PAC EAM Work Order Cost Estimate Processor Report.
o       Component Yield benefits - Component yield functionality user have the flexibility to control the value of component yield factors and use those factors for back flush transactions. Of course if the yield factor is not used, yield losses can be accounted for using the manual component issue transaction.
New Features:
    R12 Features and differences with 11.5.10 – Advanced Procurement Suite
o       Professional Buyer’s Work Center – To speed up buyers’ daily purchasing tasks – view & act upon requisition demand, create & manage orders and agreements, run negotiation events, manage supplier information.
o       Freight and Miscellaneous Charges – New page for viewing acquisition cost to track freight & miscellaneous delivery cost components while receiving. Actual delivery costs are tracked during invoice matching.
o       Complex Contract Payments – Support for payments for services related procurement including progress payments, recoupment of advances, and retainage.
o       Unified Inventory – Support for the converged inventory between Oracle Process Manufacturing – OPM Inventory & Oracle Inventory.
o       Document Publishing Enhancements – Support for RTF & PDF layouts and publish contracts using user specified layouts
o       Support for Contractor Purchasing Users – Support for contingent workers to create & maintain requisitions, conduct negotiations, and purchase orders.
New Features:
      R12 Features and differences with 11.5.10 – Order Management
o       Multi-Organization Access Control (MOAC) - Multi-Org Access Control enables uses to access multiple operating units data from single responsibility. Users can access reports , Concurrent programs , all setup screens of multiple operating units from single responsibility without switching responsibilities. They can also use Order Import to bring in orders for different Operating Units from within a single responsibility. The same applies to the Oracle Order Management Public Application Program Interfaces (APIs).
o       Post Booking Item Substitution - Item Substitution functionality support has been extended to post-Booking through Scheduling/re-scheduling in Sales Order, Quick Sales Order, and Scheduling Order Organizer forms. Item Substitution functionality is also supported from Planner’s Workbench (loop-back functionality) till the line is pick-released.
o       Item Orderability - Businesses need the ability to define which customers are allowed to order which products, and the ability to apply the business logic when the order is created.
o       Mass Scheduling Enhancements – Mass Scheduling can now schedule lines that never been scheduled or those that have failed manual scheduling. Mass Scheduling also supports unscheduling and rescheduling
o       Exception Management Enhancements – Improved visibility to workflow errors and eases the process of retrying workflows that have experienced processing errors
o       Sales Order Reservation for Lot-Based Jobs – Lot-Based Jobs as a Source of Supply to Reserve Against Sales Order(s). OSFM Displays Sales Order Information on Reserved Jobs
o       Cascading Attributes – Cascading means that if the Order header attributes change, the corresponding line attributes change
o       Customer Credit Check Hold Source Support across Operating Units - Order Management honors credit holds placed on customers from AR across operating Units. When Receivables places a customer on credit hold a hold source will be created in all operating units which have:
§         A site defined for that customer
§         An order placed against that customer.
New Features:
    R12 Features and differences with 11.5.10 – Shipping
o       Pick Release/Confirm Features
§         Pick Release enhancements - Enhancements will be made to the Release Sales Order Form and the Release Rules Form to support planned crossdocking and task priority for Oracle Warehouse Management (WMS) organizations. Pick release will allow a user to specify location methods and if crossdocking is required, a cross-dock rule. The task priority will be able to be set for each task in a sales order picking wave when that wave is pick released. The priority indicated at pick release will be defaulted to every Oracle WMS task created
§         Parallel Pick Release Submission - This new feature will allow users to run multiple pick release processes in parallel to improve overall performance. By distributing the workload across multiple processors, users can reduce the overall time required for a single pick release run.
o       Workflow Shipping Transaction Enhancement – Oracle has enabled Workflow in the Shipping process for: workflow, process workflow, activity and notification workflow, and business event
o       Support for Miscellaneous Shipping Transactions - Oracle Shipping Execution users will now be able to create a delivery for a shipment that is not tied to a sales order via XML (XML-equivalent of EDI 940 IN). Once this delivery has been created, users will be able to print shipping documents, plan, rate, tender, audit and record the issuance out of inventory. Additionally, an XML Shipment Advice (XML- equivalent of EDI 945 OUT) will be supported to record the outbound transactions.
o       Flexible Documents: With this new feature ,Shipping Execution users will be able to create template-based, easy-to-use formats to quickly produce and easily maintain shipping documents unique to their business. Additional attributes will be added to the XML templates for each report for added flexibility
o       Enhanced LPN Support - Oracle Shipping Execution users will now have improved visibility to the Oracle WMS packing hierarchy at Pick Confirmation. The packing hierarchy, including the License Plate Number (LPN), will be visible in the Shipping Transactions form as well as in the Quick Ship user interface.
New Features:
R12 Features and differences with 11.5.10 – Warehouse Management
o       Crossdock Execution – WMS allow you to determine final staging lane, merge with existing delivery or create a new delivery, synchronize inbound operation plan with outbound consolidation plan, enhance outbound consolidation plans and manage crossdock tasks.
o       Labor Management – WMS provides labor analysis. It gives the warehouse manager increased visibility to resource requirements. Detailed information for the productivity of individual employees and warehouses is provided
o       Warehouse Control Board Additions - Additional Task selection criteria
o       User Extensible Label Fields – WMS, users are now able to add their own variables without customizing the application, by simply defining in SQL the way to get to that data element
o       Material Consolidation across deliveries – WMS allows you to consolidate material across deliveries in a staging lane
New Features:
    R12 Features and differences with 11.5.10 – OSFM
o       Lot and Serial Controlled Assembly– Lot controlled job can now be associated with serial numbers to track and trace serialized lot/item during shop floor transactions as well as post manufacturing and beyond
o       Fixed Component Usage Support for Lot Based Jobs – OSFM now supports fixed component usage defined in the Bill of Material of an end it.
o       Support for Partial Move Transactions – Users are able to execute movement of a partial job quantity interoperation
o       Enhanced BOM to Capture Inverse Usage – Users can now capture the inverse component usage through the new inverse usage field in BOM UI
o       Support for Rosetta Net Transaction - comprising of 7B1 (work in process) and 7B5 (manufacturing work order).
New Features:
     R12 – Further Info…
o       The latest RCD (Release Content Documents) can be accessed from the metalink note 404152.1 (requires user name & password).
o       The TOI (Transfer Of Information) sessions released by Oracle Learning can be accessed from its portal at http:// www.oracle.com/education/oukc/ebs.html
o       Oracle White papers – Extending the value of Your Oracle E-Business Suite 11i.10 Investment & Application Upgrades and Service Oriented Architecture

Thursday, 21 November 2013

FAQ - Setup Asset Categories



1)  Is it possible to change an account to an Asset Category?

ANSWER:
Asset Category Accounts can be changed only before this category is used.
Once an asset is assigned to an Asset Category, the accounts can not be changed.

The Workaround is:
- Create a new category with required accounts.
- Reclassify the existing assets from the problem category to the new category.  If there
are a large number of assets, use Mass Reclassification or the Reclassification API.


2)  it possible to create a Category Type in Oracle Fixed Assets?

ANSWER:
No, this cannot be done.
Seeded Category Types in OFA are Lease, Leasehold Improvement, Non Lease.


3)  How to change the default rules for a category with an end date in the Define Categories (FAXSUCAT) form?

ANSWER:
Navigation: Setup > Asset System > Categories

1. Query the category, go to the correct book.
2. Press the Rules button.
3. In the Rules window, enter an end date.
4. Press the green Plus button to create a new record. One will get a new record with the new
start date equal to the day after the end date.
5. Make the adjustments to the rules.
6. Save.


4)  How to ensure the subcomponent/child asset always has a life that ends on the same day as the parent?

ANSWER:
Per the FA Users Guide the following is the validation logic for the default subcomponent life functionality:

Same End Date (without specifying a minimum life):
The subcomponent asset becomes fully depreciated on the same day as the parent asset or at the end
of the category default life, whichever is sooner.

Same End Date (specifying a minimum life):
The subcomponent asset becomes fully depreciated on the same day as the parent asset, unless the
parent asset life is shorter than the minimum life you specify. The subcomponent's life is determined based on the parent's asset life, the category default life, and the minimum life. If the parent's asset's remaining life and the category default life are both less than the minimum life you enter, Oracle assets uses the minimum life for the subcomponent asset. Otherwise it uses the lesser of the parent asset's remaining life and the category default life.

To ensure that the subcomponent/child asset always has the parent remaining life defaulting for the life set the Asset Category default life that will always be greater than the parent asset life (eg: 100 years etc.).
a. Setup > Asset System > Asset Category
b. Setup the Asset Category details and click the Default Rules button.
c. Set the default Life Years/Months under the Depreciation Method to be a large duration to ensure the parent asset life is always less than the default life value.  This will ensure the subcomponent/child asset always has the remaining life of the parent asset as the life during entry.


5)  How do I setup the same category for multiple books?

ANSWER:
Navigation:  Setup > Categories > Query category > Tab to Book >
             Press the plus(+) button and enter new book.


6)  How to mass copy Asset Categories from an existing book to a newly created book?

ANSWER:
There is no current functionality to perform this kind of setup. The only
supported method would be to enter them via the Asset Category form.


7)  What is required to designate a parent asset with subcomponents? 

ANSWER:
Navigation:  Setup > Asset System > Asset Categories

1. Go to parent asset's category specify the default subcomponent life.
Navigate to Assets/Setup/Asset System/Asset Categories/Query parent's category
/Default Rules.
In the Default Subcomponent Life block, choose one of the rules:

  A. None
     There is no link between the parent asset and the subcomponent's life.
  B. Same End Date (No Minimum Life required)
     The subcomponent's useful life will end on the same date as the parent or
     the default category life, whichever comes first.  When the parent asset is
     fully reserved, the subcomponent is given a one-month life. 
  C. Same End Date (Minimum Life not requried)
     The subcomponent's useful life is fully depreciated on the same day as the
     parent asset unless the parent's life is shorter than the minimum life
     selected.
  D. Same Life
     The subcomponent's life is the same as the parent's.  If the subcomponent
     is added after the parent, it depreciates past the parent's useful life.

2. Add the parent asset first.

3. Add the subcomponent assets.
   You define the parent asset in Quick or Detailed Additions, navigate to
   Assets/Asset Workbench/Asset Details and enter the parent asset's number.

4. To monitor the subcomponent of a parent asset navigate to Assets/
   Asset Workbench/Query the parent and select subcomponents. The subcomponents
   for the parent will be listed on this form.


8)  How to change an asset category to Expensed?

ANSWER:
If no assets have been added to the Asset Category, you can go to the Menu > Edit >
Delete Record.  Once deleted, you can create the new category and make sure the
'CAPITALIZED' box is NOT checked.  This is an EXPENSED category.


9)  How can an income statement account be designated as the Asset Clearing Account?

ANSWER:
Accounts with a value set qualifier of "Income" or "Expense" can not be
designated as the Asset Clearing account.   The List of Values used to select
and validate clearing accounts will only include balance sheet type accounts.