6 Replies Latest reply: May 23, 2013 7:26 AM by 999466 RSS

    How to upload Mass addition Asset through backend.....

    Muthu
      Hello all,

      I am going to upload asset through backend...

      I updated on FA_MASS_ADDITIONS table. But some fields data not populating..like EXPENSE_CODE_COMBINATION_ID, LOCATION_ID.....

      Is that right what I'm doing..?

      Please guide me to achieve my task..

      I will be happy, If you mention what are all the fields are mandatory...

      Thanks and Regards,
      Muthu
        • 1. Re: How to upload Mass addition Asset through backend.....
          Octopus Rex
          Hello.

          See the chapter FA_MASS_ADDITIONS Interface Table* in the Oracle Assets User Guide.


          Hope this helps.

          Octavio
          • 2. Re: How to upload Mass addition Asset through backend.....
            Muthu
            Hi Octopus,

            Thank you for your reply....

            I have prepared sql loader command with below fields.

            MASS_ADDITION_ID " FA_MASS_ADDITIONS_S.nextval " ,
            TAG_NUMBER ,
            DESCRIPTION ,
            ASSET_CATEGORY_ID ,
            BOOK_TYPE_CODE ,
            FIXED_ASSETS_COST ,
            PAYABLES_UNITS ,
            FIXED_ASSETS_UNITS ,
            PAYABLES_CODE_COMBINATION_ID ,
            EXPENSE_CODE_COMBINATION_ID ,
            PAYABLES_COST ,
            QUEUE_NAME ,
            POSTING_STATUS ,
            LOCATION_ID ,
            LAST_UPDATE_DATE "SYSDATE" ,
            LAST_UPDATED_BY ,
            LAST_UPDATE_LOGIN ,
            DATE_PLACED_IN_SERVICE "SYSDATE" ,
            DEPRECIATE_FLAG ,
            ASSET_TYPE ,
            CREATED_BY ,
            CREATION_DATE "SYSDATE" ,
            ACCOUNTING_DATE DATE ,
            ASSET_ID ,
            ASSET_NUMBER

            Data file:

            ,112233,Test Assets,1,CORPORATE,11000,1,1,22022,22023,11000,NEW,NEW,1,sysdate,1132,1132,sysdate,Y,CAPITALIZED,1132,sysdate,22-Dec-11,100002,Test asset 1

            Log file:

            Table "FA"."FA_MASS_ADDITIONS", loaded from every logical record.
            Insert option in effect for this table: REPLACE
            TRAILING NULLCOLS option in effect

            Column Name Position Len Term Encl Datatype
            ------------------------------ ---------- ----- ---- ---- ---------------------
            MASS_ADDITION_ID FIRST * , O(") CHARACTER
            SQL string for column : " FA_MASS_ADDITIONS_S.nextval "
            TAG_NUMBER NEXT * , O(") CHARACTER
            DESCRIPTION NEXT * , O(") CHARACTER
            ASSET_CATEGORY_ID NEXT * , O(") CHARACTER
            BOOK_TYPE_CODE NEXT * , O(") CHARACTER
            FIXED_ASSETS_COST NEXT * , O(") CHARACTER
            PAYABLES_UNITS NEXT * , O(") CHARACTER
            FIXED_ASSETS_UNITS NEXT * , O(") CHARACTER
            PAYABLES_CODE_COMBINATION_ID NEXT * , O(") CHARACTER
            EXPENSE_CODE_COMBINATION_ID NEXT * , O(") CHARACTER
            PAYABLES_COST NEXT * , O(") CHARACTER
            QUEUE_NAME NEXT * , O(") CHARACTER
            POSTING_STATUS NEXT * , O(") CHARACTER
            LOCATION_ID NEXT * , O(") CHARACTER
            LAST_UPDATE_DATE NEXT * , O(") CHARACTER
            SQL string for column : "SYSDATE"
            LAST_UPDATED_BY NEXT * , O(") CHARACTER
            LAST_UPDATE_LOGIN NEXT * , O(") CHARACTER
            DATE_PLACED_IN_SERVICE NEXT * , O(") CHARACTER
            SQL string for column : "SYSDATE"
            DEPRECIATE_FLAG NEXT * , O(") CHARACTER
            ASSET_TYPE NEXT * , O(") CHARACTER
            CREATED_BY NEXT * , O(") CHARACTER
            CREATION_DATE NEXT * , O(") CHARACTER
            SQL string for column : "SYSDATE"
            ACCOUNTING_DATE NEXT * , O(") CHARACTER
            SQL string for column : "SYSDATE"
            ASSET_ID NEXT * , O(") CHARACTER
            ASSET_NUMBER NEXT * , O(") CHARACTER

            value used for ROWS parameter changed from 64 to 39
            Record 1: Discarded - all columns null.

            Table "FA"."FA_MASS_ADDITIONS":
            1 Row successfully loaded.
            0 Rows not loaded due to data errors.
            0 Rows not loaded because all WHEN clauses were failed.
            1 Row not loaded because all fields were null.


            Data availabe in FA_MASS_ADDITIONS.

            But while running *Mass Additions Create Report*, no data are getting import...

            Please let me know where am missing...

            Thanks and Regards,
            Muthu
            • 3. Re: How to upload Mass addition Asset through backend.....
              Octopus Rex
              Hi Muthu.

              The Mass Additions Create Report is used to review mass additions created from invoice distribution lines in Payables for the Book you choose. The report provides you with a complete audit trail of the mass additions created by Payables.

              Octavio
              • 4. Re: How to upload Mass addition Asset through backend.....
                Muthu
                Hi Octopus,

                Thank you for your information....

                Records are appearing in FA Mass addition (Mass addition > Prepare Mass addition)

                But while post the Mass addition, Its completed with error which I have been attached below...

                ---------------------------------------------------------------------------
                Assets: Version : 12.0.0

                Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                FAMAPT module: Mass Additions Post
                ---------------------------------------------------------------------------

                Current system time is 09-FEB-2013 16:47:02

                ---------------------------------------------------------------------------






                GOVT_ENTERPRISE Mass Additions Posting Execution Report 09/02/2013 16:47:02

                Book: GOVT_BOOK
                Request ID: 493594
                Please enter a Date Placed In Service that falls in the current or a prior period.
                Mass Addition ID: 4 ==> ** Failed **
                Number of successes: 0
                Number of failures: 1
                Module Mass Additions Post ended with error


                ---------------------------------------------------------------------------
                Executing request completion options...


                Finished executing request completion options.
                Concurrent program returned no reason for failure.

                ---------------------------------------------------------------------------
                Concurrent request completed
                Current system time is 09-FEB-2013 16:48:11

                ---------------------------------------------------------------------------

                Please guiide me, what could be the issue?

                Thanks and Regards,
                Muthu

                Edited by: Muthu on Feb 9, 2013 4:54 PM
                • 5. Re: How to upload Mass addition Asset through backend.....
                  Muthu
                  I fixed the issue....

                  Its due to open period..

                  Regards,
                  Muthu
                  • 6. Re: How to upload Mass addition Asset through backend.....
                    999466
                    Got it inserted. I was running the program from view-->requests, when I ran the program from Menu, the record got inserted succesfully.Thank you.