How to check which concurrent request assign to which responsibility

Hi Folks,

It is very difficult to find out from the front end to which concurrent request is assign to which responsibility.

below is the query to identify which is suitable responsibility for the concurrent request.

SELECT FRT.RESPONSIBILITY_NAME, FRG.REQUEST_GROUP_NAME, FRG.DESCRIPTION ,frt.*

  FROM FND_REQUEST_GROUPS FRG

      ,FND_REQUEST_GROUP_UNITS FRGU

      ,FND_CONCURRENT_PROGRAMS FCP

      ,FND_CONCURRENT_PROGRAMS_TL FCPT

      ,FND_RESPONSIBILITY_TL FRT

      ,FND_RESPONSIBILITY FR

 WHERE     FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID

       AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID

       AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID

       AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID

       AND FCPT.SOURCE_LANG = USERENV('LANG')

       AND FCP.APPLICATION_ID = FCPT.APPLICATION_ID

       AND FCP.CONCURRENT_PROGRAM_ID = FCPT.CONCURRENT_PROGRAM_ID

       AND FR.APPLICATION_ID = FRT.APPLICATION_ID

       AND FR.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID

       AND FRT.SOURCE_LANG = USERENV('LANG')

       AND FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID

       AND FR.APPLICATION_ID = FRG.APPLICATION_ID

       --   AND FCP.CONCURRENT_PROGRAM_NAME = 'OPMTMOPG'  --  YOU CAN PUT THE SHORTNAME HERE

       AND FCPT.USER_CONCURRENT_PROGRAM_NAME  = :Request_name --OR THE USER CONC PROGRAM NAME HERE;

Oracle Apps Miscellaneous Transactions

Miscellaneous Transactions:-

Miscellaneous receipt:- You can do the Miscellaneous transaction to increase On hand Qty of Item from general ledger account in your current organization.

You can also make manual adjustment to the general receiving material from one account  in inventory

Miscellaneous Issue:- You can do the Miscellaneous transaction to decrease On hand Qty of Item  from general ledger account in your current organization.

You can also make manual adjustment to the general receiving material from one account in inventory

Navigate to Miscellaneous Transactions

1.   Enter the date and time of entry for the transaction

2.   Enter a miscellaneous transaction type for the transfer(Issue or Receipt)

3.   Optionally, enter the source of the transaction type

4.   Optionally, enter the general ledger account against which the material is issued or received.

5.   Optionally, indicate if inventory information should be defaulted from the serial number.

To enter the Item Information:- 

1.   Enter an inventory item to issue or receive

2.   Enter a sub inventory and locator

3.   Enter the Lot Number if the item is Lot/Serial Controlled

4.   Enter the Quantity

Save your Work

This will Increase or Decrease On Hand....!!

Oracle Apps :- Diffrent type of Receipt Routing

HI Folks

We have 3 type of Receipt Routing in Oracle Apps

1.     Direct Receiving:-  

It’s a single steps receiving process. Once the Item come in the warehouse, make the receipt and delivery to  sub inventory in one transaction

1.     Steps to perform transaction 

1.    PO is created and sent across to the supplier.

2.    Navigation : Purchasing --> Receiving --> Receipts, search for the expected receipt.

3.    On receiving the receipt information from the supplier the user created the receipt in the system ,and at the time of receipt enter the Sub Inventory and Locator and save the transaction

2.     Standard Receiving:- It’s a 2 Step PO receiving

1st we need to make the receipt and then we need to deliver the material into Sub Inventory

Steps to perform transaction 

4.    PO is created and sent across to the supplier.

5.    Navigation : Purchasing --> Receiving --> Receipts, search for the expected receipt.

6.    On receiving the receipt information from the supplier the user created the receipt in the system

7.    When the physically material delivery to warehouse then the user make another transaction “Receiving transaction” which increase the On Hand Qty.

2.     Inspection  Receiving:- It’s a 3 Step PO receiving

In Inspection receiving we need to do 1 extra step called inspection of the material whether they are OK or Not

