Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Friday, August 5, 2011

Oracle P2P Life Cycle in11i

1. Create Requisition

a. Navigation ? Purchasing Vision Operations (USA) ? Requisitions ? Requisitions

Header Fields:

Type ? Purchase Requisition

Status ? At this stage the status is incomplete.

Preparer: Stock, Ms.Pat

In Lines tab: Enter the required fields i.e

Num: 1

Type: Goods

Item: Color Cartridge

Rev: A

Category: MISC.MISC

Description: Color Cartridge

UOM (Unit of Measure): Each

Quantity: 1

Price: 10

Need-By Date: Enter Need-By date

Amount is displayed as 10.

Under Source details tab: Enter the Buyer name.

In the Source Details tab, Enter the Buyer name : Stock, Ms. Pat

Click on Distributions tab and enter the Num, Quantity and Charge Account.

Click on Save. Hit the Approve Button

Select the submit for Approval box and hit OK.

The Requisition No. displayed is 5661.

b. Navigation ? Purchasing Vision Operations (USA) ? Requisitions ? Requisition Summary

Enter the Requisition No. and click on “Find”

The status is “Approved”

Tables Affected

PO_REQUISITION_HEADERS_ALL

PO_REQUISITION_LINES_ALL

PO_REQ_DISTRIBUTIONS_ALL

2. Create Purchase Orders using “Auto Create”

Creating Purchase Order using Auto Create maps the requisition no. to Purchase Order No.

a. Navigation ? Purchasing Vision Operations (USA) ? Purchase Orders ? AutoCreate

Click on Open

Enter the Requisition No. and click on “Find”

Click on “Manual” creation of Purchase Order

Choose the Supplier information as “3M Health Care” . Hit on Create

Click on “Add to Document”

Make note of the Purchase Order No. which is 4480.

Click on Currency tab, to change the currency to be used

Click on Terms and Conditions tab to enter information regarding any terms agreed with the supplier.

Click on Shipments tab

Hit on more and choose Invoice to Match option to “Receipts”.

At this point, the status is “Incomplete” in the Headers tab. Save the work and hit on Approve.

b. Navigation ? Purchasing Vision Operations (USA) ? Purchase Orders ? Purchase Order Summary

Enter the Purchase Order No. which is 4480 and click on Find

The Status is “Approved”.

Tables Affected

PO_HEADERS_ALL

PO_LINES_ALL

PO_DISTRIBUTIONS_ALL

Note:

The segment1 column of the po_headers_all table contains purchase order numbers.

Additional Information

/* Requisition No. for a Given Purchase Order No. when the purchase order is auto created from Requisition documents*/

/*[ segment1 of po_requisition_headers_all contain requisition numbers, segment 1 of po_headers_all contain purchase order numbers] */

desc po_req_distributions_all

desc po_distributions_all

select prh.SEGMENT1 "Requisition Number", ph.SEGMENT1 "Purchase Order Number"

from po_req_distributions_all prd, po_distributions_all pod, po_headers_all ph,

po_requisition_lines_all prl, po_requisition_headers_all prh

where prd.ORG_ID = pod.ORG_ID

and pod.PO_HEADER_ID = ph.PO_HEADER_ID

and prd.REQUISITION_LINE_ID = prl.REQUISITION_LINE_ID

and prl.REQUISITION_HEADER_ID = prh.REQUISITION_HEADER_ID

and ph.PO_HEADER_ID = 32744

and prl.REQUISITION_LINE_ID = 60723

3. Navigation ? Purchasing Vision Operations (USA) ? Receiving? Receipts

Select the Organization name as V1 Vision Operations

Enter the sub inventory as Stores. New Receipt No. is 7478.

Tables that are affected

RCV_SHIPMENT_HEADERS

RCV_SHIPMENT_LINES (Line table has PO_HEADER_ID)

4. Creating Invoice in payables.

Payables, vision operations ? Invoices

Once the goods are received, the receiving company/party should pay for the goods and hence the invoices are created in payables.

Select Receipt and click on Match

Validate the Invoice

Click on Actions, Following screen will appear

Create Accounting

Payment in full

Click on Save.

Transfer to GL

General Ledger, Vision operations ? Journal ? Enter

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect