1. Create an Item, should be Customer ordered, customer orderable, purchased, purchase order enabled
2. Give the buyer details
3. OM: Population of Buyer Code for Drop Ship should be Order Creator
4. Now add the buyer Employee to the user who will crete the PO
5. Create a sales order, line source type should be external(this can be setiup at item level too)
6. Once you book the order, workflow will be deferred.
7. Run the Workflow background, this will change the line status to Awaiting Receipt
8. Run the PO Requistion Import program from the PO responsibility with parameter Source as ORDER ENTRY and Initiate Approval after ReqImport as Yes.
9. Go to the sales order and in additoional information, drop ship tab, you can see the PO/PO req details
10.Go to Purchasing --> Autocreate, Goahead and create the PO Document and Approve the same.
11.Now go and receive the PO, this will automatically trigger the Sales order issue transaction for the drop ship SO

Read More

To achieve this, you have to follow below steps

1. Define the Picking and Shipping Document set

2. Define a Ship confirm rule and add the shipping document here.

3. Define a a Pick Release rule

    (Make sure Auto Pick Confirm, Auto Create Delivery, Auto Pack Delivery are set as Yes)

4. Add the ship confirm rule in the shipping tab

5. Add the Picking Document set in Pick release rule

6. Make sure Auto allocate is Yes in Inventory tab.

7. Now use "Release Sales Order SRS" and Schedule it as per the frequency you need for the Pick release rule you have created.

Read More

1. Find an organization which is WMS enabled
2. Take any item assigned to this org, make sure you have onhand present
3. Make sure you have your Pick and Put away rules defined for that org
4. If you are defining stratergy then assign those in the work rule bench also
5. Create a sales order
6. use the item and source it from the WMS enabled org
7. Do Release Sales order
8. Make sure during pick release, you keep Auto Pick confirm as No and Auto allocate as No.
9. Then run the Pick release by Execute Now/Concurrent 
10. Go to shipping transaction form and copy the move order for this line
11. Now go to the WMS responsibility
12. Select Rules Simulation (Setup>Warehouse Configuration>Rules>Warehouse execution>Rule Simulation)
13. Select "Pick & Putaway" in the rule simulation form left panel, then Find Move Order button will be active
14. Click on Find Move order, enter the move order and click on Simulate.
15. Now you can see which Pick rule is used in Source Loc tab and Staging Putaway rule used in Destination Loc tab.

Read More

Run this script giving inventory org as the parameter

SELECT mp.organization_id,

       MP.ORGANIZATION_CODE,

       hl.address_line_1,

       hl.address_line_2,

       hl.address_line_3,

       hl.town_or_city,

       hl.country,

       hl.postal_code,

       HAOU.NAME,

       HAOUBG.NAME BUSINESS_GROUP,

       GSOB.SET_OF_BOOKS_ID,

       GSOB.NAME SOB_NAME, /*gsob.short_name,*/

       GSOB.CURRENCY_CODE,

       GSOB.PERIOD_SET_NAME,

       (SELECT SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' ||

               SEGMENT4 || '.' || SEGMENT5 || '.' || SEGMENT6 || '.' ||

               SEGMENT7 || '.' || SEGMENT8 || '.' || SEGMENT9

          FROM APPS.GL_CODE_COMBINATIONS

         WHERE CODE_COMBINATION_ID = GSOB.CHART_OF_ACCOUNTS_ID) CHART_OF_ACCOUNT,

       HLE.NAME LE_NAME,

       HLE.VAT_REGISTRATION_NUMBER,

       HOU.NAME OU_NAME

  FROM APPS.HR_ALL_ORGANIZATION_UNITS   HAOU,

       APPS.HR_ORGANIZATION_INFORMATION HRI,

       APPS.MTL_PARAMETERS              MP,

       APPS.GL_SETS_OF_BOOKS            GSOB,

       APPS.HR_LEGAL_ENTITIES           HLE,

       APPS.HR_OPERATING_UNITS          HOU,

       APPS.HR_ALL_ORGANIZATION_UNITS   HAOUBG,

       APPS.HR_ORGANIZATION_INFORMATION HRIBG,

       apps.hr_locations                hl

 WHERE HRI.ORGANIZATION_ID = HAOU.ORGANIZATION_ID

   AND HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID

   AND MP.ORGANIZATION_CODE IN ('V1')

   AND HRI.ORG_INFORMATION_CONTEXT = 'Accounting Information'

   AND GSOB.SET_OF_BOOKS_ID = HRI.ORG_INFORMATION1

   AND HLE.ORGANIZATION_ID = HRI.ORG_INFORMATION2

   AND HOU.ORGANIZATION_ID = HRI.ORG_INFORMATION3

   AND HAOUBG.ORGANIZATION_ID = HLE.BUSINESS_GROUP_ID

   AND HRIBG.ORG_INFORMATION_CONTEXT = 'Business Group Information'

   AND HRIBG.ORGANIZATION_ID = HAOUBG.ORGANIZATION_ID

   and haou.location_id = hl.location_id

;

Read More

Purchasing

Q. What are the approval hierarchy

Q. What approval hierarchy you use in your implementation?

Q. How to check what is the approval hierarchy used in your system?

Ans: If Use Approval Hierarchy option is enabled in the Financial Options form, it will use the position based hierarchy. If it is disabled then it will use the supervisor based hierarchy.

Q. How to send the PO to a person before even approval who has that approval limit not through workflow hierarchy

Q. Where to do the setup for specific approval limit for a person?

Q: What is Charge Account?

A: Charge account in PO distribution is used as a debit account during the PO delivery process(the account to charge for the cost of the item).

If PO is for an inventory item, then mostly the charge account will be defaulted from the subinventory or organization material account.

If it is for an expense item, then the account will be defaulted from the subinventory or organization item expense account

Q: How Charge Acount default?

A: PO Charge account, in fact all purchasing accounts will be derived from the Account generator workflow items

Ref doc: http://docs.oracle.com/cd/A60725_05/html/comnls/us/po/poacgen.htm

Q: Can a PO be created without Item?

A: Yes you can create a purchase order without an item.

in purchase order, you can create different line type as per the types of product or services you want to buy.

Either this can be an inventory item or this can be a consulting service or labor

Ref doc: http://docs.oracle.com/cd/A60725_05/html/comnls/us/po/linety01.htm

Q: Differences between Internal Sales Orders and Inter-Organization transfer
A:  Explore more here

• IR-ISO has approval process whereas there is no approval process for Inter-Org transfer
• The IR cycle useful for more tracking, control (IR, SO), approvals and generating pick slips whereas Inter-Org transfer is a one step transaction, simple flow, more user friendly and no interfaces involved
• RMA is possible in Internal Sales Order whereas in Inter-Org transfer there is no functionality to Cancel, delete or Return or not receive an In-transit Shipment

Q: When Internal Sales Order and Internal Requisition will be picked up by Inter-Company invoicing process?
A: Internal sales order and Internal requisitions will be picked by Inter-company invoice process on the following conditions:

• In shipping method, transfer type should be Intransit
• Profile Option INV:Inter-company Invoice for Internal Orders value is Yes on site level. This will be used for creating Account Payable in the Intercompany Invoice process.

Explore more here

Q: What validations happen for Create Release program for creating a BPA release for a requisition?
A:

1. Sourcing rule exists or not for the item
2. Whether ASL defined or not
3. BPA and Line details mentioned in ASL or not
4. BPA should be approved
5. Corresponding BPA line should not be cancelled
6. BPA terms effective dates should satisfy the date on release creation
7. BPA agreement for qty or amount should satisfy the release qty
8. Rel qty should satisfy the BPA min release qty

Questions will be Answered soon if not answered already. Meanwhile you can post more questions in the comment also you can answer to above questions in the comment.
Please help here to rectify if any of the answers are not correct.

Read More