, ,

Oracle R12 – RFQ to PO Receipt Cycle

This Post is about Oracle applications RFQ to Receipt Cycle.In this Post I will explain the Cycle from RFQ to PO Receipt with screen shots.

High -Lights of this Cycle is  to Create:

  • RFQ
  • Quote
  • Purchase Order
  • Receive against PO.

Once RFQ is created , Submit concurrent job “Request to Print the RFQ” for a supplier. On completion this job will increment print count for that supplier as shown below.

In below  Oracle Apps UIs we can see
  1. RFQ # 308,
  2. Supplier Info from Supplier List and
  3. Price Breaks.
 
Print RFQ for all the Suppliers by means of Concurrent Program available in Oracle Apps


Once we print the RFQ , status of RFQ become Printed , and print count will increment for all suppliers .Since we got response from the Office Supplier , Inc Site – OFFICESUPPLIER , Responded field populated for this supplier only . 

  
 
From the RFQ , Select Tools > Copy Doc .It will Create Quotations as shown below.
  1. Enter the Supplier Name for whom you want to create Quote.
  2. Press OK and it will Create Quotation.
  1.  Query for Quotation # 502.
  2. Create Purchase Order Agreement from Quotation by selected Tools > Copy Doc
  3. Press Ok and it will Create Purchase Order Agreement. 
 Query for PO Agreement and Approve it
Once Oracle Purchase agreement got approved , creates the releases for Blanket PO Agreement .In our example PO Agreement Release we have item Test001 , BUT Item Test001 has restricted to be ordered from supplier from “Approval Supplier list”, and as  our Supplier is not part of any Approve Supplier list , system will throw Error.
 
For my test , I just remove the Item Test001 and Approve the Oracle Purchase Order Release and finally did the receipt against PO.
, , , , , , , , , , , , ,

R12 – Period End Closing Checklist in Oracle Apps

Product family
Product Code
Step No
Step name






1
Order Management (OM):




Order Management
ONT
1.1
Complete the sales orders
Order Management
ONT
1.2
Import Sales Order
Order Management
ONT
1.3
Pre-Billing Acceptance
Shipping
WSH
1.4
Complete the shipping transactions
Order Management
ONT
1.5
Prepare the link with AR




Order Management
ONT
1.5.1
Check run of Workflow background engine
Receivables
AR
1.5.2
Run the Invoice Interface/Autoinvoice
Receivables
AR
1.5.3
Verify the Autoinvoice Exceptions






2
Receivables (AR):




Receivables
AR
2.1
Complete all Receivables transactions for the period being closed
Subledger Accounting
SLA
2.2
Create accounting
Subledger Accounting
SLA
2.3
Transfer to GL
Receivables
AR
2.4
Manage the Receivables Period






3
Purchasing (PO):




Purchasing
PO
3.1
Complete all transactions for Oracle Purchasing
Subledger Accounting
SLA
3.2
Create accounting for Payables
Subledger Accounting
SLA
3.3
Transfer to GL
Purchasing/Payables
PO/AP
3.4
Purchasing Period management




Payables
AP
3.4.1
Close the Payables period
Purchasing
PO
3.4.2
Run the Receipt Accruals – Period-End Report
Purchasing
PO
3.4.3
Manage the PO Periods
Payables
AP
3.4.4
Open next AP Period






4
Transactions control:






4.1
Enter all transactions in eBS:




Inventory
INV
4.1.1
Enter the pending cycle counts
Inventory
INV
4.1.2
Check run of the Material Transaction Manager
Inventory
INV
4.1.3
Check run of the Move Transaction Manager 
Inventory
INV
4.1.4
Check run of the Lot Move Transaction Manager    
Inventory
INV
4.1.5
Check run of the Cost manager (mandatory)




Inventory
INV
4.2
Check the pending or in error transactions
Inventory
INV
4.3
Unprocessed Material (resolution required)
Inventory
INV
4.4
Uncosted material transactions (resolution required)
Costing
CST
4.5
Pending LCM Interface Transactions (resolution required)
Work In Process
WIP
4.6
Pending WIP Costing transactions (resolution required)
Shop Floor Management
WSM
4.7
Pending WSM interface (resolution required)






4.7.1
Run the Import WIP Lot Transactions


4.7.2
Run the (WSM) Pending Transactions Report




Shipping
WSH
4.8
Unprocessed Shipping Transactions (by default, resolution required)




Shipping
WSH
4.8.1
Search delivery line with the status Shipped
Shipping
WSH
4.8.2
Run the Interface Trip Stop SRS




Inventory
INV
4.9
Pending material transactions for this period (resolution recommended)
Work In process
WIP
4.10
Pending Shop Floor Move (resolution recommended)
Purchasing
PO
4.11
Pending Receiving Transactions (resolution recommended)
Project Manufacturing
PJM
4.12
Project Manudacturing – Cost Collector




Project Manufacturing
PJM
4.12.1
Run the Cost Collection Manager
Project Manufacturing
PJM
4.12.2
Import the transactions in Projects






5
Cost Management:




Costing
CST
5.1
Cost Of Goods Sold




Costing
CST
5.1.1
Record the Order Management Transactions
Costing
CST
5.1.2
Collect the Revenue Recognition information
Costing
CST
5.1.3
Generate the COGS Recognition events




Costing
CST
5.2
Create accounting
Costing
CST
5.3
Transfer to GL






6
 Inventory Open / Close period:




Inventory
INV
6.1
Open the next period
Inventory
INV
6.2
Close the period
Inventory
INV
6.3
Open or Close several periods in the same time




Inventory
INV
6.3.1
Hierarchy of Organizations
Costing
CST
6.3.2
Open several periods
Costing
CST
6.3.3
Close several periods
, , , ,

SQL Query for Link Between PO-RCV-XLA-AP

Here is the SQL Query for Link Between PO-RCV-XLA-AP.

SELECT DISTINCT
       A.PO_NO,
       A.LINE_NUM,
       A.DIST_NUM,
       A.ITEM_CATEGORY,
       A.IS_CAPITAL,
       A.SEGMENT2 PO_ACCT,
       A.ACCT PO_ACCT_DESC,
       A.UNIT_PRICE,
       A.AMOUNT_ORDERED,
       NVL (
          (SELECT TO_CHAR (RT.TRANSACTION_DATE, ‘yyyy-mm-dd’)
             FROM RCV_TRANSACTIONS RT
            WHERE     RT.PO_HEADER_ID = A.PO_HEADER_ID
                  AND RT.PO_LINE_ID = A.PO_LINE_ID
                  AND RT.PO_LINE_LOCATION_ID = A.LINE_LOCATION_ID
                  AND RT.PO_DISTRIBUTION_ID = A.PO_DISTRIBUTION_ID
                  AND RT.TRANSACTION_TYPE = ‘DELIVER’
                  AND ROWNUM = 1),
          ‘N’)
          RECIEVED_FLAG,
       B.SEGMENT2 SLA_ACCT,
       B.ACCT SLA_ACCT_DESC,
       B.ENTERED_DR,
       B.ENTERED_CR,
       B.ACCOUNTED_DR,
       B.ACCOUNTED_CR,
       C.SEGMENT2 AP_ACCT,
       C.ACCT AP_ACCT_DESC,
       C.AMOUNT,
       A.SHIP_RECEIPT_FLAG,
       A.DIST_RECEIPT_FLAG
  FROM (SELECT POH.SEGMENT1 PO_NO,
               POL.LINE_NUM,
               POLL.LINE_LOCATION_ID,
               POL.PO_LINE_ID,
               POL.PO_HEADER_ID,
               POD.DISTRIBUTION_NUM DIST_NUM,
               POD.CODE_COMBINATION_ID,
               POD.PO_DISTRIBUTION_ID,
               POL.UNIT_PRICE,
               POD.AMOUNT_ORDERED,
               GCC.SEGMENT2,
               GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION (
                  GCC.CHART_OF_ACCOUNTS_ID,
                  GCC.CODE_COMBINATION_ID,
                  ‘.’)
                  ACCT,
               NVL (POLL.ACCRUE_ON_RECEIPT_FLAG, ‘N’) SHIP_RECEIPT_FLAG,
               NVL (POD.ACCRUE_ON_RECEIPT_FLAG, ‘N’) DIST_RECEIPT_FLAG,
               (SELECT SEGMENT1
                  FROM MTL_CATEGORIES_B
                 WHERE CATEGORY_ID = POL.CATEGORY_ID AND ROWNUM = 1)
                  ITEM_CATEGORY,
               HL_PO_UTL_PKG.IS_CAPITAL (POL.CATEGORY_ID) IS_CAPITAL
          FROM PO_HEADERS_ALL POH,
               PO_LINES_ALL POL,
               PO_LINE_LOCATIONS_ALL POLL,
               PO_DISTRIBUTIONS_ALL POD,
               GL_CODE_COMBINATIONS GCC
         WHERE     POH.PO_HEADER_ID = POL.PO_HEADER_ID
               AND POH.PO_HEADER_ID = POD.PO_HEADER_ID
               AND POL.PO_LINE_ID = POD.PO_LINE_ID
               AND POH.PO_HEADER_ID = POLL.PO_HEADER_ID
               AND POL.PO_LINE_ID = POLL.PO_LINE_ID
               AND POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
               AND POD.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
               AND POL.ITEM_ID IS NULL /*AND poh.po_header_id IN
                                       (SELECT * FROM tmp_po_accrue_on_receipt_flag)*/
                                      ) A,
       (SELECT RT.PO_HEADER_ID,
               RT.PO_LINE_ID,
               RT.PO_LINE_LOCATION_ID,
               RT.PO_DISTRIBUTION_ID,
               RT.VENDOR_ID,
               RT.VENDOR_SITE_ID,
               SLA.*
          FROM (SELECT XTE.SOURCE_ID_INT_1,
                       XL.CODE_COMBINATION_ID,
                       XL.ENTERED_DR,
                       XL.ENTERED_CR,
                       XL.ACCOUNTED_DR,
                       XL.ACCOUNTED_CR,
                       GCC.SEGMENT2,
                       GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION (
                          GCC.CHART_OF_ACCOUNTS_ID,
                          GCC.CODE_COMBINATION_ID,
                          ‘.’)
                          ACCT
                  FROM XLA.XLA_AE_HEADERS XH,
                       XLA.XLA_AE_LINES XL,
                       XLA.XLA_TRANSACTION_ENTITIES XTE,
                       XLA.XLA_EVENTS XEA,
                       GL.GL_CODE_COMBINATIONS GCC
                 WHERE     XH.AE_HEADER_ID = XL.AE_HEADER_ID
                       AND XTE.ENTITY_ID = XH.ENTITY_ID
                       AND XL.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
                       AND XEA.EVENT_ID = XH.EVENT_ID
                       AND XH.BALANCE_TYPE_CODE = ‘A’
                       AND XH.JE_CATEGORY_NAME = ‘Receiving’
                       AND XL.ACCOUNTED_DR IS NOT NULL) SLA,
               RCV_TRANSACTIONS RT
         WHERE RT.TRANSACTION_ID = SLA.SOURCE_ID_INT_1(+)
               AND RT.TRANSACTION_TYPE = ‘DELIVER’) B,
       (SELECT AID.DIST_CODE_COMBINATION_ID,
               POD.PO_DISTRIBUTION_ID,
               POD.PO_HEADER_ID,
               POD.PO_LINE_ID,
               POD.LINE_LOCATION_ID,
               GCC.SEGMENT2,
               GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION (
                  GCC.CHART_OF_ACCOUNTS_ID,
                  GCC.CODE_COMBINATION_ID,
                  ‘.’)
                  ACCT,
               AID.AMOUNT
          FROM AP_INVOICE_DISTRIBUTIONS_ALL AID,
               PO_DISTRIBUTIONS_ALL POD,
               GL_CODE_COMBINATIONS GCC
         WHERE     AID.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
               AND AID.DIST_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
               AND AID.LINE_TYPE_LOOKUP_CODE IN (‘ITEM’, ‘ACCRUAL’)) C
 WHERE     A.PO_HEADER_ID = B.PO_HEADER_ID(+)
       AND A.PO_LINE_ID = B.PO_LINE_ID(+)
       AND A.LINE_LOCATION_ID = B.PO_LINE_LOCATION_ID(+)
       AND A.PO_DISTRIBUTION_ID = B.PO_DISTRIBUTION_ID(+)
       AND A.PO_DISTRIBUTION_ID = C.PO_DISTRIBUTION_ID(+);