0 Replies Latest reply on Dec 9, 2014 6:03 PM by mlang

    Pending receiving transactions into Inventory

    mlang

      I hope someone can help on this.

       

      We have a 3rd party WMS that feeds stock receipts back into Oracle to create receipts against purchase releases.  We had an update to 11.5.10.2 a while ago and, since then, these receipts haven't been creating.  That's not a huge thing really, because there's not a huge number and we need to keep an eye on stock purchases anyway, but it's really frustrating.

       

      It looks as if the receipt details are coming in, but not being processed.  I can view them in Transaction Status Summaries as pending transactions, but as you can't submit from that screen I still have to do it by hand.

       

      I was wondering if the RCV: Processing Mode profile had been tweaked between versions and causing a clash.  We currently have the interface setting the processing mode to IMMEDIATE, whereas our profile default is set to On-Line.  Does the IMMEDIATE code clash with On-line here, or does IMMEDIATE not automatically set off RVCTP?

       

      We've got a similar import in for receipting internal orders and that's set to BATCH - that one works ok.

       

      Our interface sql looks like this...

       

      INSERT INTO RCV_TRANSACTIONS_INTERFACE

              (

                  interface_transaction_id

                  ,group_id

                  ,last_update_date

                  ,last_updated_by

                  ,creation_date

                  ,created_by

                  ,last_update_login

                  ,transaction_type

                  ,transaction_date

                  --,primary_unit_of_measure

                  ,processing_status_code

                  ,processing_mode_code

                  ,transaction_status_code

                  ,quantity

                  ,unit_of_measure

                  ,uom_code

                  ,item_num

                  ,item_id

                  ,po_header_id

                  ,po_release_id

                  ,po_line_id

                  --,use_mtl_serial

                  ,auto_transact_code

                  ,receipt_source_code

                  ,vendor_id

                  ,vendor_site_id

                  ,source_document_code

                  ,routing_header_id

                  ,document_num

                  ,document_line_num

                  ,destination_type_code

                  ,header_interface_id

                  ,item_revision

                  ,to_organization_id

                  ,deliver_to_location_id

                  ,location_id

                  ,subinventory

                  ,validation_flag

              )

              VALUES

              (

                  rcv_transactions_interface_s.NEXTVAL

                  ,p_group_id

                  ,TO_DATE(p_timestamp,'YYYY-MM-DD HH24:MI:SS')

                  ,fnd_global.user_id

                  ,SYSDATE

                  ,fnd_global.user_id

                  ,fnd_global.login_id

                  ,'RECEIVE'

                  ,SYSDATE

                  --,'Each'

                  ,'PENDING'

                  ,'IMMEDIATE'

                  ,'PENDING'

                  ,p_quantity

                  ,p_unit_of_measure

                  ,p_uom_code

                  ,p_item_number

                  ,p_inventory_item_id

                  ,p_po_header_id

                  ,p_po_release_id

                  ,p_po_line_id

                  --,rec_receiving_ib_line.serial_no

                  ,'DELIVER'

                  ,'VENDOR'

                  ,p_vendor_id

                  ,p_vendor_site_id

                  ,'PO'

                  ,p_routing_header_id

                  ,p_bpa_number

                  ,p_line_number

                  ,'INVENTORY'

                  ,p_header_interface_id

                  ,NULL

                  ,p_ship_to_org_id

                  ,p_line_location_id

                  ,p_line_location_id

                  ,p_recv_warehouse_name

                  ,'Y'

              );

       

      and for the headers

       

      INSERT INTO RCV_HEADERS_INTERFACE

              (

                  header_interface_id,

                  group_id,

                  processing_status_code,

                  receipt_source_code,

                  transaction_type,

                  auto_transact_code,

                  last_update_date,

                  last_updated_by,

                  last_update_login,

                  creation_date,

                  created_by,

                  receipt_num,

                  vendor_id,

                  vendor_site_id,

                  expected_receipt_date,

                  ship_to_organization_id,

                  location_id,

                  validation_flag

              )

              VALUES

              (

                  p_header_interface_id,

                  p_group_id,

                  'PENDING',

                  'VENDOR',

                  'NEW',

                  'DELIVER',

                  TO_DATE(p_timestamp,'YYYY-MM-DD HH24:MI:SS'),

                  fnd_global.user_id,

                  fnd_global.login_id,

                  SYSDATE,

                  fnd_global.user_id,

                  p_receipt_number,

                  p_vendor_id,

                  p_vendor_site_id,

                  TO_DATE(p_receipt_date,'YYYY-MM-DD HH24:MI:SS'),

                  p_ship_to_org_id,--142,

                  p_line_location_id,--143,

                  'Y'

              );

       

      Any thoughts or help gratefully received.

       

      Ta

      Matt