0 Replies Latest reply on Apr 10, 2015 12:37 PM by user8955167

    Creating Po receipts

    user8955167

      Hi,

       

      I am trying to generate the Po receipts in the oracle apps r12 .

       

      Steps followed :

      Inserted the data successfully in the interface table

      RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE

       

      INSERT INTO rcv_headers_interface

      (header_interface_id,

      GROUP_ID,

      processing_status_code,

      receipt_source_code,

      transaction_type,

      auto_transact_code,

      test_flag,

      last_update_date,

      last_updated_by,

      creation_date,

      created_by,

      expected_receipt_date,

      comments,

      validation_flag,

      transaction_date,

      org_id

      )

      VALUES (11201,

      3645,

      'BATCH',

      'VENDOR',

      'RECEIVE',

      NULL,

      'N',

      SYSDATE,

      fnd_global.user_id,

      SYSDATE,

      fnd_global.user_id,

      SYSDATE,

      'ray test',

      'Y',

      SYSDATE,

      84

      );

       

       

      INSERT INTO rcv_transactions_interface

      (interface_transaction_id,

      header_interface_id,

      processing_status_code,

      transaction_date,

      GROUP_ID,   

      last_update_date,

      last_updated_by,

      creation_date,

      created_by,

      transaction_type,

      processing_mode_code,

      transaction_status_code,

      quantity,

      to_organization_id,

      source_document_code,

      po_header_id,

      po_line_id,

      po_line_location_id,

      po_distribution_id,

      comments

      )

      VALUES (202017,

      11201,

      'PENDING',

      SYSDATE,

      3645,

      SYSDATE,

      fnd_global.user_id,

      SYSDATE,

      fnd_global.user_id,

      'RECIEVE',

      'BATCH',

      'PENDING',

      4,

      84,

      'VENDOR',

      23,

      22,

      22,

      22,

      'RAY TEST'

      );

       

       

      +++++++++++++++++++++++

      Submit the program succesfully :

      1.Receiving Transaction Processor

       

      2.Landed Cost Integration Manager

      3.Shipments Interface Import programs

       

      But the output is coming as 0.

       

       

      I am new to the Oracle apps can anyone help .