Sunday, May 31, 2015

Oracle Certification - Supply Chain Certified Implementation Specialist: Oracle Purchasing


Oracle Certified Specialist - Supply Chain

Oracle E-Business Suite  12 Supply Chain Certified Implementation Specialist: Oracle Purchasing 





I received Oracle E-Business Suite  12 Supply Chain Certified Implementation Specialist: Oracle Purchasing  certification from Oracle University by passing the exam and certification requirement.











If you have any question / suggestion you can contact or leave the comment. 

Quotation types!!!

Oracle ebusiness suite>Oracle SCM > Oracle Purchasing

Question of the Day!!   








Module: Oracle Purchasing



No.:  What are the Quotation types?




Ans: There are three types of Quotations.



There are three types of quotations in Purchasing by default:

Catalog:


 Quotation type is Used for high-volume items or items for which your supplier sends you information regularly. A Catalog quotation also includes price breaks at different quantity levels.

Standard: 

Quotation type is Used for items you'll need only once or not very often, but not necessarily for a specific, fixed quantity, location, and date. For example, you could use a Catalog quotation for office supplies, but use a Standard quotation or  for a special type of pen you don't order very often. A Standard quotation  also includes price breaks at different quantity levels.

Bid:

Quotation type is Used for a specific, fixed quantity, location, and date. For example, a Bid would be used for a large or expensive piece of equipment that you've never ordered before, or for an item that incurs transportation or other special costs. You cannot specify price breaks for a Bid quotation .




               *******************************




My Oracle Certification - Oracle Expert

Oracle E-Business Suite > Oracle Certifications 


Oracle Expert



I received Oracle Expert certification from Oracle Support by actively participating in Oracle Support Communities.








My Oracle Certification - Oracle

Oracle E-Business Suite > Oracle Certifications 

Oracle Pro


I received Oracle Pro certification from Oracle Support by actively participating in Oracle Support Communities.










My Oracle Certification - Oracle Journeyer

Oracle E-Business Suite > Oracle Certifications 

Oracle Journeyer



I received Oracle Journeyer certification from Oracle Support by actively participating in Oracle Support Communities.




Saturday, May 30, 2015

Purchase Price Variance!!

Oracle ebusiness suite>Oracle SCM > Oracle Purchasing

Question of the Day!!  




                
Module: Oracle Purchasing


No.:  What is Purchase Price Variance?




Ans: 


The purchase price variance is calculated as the quantity received multiplied by the difference between the purchase order price and the standard cost.
The purchase price variance is the difference between the actual price paid to buy an item and its standard price, multiplied by the actual number of units purchased. The formula is:
(Actual price - Standard price) x Actual quantity = Purchase price variance

Purchase Price Variance Report



The Purchase Price Variance Report shows the variance between the purchase price on the purchase order and standard cost for all items you receive and deliver into inventory and work in process. Inventory records purchase price variance on delivery into a subinventory. Work in Process records purchase price variance on delivery into a job or repetitive schedule. For internal requisitions, the purchase order ship to location is associated with the organization in the Customers window

                     ********************************

Unreserve the Item Quantity in Oracle Inventory

Oracle ebusiness suite>Oracle SCM > Oracle Inventory


Question of the Day!!   




Module: Oracle Inventory



No.:  How to unreserved quantity in oracle Inventory?



Ans: You can unallocate the Move Order quantity to unreserved the quantity.


Move order..> transact move order 

query Move order no. 

At left bottom corner you will find allocations. 

Go to allocation & nullify the move order & save.





                           ************************


AutoCreate Documents in Oracle Purchasing : PO

Oracle ebusiness suite>Oracle SCM > Oracle Purchasing

Question of the Day!!  








                

Module: Oracle Purchasing


No.1:  What is Autocreate documents in Oracle Purchasing?


Ans: Purchasing provides automatic creation capabilities for documents. Buyers can quickly create standard purchase orders, planned purchase orders, blanket releases, RFQs, and Oracle Sourcing negotiations from any available standard (not internal) purchase requisition lines.




Purchase Requisition -> RFQ

RFQ -> Quotations

Purchase Requisition -> PO


Fast Purchase Order and RFQ Creation

All purchase requisition lines available for autocreation go into a single requisition pool. Buyers can retrieve any of the requisition lines from the pool and use the AutoCreate Documents window to create standard and planned purchase orders, blanket releases and RFQs. 

You can place a requisition line on as many RFQs as you want before you place it on a purchase order, after which it is no longer available in the requisition pool.

Fast Quotation Creation


Buyers can use the Copy Documents window to create supplier quotations for each RFQ. Buyers can choose entire RFQs or specific RFQ lines and shipments









                                  ***************************************



Wednesday, May 27, 2015

Invoice Batch Control Process - Oracle Payable

Oracle ebusiness suite>Oracle Financial> Oracle Payables

Invoice Batch Control Process


Batch Control provides help to speed up and control invoice entry in the Invoice Workbench.

User can create Batches as per their requirement whether on daily basis or monthly basis or with their name.

