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 laterInformation in this document applies to any platform.
Purpose
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.
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 |