Current Position:Home > Oracle FA Asset Transfer API Error FA_DISTRIBUTION_PVT.units_in_sync return

Oracle FA Asset Transfer API Error FA_DISTRIBUTION_PVT.units_in_sync return

Update:11-30Source: network consolidation
Advertisement
Hi All,
I am using below code to transfer the asset from one location to another and stuck the error message as below. Can any one help me out of this.
TRANSFER failed!.
Error: ORA-01403: no data found
Error: Error: function FA_DISTRIBUTION_PVT.units_in_sync returned failure
Error: User-Defined Exception
Error: Error: function FA_DISTRIBUTION_PVT.do_distribution returned failure
Error: Error: function FA_TRANSFER_PUB.do_transfer returned failure
*****Code****
declare
l_return_status                                    varchar2(1);
l_msg_count                                         number:= 0;
l_msg_data                                              varchar2(4000);
l_trans_rec                                         fa_api_types.trans_rec_type;
l_asset_hdr_rec                                    fa_api_types.asset_hdr_rec_type;
l_asset_dist_tbl                                    fa_api_types.asset_dist_tbl_type;
temp_str                                              varchar2(512);
begin
fnd_profile.put('PRINT_DEBUG', 'Y');
dbms_output.enable(1000000);
fa_srvr_msg.init_server_message;
fa_debug_pkg.initialize;
-- fill in asset information
l_asset_hdr_rec.asset_id := 100001;
l_asset_hdr_rec.book_type_code := 'IAEA MT FA BOOK';
-- transaction date must be filled in if performing
-- prior period transfer
-- l_trans_rec.transaction_date_entered := to_date('01-JAN-1999 10:54:22','dd-mon-yyyy hh24:mi:ss');
l_trans_rec.transaction_date_entered := to_date('21-DEC-2012 10:54:22','dd-mon-yyyy hh24:mi:ss');
l_asset_dist_tbl.delete;
fill in distribution data for existing distribution lines
affected by this transfer txn. Note: You need to fill in
only affected distribution lines.
For source distribution, you must fill in either existing
distribution id or 2 columns(expense_ccid,location_ccid) or
3-tuple columns(assigned_to,expense_ccid,and location_ccid)
depending on the makeup of the particular distribution
of the asset.
l_asset_dist_tbl(1).distribution_id                          := 396330;
l_asset_dist_tbl(1).transaction_units                          := 1;
l_asset_dist_tbl(1).assigned_to                          := 2948;
l_asset_dist_tbl(1).expense_ccid                          := 2606;
l_asset_dist_tbl(1).location_ccid                          := 5255;
either above 2 lines or below 4 lines must be provided
for source distribution:
l_asset_dist_tbl(1).transaction_units := -2;
l_asset_dist_tbl(1).assigned_to := 11;
l_asset_dist_tbl(1).expense_ccid :=15338;
l_asset_dist_tbl(1).location_ccid := 3; */
--fill in dist info for destination distribution
l_asset_dist_tbl(2).transaction_units                               := 1;
l_asset_dist_tbl(2).assigned_to                                    := NULL;
l_asset_dist_tbl(2).expense_ccid                                    :=2606;
l_asset_dist_tbl(2).location_ccid                                    := 5255;
l_asset_dist_tbl(2).transaction_units                               := 1;
l_asset_dist_tbl(2).assigned_to                                    := 2948;
l_asset_dist_tbl(2).expense_ccid                                    := 2606;
l_asset_dist_tbl(2).location_ccid                                    := 5272;
l_trans_rec.who_info.last_updated_by                          := FND_GLOBAL.USER_ID;
l_trans_rec.who_info.last_update_login                          := FND_GLOBAL.LOGIN_ID;
FA_TRANSFER_PUB.do_transfer(
                         p_api_version                               => 1.0,
                         p_init_msg_list                          => FND_API.G_FALSE,
                         p_commit                                    => FND_API.G_FALSE,
                         p_validation_level                     =>FND_API.G_VALID_LEVEL_FULL,
                         p_calling_fn                               => NULL,
                         x_return_status                          => l_return_status,
                         x_msg_count                               => l_msg_count,
                         x_msg_data                               => l_msg_data,
                         px_trans_rec                               => l_trans_rec,
                         px_asset_hdr_rec                          => l_asset_hdr_rec,
                         px_asset_dist_tbl                          => l_asset_dist_tbl);
          if (l_return_status != FND_API.G_RET_STS_SUCCESS) then
               dbms_output.put_line('TRANSFER failed!.');
               l_msg_count := fnd_msg_pub.count_msg;
               if (l_msg_count > 0) then
                    temp_str := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST,
                    fnd_api.G_FALSE),1,512);
                    dbms_output.put_line('Error: '||temp_str);
                    for I in 1..(l_msg_count -1) loop
                         temp_str :=
                         substr(fnd_msg_pub.get(fnd_msg_pub.G_NEXT,
                         fnd_api.G_FALSE),1,512);
                         dbms_output.put_line('Error: '||temp_str);
                    end loop;
               end if;
          else
               dbms_output.put_line('TRANSFER completed successfully!');
               dbms_output.put_line('THID = ' ||
               to_char(l_trans_rec.transaction_header_id));
          end if;
