My Oracle Support Banner

Oracle Assets Common Invoice Transfer API Documentation Supplement (Doc ID 1518301.1)

Last updated on JUNE 21, 2023

Applies to:

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

Purpose

Oracle Assets Common Invoice 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. Common Invoice transfer allows you to transfer source lines, streamline the code and prevent code duplication. 

MRC

If you have set up  Multiple Reporting currencies (MRC) , when you transfer source lines 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 primary and reporting currencies

Scope

 

Common Invoice Transfer API Description

The Common Invoice Transfer API procedure is called the FA_INV_XFR_PUB.DO_TRANSFER () procedure. The following table provides the arguments, types, value, and descriptions of the elements of the arguments, types, value, and descriptions of the elements of the FA_INV_XFR_PUB.DO_TRANSFER () 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

ArgumentTypeValueDescription
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.

PX_SRC_TRANS_REC

FA_API_TYPES.TRANS_REC_TYPE

  

Describes the
transaction taking
place.

PX_SRC_ASSET_HDR_REC

FA_API_TYPES.ASSET_HDR_REC_TYPE

  

Unique identifiers of
the assets

PX_DEST_TRANS_REC

FA_API_TYPES.TRANS_REC_TYPE

   Describes the
transaction taking
place.

PX_DEST_ASSET_HDR_REC

FA_API_TYPES.ASSET_HDR_REC_TYPE

   Unique identifiers of
the assets
P_INV_TBL

FA_API_TYPES.INV_TBL_TYPE

   Invoices for the assets.
       



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 / OptionalTypeValue
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.

 


INV_REC Invoice Structure

The INV_REC invoice structure contains invoice information for a single invoice associated with an asset. The INV_TBL is a table of INV_REC_TYPE records. These records contain all invoices that have been applied to the asset. The following table shows type and descriptive information for each argument.

 

Argument                   Required / OptionalTypeValue

FIXED_ASSETS_COST

 Required NUMBER

Cost of asset in Oracle
Assets.
SOURCE_LINE_ID Required NUMBER(15)

This is the delta
amount for each line
you wish to transfer.
It must be between 0
and the current cost
of the line in
question.
       

 

 

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
 Common Invoice Transfer API Description
Details

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