FA-分配行重分配报错【APP-OFA-48313】

FA-重分配行报错

已存在行只能分多次转移调整

Ref1：

APP-OFA-48313 You Cannot Create Identical Distribution Lines with Transfer (Doc ID 336894.1)

APPLIES TO:

Oracle Assets - Version 11.5.10.0 and later
Information in this document applies to any platform.

GOAL

How do I transfer units (or fractions of a unit) from multiple distributions?

SOLUTION

This will have to be done in several transaction as there can only be 1 transfer entered at a time.

Example 1:

The assignment looks a follows:

Units Distribution
.25    1
.25    2
.25    3
.25    4

You want to move .15 from distribution 1 to 3 on to distribution 4. So you do your first transfer:

In/Out Units Distribution
-.15      .25   1
            .25   2
            .25   3
.15       .25   4

and then save. Go back into the assignments window and do the second transfer:

In/Out Units Distribution
           .1     1
-.15     .25   2 
           .25   3
 .15     .4     4

and then save. Go back into the assignments window and do the third transfer:

In/Out Units Distribution
           .1     1
           .1     2
-.15     .25   3
  .15    .55   4

and save. When you go back and review the distributions it will now look like this:

Units Distribution
.1      1 
.1      2
.1      3
.7      4

Ref2：

Unable To Add Units To The Same Distribution In The Assignments Form (Doc ID 267007.1)

APPLIES TO:

Oracle Assets - Version 11.5.10.0 and later
Information in this document applies to any platform.
FAXASSET - Asset Workbench
 

SYMPTOMS

When attempting to add additional units with the same distribution information
(expense account and location), receive the error:

APP-OFA-48313 You cannot create identical distribution lines.

CHANGES

CAUSE

The applications does not allow two lines to have the same distribution.

SOLUTION

Change the units in the Asset Workbench > Asset Details window to new # of units,
than go to the Assignments window.

1) Assign the additional X units to the same expense account but a different location.
Now there will be 2 rows one with original # of units and another with X units.

2) Save.

3) Than put -X in the unit change column of the row to which X units were assigned,
and X in the unit change column of the original distribution.

4) Save. Now you should have one distribution again with the correct total units.

Ref3：

How To Transfer Units from Multiple Distributions to a Single Distribution Without APP-OFA-48395, APP-OFA-48392? (Doc ID 1269754.1)

APPLIES TO:

Oracle Assets - Version 11.5.10.2 to 12.2.6 [Release 11.5 to 12.2]
Information in this document applies to any platform.

GOAL

Is it possible to transfer units (or fractions of a unit) from multiple distributions to a single distribution?

Example 1:
----------
An asset has 1 unit but the assignment is split between 6 employees with fractional units as follows: 5 *0.17 + 1* 0.15.
When attempting to assign the asset to only one employee (transfer all fractional units to a single distribution), the following message appears:

APP-OFA-48392: The asset_dist_tbl structure contains invalid transaction units.

Example 2:
-----------

Trying to transfer multiple assignment lines into a new assignment line.

Asset has 3 lines with units:
.25 = 01.110.7360.0000.000
.5 = 01.120.7360.0000.000
.25 = 01.130.7360.0000.000

Try to transfer all into new single 1 unit line = 01.111.7360.0000.000

The following message appears:

APP-OFA-48395: Program exited with errors:

The asset_dist_tbl structure contains invalid transaction units.

Possible causes are:

1.  Null or zero units were entered
2.  Positive or negative units were entered incorrectly
3.  Not enough units were entered

SOLUTION

Only ONE distribution (assignment line) can be directly transferred to one or more new distributions, NOT vice versa.  This is standard and current functionality.

Reference: Note 213593.1 Multidistributed Asset Transfer into One Distribution Line Fails with APP-OFA-48392: FA_INVALID_TXN_UNITS

An Enhancement Request has been raised for this issue:

ER Bug:9484636 ERROR APP-OFA-48392 WHEN TRANSFER MULTIDISTRIBUTION TO ONE DISTIBUTIION LINE

The following workaround can be used:

In order to be able to transfer fractional units from multiple distributions to a single distribution, and overcome restrictions like 'APP-OFA-48313 You cannot create identical distribution lines', please follow the steps below.

1.  Change the number of units in the Asset Workbench > Asset Details window to 2 units.  Save.

2.  Go to the Assignments screen and add a new distribution line for one unit (with the new distribution desired).  Save.

3.  Go back to the Asset Workbench > Asset Details window and change back the number of units for the asset to 1 unit.  Save.

4.  Go back to the Assignments screen and null out the old fractional distributions (put -X in the unit change column of the rows where X is the needed number of units to change).  Save.

Now the asset will have the entire unit assigned to a single distribution.

Ref4：

Transfer Error APP-OFA-48313 You Cannot Create Identical Distribution Lines (Doc ID 1663571.1)

APPLIES TO:

Oracle Assets - Version 11.5.10.2 to 12.2.6 [Release 11.5 to 12.2]
Information in this document applies to any platform.
This document replaces duplicate document 336894.1, which has been deleted.

SYMPTOMS

When performing a transfer in Asset Assignments, the following error occurs:

Error Message:
APP-OFA-48313:  You cannot create identical distribution lines

Example 1:

NOTE:  This is attempting to transfer to new Line3 from old Line1, and Line2 and Line3 use the same account and location.

 Example 2:

The assignment looks a follows:

Units Distribution
.25 1
.25 2
.25 3
.25 4

You want to move .15 from distribution 1 to 3 on to distribution 4.

CAUSE

This is working as intended as Oracle Assets does not allow a duplicate assignment line on an asset.

SOLUTION

Transfer the line to Line2 directly.

Example 1:

NOTE:  Set "Unit Change" to "1" on Line2 directly.

Example 2:

Perform your first transfer:

In/Out Units Distribution
-.15 .25 1
.25 2
.25 3
.15 .25 4

and then save. Go back into the assignments window and do the second transfer:

In/Out Units Distribution
.1 1
-.15 .25 2
.25 3
.15 .4 4

and then save. Go back into the assignments window and do the third transfer:

In/Out Units Distribution
.1 1
.1 2
-.15 .25 3
.15 .55 4

and save. When you go back and review the distributions it will now look like this:

Units Distribution
.1 1
.1 2
.1 3
.7 4

Ref5：

Multidistributed Asset Transfer into One Distribution Line Fails with APP-OFA-48392: FA_INVALID_TXN_UNITS (Doc ID 213593.1)

APPLIES TO:

Oracle Assets - Version 11.5.10.2 and later
Information in this document applies to any platform.
 

SYMPTOMS

Transfering from two assignment lines to one or more new lines fails with error.
 APP-OFA-48392: FA_INVALID_TXN_UNITS
APP-OFA-48392: The asset_dist_tbl structure contains invalid transaction units.

CHANGES

CAUSE

Possible causes are:
1. Null or zero units were entered.
2. Positive or negative units were entered incorrectly.
3. Not enough units were entered.
This is desired functionality. You can transfer from ONLY ONE
assignment line to one or more new lines.

Reference:
Orace Assets User Guide
Chapter 3 Asset Maintenance
Section:  Transferring Assets

SOLUTION

Perform such transfer in two steps:
1. Transfer from first source line and save.
2. Then transfer from the second source line to the same destination line as in p.1 or to the new line.