My Oracle Support Banner

Oracle Assets Group Reserve Transfer API Documentation Supplement (Doc ID 1422693.1)

Last updated on FEBRUARY 26, 2020

Applies to:

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

Purpose

Oracle Assets Group Reserve Transfer API

You can use this API if you have a custom interface that makes it difficult to use with the existing interfaces in Oracle Assets. Reserve transfer allows you to move part of the accumulated depreciation from one group asset to another, and is treated as a current period amortized adjustment. You can  transfer reserve of a group asset to another group asset only through the user interface.

Alternate Ledger Currency (ALC)

If you have set up alternate ledger currency , when you add or modify assets using an Oracle Assets API, the API copies the transactions to the reporting currencies automatically.
Invoice rounding issues are avoided by using the API to drive the alternate ledger currency accounting for both the ledger and reporting currencies.

Scope

 

Reserve Transfer API Description

The Reserve Transfer API procedure is called the
FA_RESERVE_TRANSFER_PUB.DO_RESERVE_TRANSFER () procedure. The following table provides the arguments, types, value, and descriptions of the elements of the

Each argument has a prefix of P, X, or PX. These prefixes mean the following:

P - indicates an In argument

X - indicates an Out argument

PX - indicates an argument that is both In and Out

Argument Type Value Description
P_API_VERSION              NUMBER Internal use only Version of the API in Use.
P_INIT_MESG_LIST VARCHAR2(1) FND_API.G_TRUE - Initialize the message stack.
FND_API.G_FALSE - Do not initialize the message stack
(Default).
Determines whether
the messages stack
should be initialized
and cleared
P_COMMIT VARCHAR2(1) FND_API.G_TRUE -Commit automatically.
FND_API.G_FALSE - Do not commit automatically (Default)
Commits the
transaction.
P_VALIDATION_LEVEL NUMBER FND_API.G_VALID_LEVEL_NONE - Low level validation for a transaction.
FND_API.G_VALID_LEVEL_FULL - High level validation for a transaction (Default).
Asset validation by
the API.
X_RETURN_STATUS VARCHAR2(1) FND_API.G_RET_STS_ SUCCESS -
Indicates a success.
FND_API.G_RET_STS_ ERROR - Indicates a failed transaction. FND_API.G_RET_STS_UNEXP_ERROR -Indicates an unexpected error.
Determines the API
success.
X_MSG_COUNT NUMBER . Number of messages
on the message stack.
X_MSG_DATA VARCHAR2(1024)   Message stack.
P_CALLING_FN VARCHAR2(30)   Function that calls the
API.
P_SRC_ASSET_ID NUMBER   Source group asset ID.
P_DEST_ASSET_ID NUMBER   Destination group asset ID.
P_BOOK_TYPE_CODE VARCHAR2(15)   Book type code.
P_AMOUNT NUMBER   Asset amount.
PX_SRC_TRANS_REC FA_API_TYPES.TRA
NS_REC_TYPE
  Asset source
transaction record.
PX_DEST_TRANS_REC FA_API_TYPES.TRA
NS_REC_TYPE
  Asset destination
transaction record.



ASSET_SRC_TRANS_REC Transaction Structure

The ASSET_SRC_TRANS_REC transaction structure contains information about the source transaction, such as the transaction header ID and the transaction type code. The following table shows type and value information for each argument.

Argument                                Required / Optional Type Value
TRANSACTION_HEADER_ ID Internal use only NUMBER(15) Optional OUT parameter
TRANSACTION_DATE_ENTERED Optional DATE Defaults to the date placed in service.
TRANSACTION_NAME Optional VARCHAR2(20) Description of the transaction. This field is the Comments field in the Asset Workbench.
MASS_REFERENCE_ID Optional
NUMBER(15)
Identifies the concurrent request
that invokes the transaction if it is part
of a mass transaction.
TRANSACTION_SUBTYPE Optional VARCHAR2(9) Additional information about the
transaction type.
AMORTIZATION_START_DATE Optional DATE Amortization start date.
CALLING_INTERFACE Optional VARCHAR2(30) Interface that calls the API. This field
defaults to CUSTOM.
DESC_FLEX Optional DESC_FLEX_     REC_TYPE Descriptive flexfield segments.
WHO_INFO Required STANDARD_
WHO_REC_ TYPE
Standard Who columns.


ASSET_DEST_TRANS_REC Transaction Structure

The ASSET_DEST_TRANS_REC transaction structure contains information about the destination transaction, such as the transaction header ID and the transaction type code. The following table shows type and value information for each argument.

Argument                    Required / Optional Type Value
TRANSACTION_HEADER_ID Internal use only NUMBER(15) Optional OUT
parameter
TRANSACTION_DATE_ENTERED Optional DATE Defaults to the date
placed in service.
TRANSACTION_NAME Optional VARCHAR2(20) Description of the
transaction. This field
is the Comments field
in the Asset
Workbench.
MASS_REFERENCE_ID Optional NUMBER(15) Identifies the
concurrent request
that invokes the
transaction if it is part
of a mass transaction.
TRANSACTION_SUBTYPE Optional VARCHAR2(9) Additional
information about the
transaction type.
AMORTIZATION_START_DATE Optional DATE Amortization start
date.
CALLING_INTERFACE Optional VARCHAR2(30) Interface that calls the
API. This field
defaults to CUSTOM.
DESC_FLEX Optional DESC_FLEX_ REC_TYPE Descriptive flexfield
segments.
WHO_INFO Required STANDARD_WHO_REC_TYPE Standard Who
columns.


Oracle Assets Group Reserve Adjustment API Sample Scripts

 

Sample Script:  Group Reserve Transfer API


.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
 Reserve Transfer API Description
 Oracle Assets Group Reserve Adjustment API Sample Scripts
Details
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.