Oracle Assets Retirement Adjustment API Documentation Supplement
(Doc ID 1433793.1)
Last updated on JUNE 21, 2023
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. The Retirement Adjustment API allows you to enter the cost of removal and proceeds of sale directly to the group asset.
MRC
If you have set up Multiple Reporting Currencies (MRC), when you add or modify assets using an Oracle Assets API, the API copies the transactions to all the reporting books for MRC automatically.
Invoice rounding issues are avoided by using the API to drive the accounting for both the primary and reporting currencies.
Scope
Retirement Adjustment API Description
The Retirement Adjustment API procedure is called: FA_RETIREMENT_ADJUSTMENT_PUB.DO_RETIREMENT_ADJUSTMENT().
The following table provides the arguments, types, value, and descriptions of the elements of the FA_RETIREMENT_ADJUSTMENT_PUB.DO_RETIREMENT_ADJUSTMENT() procedure.
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_MSG_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. |
| P_CALLING_FN | VARCHAR2(30) | Function calling 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 | |
| PX_TRANS_REC | FA_API_TYPES. TRANS_REC_TYPE |
Describes the transaction taking place. |
|
| PX_ASSET_HDR_REC | FA_API_TYPES. ASSET_HDR_REC_TYPE |
Unique identifiers for the assets. |
|
| P_COST_OF_REMOVAL | NUMBER (Defaults to NULL) | ||
| P_PROCEEDS | NUMBER | ||
| P_COST_OF_REMOVAL_CCID | NUMBER (Defaults to NULL) |
||
| P_PROCEEDS_CCID | NUMBER (Defaults to NULL) |
TRANS_REC_TYPE Transaction Structure
The TRANS_REC_TYPE transaction structure contains information about the 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 |
|---|---|---|---|
| WHO_INFO | Required | STANDARD_WHO_REC_TYPE | Standard Who column |
| TRANSACTION_HEADER_ID | Internal use only | NUMBER(15) | Optional OUT parameter |
| TRANSACTION_DATE_ENTERED | Optional | DATE | Defaults to the date placed in service.Populate if you are performing a prior period retirement, else do nothing or set it to null. |
| 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. |
| AMORTIZATION_START_DATE | Optional | DATE | Amortization start date. |
| CALLING_INTERFACE | Optional | VARCHAR2(30) | Defaults to CUSTOM |
| DESC_FLEX | Optional | DESC_FLEX_ REC_TYPE | Descriptive flexfield segments. |
ASSET_HDR_REC_TYPE Asset Structure
The ASSET_HDR_REC_TYPE asset structure contains unique identification information for a given asset, such as the asset ID and book type code. The following table shows type and value information for each argument.
| Argument | Required / Optional | Type | Value |
|---|---|---|---|
| ASSET_ID | Required | NUMBER(15) | Asset identification number. |
| BOOK_TYPE_CODE | Required | VARCHAR2(15) | Book name. |
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 |
| Details |