Friday 7 September 2012

Miscellaneous receipts API in oracle apps

begin
       ar_receipt_api_pub.create_misc
                 (p_api_version            => 1.0,
                  p_init_msg_list          => fnd_api.g_true,
                  p_commit                 => fnd_api.g_true,
                  p_validation_level       => fnd_api.g_valid_level_full,
                  x_return_status          => l_return_status,
                  x_msg_count              => l_msg_count,
                  x_msg_data               => l_msg_data,
                  p_currency_code          => 'GBP',
                  p_amount                 => 500,
                  p_receipt_date           => SYSDATE,
                  p_gl_date                => SYSDATE,
                  p_receipt_method_id      => 2496,
                  p_activity               => 'Miscellaneous Cash',
                  p_misc_receipt_id        => l_cr_id ,
                  p_receipt_number         => l_receipt_number, 
                  p_receivables_trx_id     => 2219       
                  );     
                 
      EXCEPTION WHEN OTHERS
                   THEN
                      fnd_file.put_line(fnd_file.log,'RECEIPT API FAILED @ WHEN OTHERS - '||substr(SQLERRM,1,90));                 
                                                                                                    
      END;    
Posted by at

7 comments:

  1. Unknown18 September 2016 at 06:54

    Hello Anil,

    What is API i can use to create Inventory Miscellaneous transaction from specific LOT.

    Thanks,
    Mohamed Ibrahim

    ReplyDelete
  2. Anil M19 September 2016 at 01:42

    There is no API, use mtl_transactions_interface for Miscellaneous Transaction.
    And Call inv_txn_manager_pub.process_Transactions API for processing the record from the interface table

    ReplyDelete
  3. Unknown19 September 2016 at 02:53

    Thanks Anil for your update
    I used mtl_transactions_interface and mtl_transaction_lot_interface
    then i call the below request
    v_request_id := APPS.FND_REQUEST.SUBMIT_REQUEST ('INV',
    'INCTCM'
    );
    and it works with me.
    Anything is wrong with the above scenario ?

    Thanks,
    Mohamed Ibrahim

    ReplyDelete
  4. Anil M19 September 2016 at 02:58

    Process transaction interface(INCTCM) and nv_txn_manager_pub.process_Transactions both are same!

    ReplyDelete
  5. Unknown19 September 2016 at 03:18

    Thanks Anil

    ReplyDelete
  6. Rajs9 April 2017 at 05:09

    Here my condition is 50-75 API calls will be invoked in each given time, this happens very continuelsy. Please let me know if there is some alternative to process it faster.

    Thanks
    Jiji Thomas

    ReplyDelete
  7. Anonymous15 February 2019 at 07:01

    how do you code the creation of batches associated with the misc receipts created with the API?

    ReplyDelete

Subscribe to: Post Comments (Atom)