Tuesday, 17 April 2018

standard sales order--oracle order management r12

STANDARD SALES ORDER


create a standard sales order

on-hand-qty---10
requested qty--12
available qty--10
 reserve qty---10

now the status is BOOKED
perform picking & shipping single line

query your sales order
system splited two lines 
whatever the on hand qty we do have thats going to be one line
whatever the except on hand qty means less than available qty  (requested qty-avail qty) thats going to be another line

now the status like
item       qty                 status                             calculated pricing tag 
apple       10                 shipped                          partial price
apple        2                  awaiting shipping          freeze price

get the 2 qty and again perform picking & shipping

--------------------------------------------------------------------------------------
create a standard sales order

requested qty--12
available qty--10
 reserve qty---10

assign ship set to the sales order lines

now the status is BOOKED
perform picking & shipping single line

query your sales order

now the status like
item       qty                 status                                      calculated pricing tag 
apple       12               picked partial                         partial price

get the 2 qty and again perform picking

item       qty                 status                             
apple       12                 picked
-------------------------------------------------------------------------------------------

create a standard sales order

requested qty--10
available qty--10
 reserve qty---10

assign ship set to the sales order lines

now the status is BOOKED
perform picking & shipping single line

query your sales order

now the status like
item       qty                 status                             calculated pricing tag 
apple       10               shipped                           calculate price

-----------------------------------------------------------------------------------------------


Sunday, 15 April 2018

iprocurement information

what is punchout

punchout, we integrate iProcurement with Suppliers website.
Buyer logs into iProcurement Homepage
Buyer then sees various suppliers for which punchouts are enabled (depends on attribute &security rules)
Buyer clicks on a stationary supplier and browser displays supplier’s website
Buyer selects the items on supplier website and adds them to his cart.
The items selected are brought in as “Shopping Basket in iProcurement
Requisition is created in iProcurement and sent for Approval 

Typical iProcurement Steps [assuming no encumbrances setup] 

Create Requisition
Approve Requisition
Auto-create & auto-approve PO for approved requisitions.
Send PO XML to Supplier [if approver is setup as trading partner for XML PO]
Create receipts for goods 
Other non iProcurement setups
Supplier sends Invoice electronically 
Invoice is Matched, Approved & Paid
Account Generation for iProcurement Requisition
Decide the rules for your account generation.
For this you will need to be customize PO Requisition Account Generator. For details of account generator implementation .


PO Create Documents Work flow

In iProc you create Requisitions, which then get converted to a Purchase Order using workflow “PO Create Documents”. 
In this workflow, you must examine & modify the default values of following attributes.few default values i just listed down
           Automatic Creation Allowed  : yes
                        Should PO be created from iProc- requisition without user intervention.
          Automatic Approval Allowed – Yes
            Should Contract be used to auto create Doc :Yes
Should non-catalog request be auto sourced from contract: Yes
Is Contract Required on Requisition Line : y/n
There could be other attributes of your interest, but my implementation involved usage of contracts to create Purchase Orders. We have a blanket contract against each iProc supplier. 

Mandatory Setups for iProcurement:


1.                   Profile Options
2.                   Shopping Category Creation
3.                   Category Hierarchy
   a.  Top Category (Browsing Category) - Create Top-Level Category
  i.   Child Category (Browsing Category) - Create Child
1.   Shopping Category (Item Category) - Insert Existing Child
4.                   Purchasing Category Creation
5.                   Category Mapping
               assign your default purchase category and map to your item category
6.                   Item Creation and Purchasing Category Assignment
7.                   Content Zone Creation
              where we keep our default suppliers and default categories
              where are getting items from specific suppliers or all suppliers we can able to                make setups, restrictions here
8.                   Information Template Creation
9.                   Smart Form Creation
              where we maintain default supplier information
              default item information, unit of measure, list price
10.               Create Stores
              where we create our stores to assigning to our particular smart forms,                              content zones

few profile options related to iprocurement


POR: Enable Requisition Line Customization: y/n
POR: Require Blind Receiving: y/n
POR: Purchasing News Location
POR: Support review for Express Receive: y/n
POR : Goods Line Type
POR: Contractor Expense Line Type
POR: Apply Expense Account Rules to Favorite Charge Accounts
POR : Preferences - Selected Items Default to Inventory
POR: Generate and Display Account at Checkout: y/n
POR: Override Requestor
POR: Contractor Expense Line Type
PO: Legal Requisition Type
POR:Allow Manual Selection of Source
POR : System Approvers are Mandatory
PO: Allow Requisition Approval Forward Action

venkatesh yadav m

Thursday, 12 April 2018

Oracle scm purchase order-status & document security rules

Purchase order statuses


INCOMPLETE- whenever you open PO form status should be incomplete until you click the                                          approve button  

IN PROCESS- when you click the approve button status going to In process until approver approve                               the PO 

APPROVED- when approver approved the PO status going to approved

REQUIRES RE APPROVAL-- when we made any changes on approved PO status going to requires                           re-approval. document goes to approval again. we need to be approve the PO

REQUIRES RE APPROVAL, ON HOLD-- when approved PO applied any hold status going to requires re-approval on hold. we need to release the hold. once release the hold status going to requires re-approval again we need to approve it. but this time it wont go to any approver

APPROVED, CLOSED- when you closed approved PO status going to approved, closed. even-though its closed PO we can able to open it

REJECTED- when approver did the document reject status going to be rejected

CANCELED PO--when purchase order has canceled closure status going to be closed
                              if we do finally closed for canceled PO closure status going to finally closed

when the PO document having these statuses like FROZEN, CANCELED, FINALLY CLOSED, INCOMPLETE, IN PROCESS, PRE-APPROVED
we can't able to open those PO's
-----------------------------------------------------------------------------------------------------------

when document having security rule


if you unchecked the APPROVER CAN MODIFY check box in document type
did security level: PRIVATE
access level: VIEW ONLY 

security rule: PRIVATE
access level: MODIFY

security level: PRIVATE
access level: FULL

security level: HIERARCHY
access level: VIEW ONLY 

security rule: HIERARCHY
access level: MODIFY

security level: HIERARCHY
access level: FULL

security level: PURCHASING
access level: VIEW ONLY 

security rule: PURCHASING
access level: MODIFY

security level: PURCHASING
access level: FULL

when document having these security & access rule when approver can modify check box uncheched

approver can't able to modify the document when approver gets the PO

APP-PO-14694 updates couldn't possible