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

Last updated on OCTOBER 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.