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