Clarity

 View Only
  • 1.  Invalid Transaction - "Invalid resource code" Error

    Posted Jul 18, 2011 09:01 PM
    Hi All,

    When posting the timesheets, we got the "Invalid resource code" error in the Invalid Transactions for a resource. Error number in IMP_TRANSACTIONIMPORT table is 400.
    Can anyone specify what it is and what should i check

    I have checked and confirmed that the following things are correct :
    - resource is financially enabled
    - the resource role in there in the rate matrix.
    - role/resource is active
    - project is financially enabled and setup correctly.
    - chargecode is correct
    - the role in IMP_TRANSACTIONIMPORT for the resource against the project is correct.

    Rgds,
    Akhil


  • 2.  RE: Invalid Transaction - "Invalid resource code" Error

    Posted Jul 19, 2011 12:53 AM
    "Invalid resource code" means that the the resource ID or Unique name is currently not valid.
    The invalid transactions should give the resource name. Verify that the unique name of the resource is the same as the imp_transcationsimport.resource_code.

    Martti K.


  • 3.  RE: Invalid Transaction - "Invalid resource code" Error

    Posted Jul 19, 2011 06:59 PM
    I have verified and the IDs are exactly the same.


  • 4.  RE: Invalid Transaction - "Invalid resource code" Error
    Best Answer

    Posted Jul 19, 2011 07:57 PM
    did u check if there is any space in the id mentioned ?

    NJ


  • 5.  RE: Invalid Transaction - "Invalid resource code" Error

    Posted Jul 20, 2011 12:10 AM
    The way to deal with the invalid transactions is to identify the timeentry in question and to make an adjustment to corrects any errors or deficiencies.
    That creates a new transaction with the correct data. When you see that in the "Invalids" you can delete the one with the error.

    In your case do that.
    It is likely that you cannot create and adjustment timesheet with exactly the same entries, so you have to create first create a dummy one with some difference, post that and then another with the correct data and post that.
    Then you should see only one new transaction in the Invalids. If that is processed properly with Transactions post financials, delete the transaction with the error.

    If you instead see two identical with the same error it is either a bug or system corruption and open a case with support

    Martti K.


  • 6.  RE: Invalid Transaction - "Invalid resource code" Error

    Posted Jul 26, 2011 04:01 PM
    Tried everything but nothing seems to fix it. Will probably raise it with support.

    Rgds,
    Akhil


  • 7.  RE: Invalid Transaction - "Invalid resource code" Error

     
    Posted Aug 03, 2011 02:53 PM
    Hi Akhil,

    If you raised an issue with Support for this was there a resolution you can share with the community? If so also please mark the post as Solution Accepted.

    Thanks!
    Chris


  • 8.  RE: Invalid Transaction - "Invalid resource code" Error

    Posted Oct 11, 2012 04:46 PM
    If this issue was every resolved, would like to hear about it. Checked support site and could not find anything on the subject. Our IT team will have to submit a case in the meantime, as we are having what appears to be the same exact problem.

    We're on 12.0.6.5471 generic_015 001.

    Dale


  • 9.  RE: Invalid Transaction - "Invalid resource code" Error

    Posted Feb 19, 2013 08:16 AM
    Hit that problem myself.
    In my case the cause was that there was no matching row in the matrix.
    Once I added a row where the resource ID mached the resource in the new transaction no more error 400 and the transaction could be posted further to WIP.


    Martti K.


  • 10.  RE: Invalid Transaction - "Invalid resource code" Error

    Posted May 31, 2023 10:54 AM

    check resource_code for invisible characters in PAC_MNT_RESOURCES.