For Contract invoices, Invoice Batch Control can be used. For any contract that has multiple payments batches are used.

For example contract # 12345 with amount is AED 100,000 and amount is to be paid in 5 installments. A Batch named Contract # 12345 (Test case) is to be created and Batch Control user will enter 5 it means five invoices is to be created and control amount enter 100000 the amount of the contract.


Now when the user create the invoices, Batch control window will show the control amount, Actual amount enter and the variance amount. For example user enters the Invoice of AED 30,000. It will show as below:

·         Control Amount = 100000
·         Actual Amount =  30000
·         Variance    =  70000


Same ways it will show the variance in invoices count like user enter 3 invoices in the batch. It will show the result as
·         Control count = 5
·         Actual Invoice count =  3
·         Invoice Count Difference   =  2



Note: After creation of Invoices Batches, User must be careful for searching the batch as “Batch Search” is case sensitive. 


Invoice Batch Control Functions


Following are the functions of Batch Control – Invoices


1.      Hold Invoices: You can hold the batch invoices for payment
·         Hold Name. Hold you want to apply to each invoice.
·         Hold Reason. Payables display the Hold description if you have entered a Hold Name.

2.      Actual Invoice Count. Payables display the number of invoices you have entered in the batch.

3.    Actual Invoice Total. Payables display the cumulative sum of the invoice amounts of the invoices you have entered in the batch.

4.       Batch Name. Name of the invoice batch.

5.      Control Amount. Enter the sum of the invoice amounts in the batch.

6.      Control Count. Enter the number of invoices in the batch.

7.     Currency. The default currency for all invoices in the batch. (After you save an invoice, you cannot change the Currency. You can use the Invoice Actions window to cancel the invoice. You can then reenter the invoice with the correct currency)

8.      Invoice Count Difference. Payables display the Control number minus the Actual number.

9.      Invoice Total Difference. Payables display the Control amount total minus the Actual amount total.

10.  Liability Account. Account for the liability of each invoice. If you do not enter a batch default, Payables uses the supplier site Liability Account as a default for each invoice.

11.  Pay Group. Use Pay Group to group invoices from multiple suppliers in a payment batch.

12. Payment Currency. Payables enter the Invoice Currency as the default. If the Invoice Currency is not a fixed-rate currency, you cannot update the value. If the Invoice Currency is a fixed-rate currency such as Euro or an EMU national currency, you can change the Payment Currency value to an associated fixed-rate currency.

13.  Payment Terms. Payment terms Payables uses to create one or more scheduled payments for an invoice.




Invoice Batch Process


Batch Control provides help to speed up and control invoice entry in the Invoice Workbench.

Navigation: Payables > Invoice Batches





Click on Invoice Batches Tab to open Batches window.


Invoice Batches window 




Batch Name: Enter the Batch Name in Batch Name Field.

Control Count: Control Count is total number of Invoices that can be entered into this Batch.

Control Amount: Control Amount is the amount of batch that can be entered into the batch.

Batch Information: [] these two brackets indicate the descriptive flex field (DFF) in Oracle; this 
field is used for Bach Information at this screen. Click on the field and the new screen will open.



Enter the Batch Number or Press Ok if systematic Batch Number is required to Use.




Click on Invoices Tab to enter the invoices.




Control Count =5, Actual Invoice Count =3, Invoice Count Difference=2

Control Amount =100000, Actual Invoice total =30000, Invoice total Difference=70000






Caution message will appear if the control total and the actual are not equal.



Invoice Window for entering invoices


Batch Control Total: Batch control total, batch amount is showing on the top left side of the window.

Batch Actual Total: Batch Actual total is showing on the top right side of the window.

Batch Control Total = 100000

Batch Control Actual =30000




Batch Control Reports


Two reports are available for Batch Control.

·         Batch Control Report by Batch Name
·         Batch Control Report by Entered By

Batch Control Report by Batch Name:




Batch Control Report by Entered By























Inventory Transactions

Oracle ebusiness suite>Oracle SCM > Oracle Inventory

Question of the Day!!   





Module: Oracle Inventory




No.1:  Explain the Inventory Transactions?




Ans: There are four types of Inventory transactions.


  • Move Order
  • Sub Inventory Transfer
  • Inter- Org Transfer
  • Misc. Transfer




Move Order:

Move order is used for transferring of inventory from one sub Inventory to another sub Inventory.

Move order can be used for Replenishment.
Approvals and document number s used for Move order.
Sub Inventory  > Sub Inventory ( With  Approval)

Sub Inventory Transfer:

Sub Inventory transfer is used for transferring inventory  from One sub Inventory to another sub Inventory.
Sub Inventory  > Sub Inventory

Inter- Org Transfer

Inventory transfer from one Organization to another organization.
Transfer can be. 
  • Direct
  • In-transit
Inv Org > Inv Org
  

Misc. Transfer

Misc. Receipts or Misc. Issue is used for receiving or issuing items from any sub inventory.

In-Out > Subinventory






                                      *********************************