Steps to perform transaction 

1.    PO is created and sent across to the supplier.

2.    Navigation: Purchasing --> Receiving --> Receipts, search for the expected receipt.

3.    On receiving the receipt information from the supplier the user created the receipt in the system

4.    When the physically material delivery to inspection area we do the inspection of the material whether they are selected or rejected.

5.    When the physically material delivery to warehouse then the user make another transaction “Receiving transaction” which increase the On Hand Qty. 

Oracle Apps:- Expenditure Organization Is Not Active Error

Hi Folks,

Getting Error While Creating Requisition

Error :-  "Expenditure Organization Is Not Active Error"

Solution :-  

Check the Organization Setup

Navigation > Setup > Organization > Organization

  

The following two Organization Classification should be enabled: 

1. Project Expenditure/Event Organization 

2. Project Task Owning Organization 

Search the Organization in which you are getting error

Check whether below labels are enabled if not

If not then enable it.

Oracle Apps Delete Lock from Serial Number

HI Folks

Below is the query to delete the Lock from the serial number

Sometimes it happen when user unable to find the Serial Number in Transact move Order Status

Cause :- May be the serial number group_mark_id = null , line_mark_id = null, lot_line_mark_id = null, is not Null

Below is the query to Set null for the particular Serial Number

  

update mtl_serial_numbers  msn

   set group_mark_id = null ,

       line_mark_id = null,

       lot_line_mark_id = null,

       last_updated_by = :USER_ID ,

       last_update_date=sysdate

 where current_status = :CURRENT_STATUS

   and serial_number in (:SERIAL_NUMBER )

   and inventory_item_id = :INVENTORY_ITEM_ID

   and not exists (select fm_serial_number

                     from mtl_serial_numbers_temp msnt,

                          mtl_material_transactions_temp mmtt

                    where msnt.fm_serial_number = msn.serial_number

                      and msnt.transaction_temp_id = mmtt.transaction_temp_id

                      and mmtt.organization_id = msn.current_organization_id

                      and mmtt.inventory_item_id = msn.inventory_item_id)

   and not exists  (select fm_serial_number

                      from mtl_serial_numbers_interface  msni,

                           mtl_transactions_interface mti

                     where msni.fm_serial_number = msn.serial_number

                       and msni.transaction_interface_id = mti.transaction_interface_id

                       and mti.inventory_item_id = msn.inventory_item_id

                       and mti.organization_id = msn.current_organization_id)

Change the Oracle Application Color

Hi Folks

Just a simple step and make your apps feel good 

You need to change the profile option only.

Oracle Provide below color

Blaf       

Blue

Khaki

Olive

Purple

Red

Teal

Titanium

·         Search the profile “Java Color Scheme”

·         Select your color and save it .

·         Restart your Oracle Apps . The new Oracle Apps will open.

Oracle Apps Procure to Pay(P2P) Cycle ( Technical )

Procure to Pay Cycle:-

In this Article We will see the Tables involved in P2P cycle.

Purchase Requisition

1)po_requisition_headers_all
2)po_requisition_lines_all
3)po_req_distributions_all

Note: requisition_header_id link between po_requisition_headers_all and po_requisition_lines_all
requisition_line_id link between po_requisition_lines_all and po_req_distributions_all

Purchase order

1)po_headers_all
2)po_lines_all
3)po_distributions_all
4)po_line_locations_all

Note: po_header_id is the link between all these tables

Receipt

1)rcv_shipment_headers
2)rcv_shipment_lines
3)rcv_transactions

Note: shipment_header_id link between rcv_shipment_headers and rcv_shipment_line po_header_id   link between rcv_shipment_headers and rcv_transaction

Invoices

1)ap_invoices_all
2)ap_invoice_distributions_all

3)ap_checks_all

4)ap_invoice_payments_all

5)ap_payment_schedules_all

Note: invoice_id link between ap_invoices_all and ap_invoice_distributions_all

GL Transfer

1)gl_periods
2)gl_period_status
3)gl_set_of_books