1 Reply Latest reply: May 22, 2013 4:27 AM by Bakkar75 RSS

    RMA Receiving gives Error - An error occurred while trying find a valid per

    Bakkar75
      Hi,
      We are in R12 Instance.

      We are doing a RMA receipt for a Lot controlled Item.

      In the Receiving transactions form details are not saving.

      The Log file of the Receiving Transaction Processor gives below error.

      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: First node
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: Construct the logical I/C sales issue/return of from_org_id
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: l_index for l_mtl_trx_tbl = 2
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: ******transaction_source_id: ******14402
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: ******index: ******2
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: First node
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: Construct the logical I/C receipt/sales return of from_org_id
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: l_index for l_mtl_trx_tbl = 3
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: Enter get_acct_period
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: p_organization_id = 105
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: GET_ACCT_PERIOD: no_data_found error
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: SQL Error: ORA-01403: no data found
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: get_acct_period returns error with org id = 124
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: x_msg_data =
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: create_logical_transactions: Expected Error, l_progress = 350
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: SQL Error: User-Defined Exception
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: Return Status :E
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: AFter calling create_logical_transactions
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: create_logical_transactions returns error
      [17-MAY-13 17:57:36] INV_LOGICAL_TRANSACTIONS_PUB: create_logical_trx_wrapper error exception, l_progress = 90


      I checked the Inventory Period. Its already open.
      Regards