fnd_msg_pub.delete_msg();
end;
Thanks
Tajinder Singh

The Best Answer

Advertisement
Hi,
Please do the following procedure.
There were 2 hidden segments in the accounting flexfield.
All segments of the accounting flexfield must be displayed, though they can use default values.
When doing an asset transfer, the system must be able to create all values for the new
distribution, including the complete CCID.
Display the segement and populate or provide a default value for usage on those segments so they can populate at build.
Regards,
Raju.
  • Oracle FA Asset Transfer API Error FA_DISTRIBUTION_PVT.units_in_sync return Update:11-30

    Hi All, I am using below code to transfer the asset from one location to another and stuck the error message as below. Can any one help me out of this. TRANSFER failed!. Error: ORA-01403: no data found Error: Error: function FA_DISTRIBUTION_PVT.units

  • Oracle 6i Repository Internal API Error 25012 Update:11-30

    I am running into an RME-00020 Internal API error when I try to fire up designer and do anything. I followed the standard install on a windows 2000 Pro laptop, installed the repository and ran into this. The Oracle error is ORA-00600 and the internal

  • Error AU133 received while posting asset transfer Update:10-11

    Hi Friends, While posting asset transfer to affiliated co. (t.code ABT1N) got error message "Account 'Clear.revenue sale to affil.company' could not be found for area 01". We have already maintained GL A/c in Ao90 in tab 'Clear.revenue sale to a

  • Error While Running Depreciation in Oracle Fixed Asset Update:10-11

    We have uploaded assets in Oracle Fixed Asset from old system successfully. Now we were to Run depreciation for the first time and the first process Generate Accounts runs with error, APP-OFA-48400: ORA-06550: line 1, column 7: PLS-00306: wrong numbe

  • ABT1N-Getting Error while doing Intercompany asset transfer Update:10-11

    Hi, Due to a merger of two comapny codes, my clients needed to make an intercompany asset transfer (transaction code ABT1N), with company code 099 as the sending company code and 200 as the receiving company code). However they got the following erro

  • Getting error while doing Intercompany asset transfer Update:10-11

    This is the first time that they are doing an intercompany asset transfer in our client. Intracompany asset transfers were done in the past. While doing an intercompany transfer, an error is popping up as given below.: Account 'Contra account: Acquis

  • ABT1N  Intercompany Asset Transfer  error: AA390   T type 230 not possible Update:10-11

    Dear experts, I am trying to post an intercompany asset transfer with trx code ABT1N but when simulating the error code Transaction type 230 not possible (posting to affiliated company) appears. This is the explanation of the error: Message no. AA390

  • Error in Asset Transfer Update:10-11

    Hi Sappers: I am facing the following issue in intercompany asset transfer: Asset numbers: 910000001608 and 910000001609 need to be transferred. The transfer will be moving the assets from company code 9001/cost center 1100105202 to company code 2001

  • Error during asset transfer: No depr areas for receiving revenue Update:10-11

    Hi.... when I am posting an asset transfer transaction [Inter company transfer with transfer method 2: Net method] and simulating, I am getting an error message stating "No Depr areas for receiving the revenue". Kindly help me solve this error.

  • Asset transfer error Update:10-11

    we use abt1n to transfer asset, old asset apc value is 24425.64 USD, ordinary depreciation is 6106.4, change column is 814.19-, net book value is 18319.24,(fiscal year start), 17505.05(posted value). abt1n we choose gross meth. and we use NBV from ar