Fixed assets mass additions
import
àDown
load the FBDL template from the oracle
àPrepare
the data based on the given data file into the FBDL template file and few of
the columns are the required columns.
àThen
open the first page of the template and click on the “Generate the CSV file”
then the ZIP file will be generated.
àGoto
the application front end ànavigatoràSchedule Proecess
àThen
Run the Program “Load Interface File for
Import”
àThen submit the
program
àAfter
few of the program may run in the Scheduled Process and all program need to
Succeeded status. Then only the data is loaded in the application.
àThe
data loaded into the below tables.
Job and Table Links
|
Name
|
Link
|
|
Scheduled process
|
Post Mass Additions
|
|
Tables
|
àThen
Open the Asset in front end
àThe
Assets which are in the Ready to Post ,they
are ready for posting .
àFor
posting the assets select the asset and click on POST
ALL button.
àAll the assets will
be posted.
àPlease
find the below link for reference
Use External Data Integration Services
for Oracle Cloud to load data into Oracle Fusion Applications from external
sources, such as legacy systems and third-party applications.
External
Data Integration Services for Oracle Cloud include the following components:
·
Templates to structure, format, and generate the data file
according to the requirements of the target application tables.
·
File-based load process to load the data files into the
interface tables.
·
Application-specific data import processes to transfer data
from interface tables to the application tables in your Oracle Fusion
Applications.
The
following flow diagram outlines the steps involved in the process:
 |
|||||||||||||||||||||||||||||
Mass Additions: How They're
Processed
|
|||||||||||||||||||||||||||||
|
 | |
03/08/2017
|
| |
Generic
|
||||
 |
|
|||||||
Use the Mass Additions
interface to create assets from information outside of Oracle Fusion Assets.
You can import data into Assets through the interface tables
from the following sources:
·
External sources, such as legacy systems.
·
Oracle Fusion Project Costing.
·
Oracle Fusion Payables.
·
Application Developer Framework (ADF) desktop integration
spreadsheet.
The Mass Additions interface uses a parent and child table to
store asset information and details of its distribution assignments. You can:
·
Add an asset with one or more source lines providing detailed
descriptive information about individual items in each source line.
·
Merge multiple mass additions lines into a single asset or you
can split a single line into multiple assets.
The Mass Additions interface uses the following interface
tables:
|
Table Type
|
Name
|
Description
|
|
Parent
|
FA_MASS_ADDITIONS
|
This table
contains information about assets that will be automatically added to Assets
from another system or integration. This table can be used to load assets for
system conversions.
Assets inserts
one row into this table for each invoice line it selects from Oracle Fusion
Payables. The Post Mass Additions process inserts rows into the base tables
and creates assets or adjustments from any rows in which the posting status
is Post.
|
|
Child
|
FA_MASSADD_DISTRIBUTIONS
|
This table stores
distribution information, such as units, the depreciation expense account,
the location, and the employee assigned to each mass addition line.
|
Once you have added the data to the FA_MASS_ADDITIONS table, you
can perform additional preparations on the mass additions, for example:
·
Adding source, descriptive and depreciation information.
·
Assigning the mass addition to one or more distributions, or
changing existing distributions on the Assignments region of the Edit Source
Lines page.
·
Adjusting the cost of a mass addition.
·
Merging a mass addition into another mass addition.
·
Splitting a multiple-unit mass addition into several single-unit
mass additions.
·
Adding mass addition lines to existing assets such as a cost
adjustment.
After preparing the mass additions, you can post the data in
Assets.
This figure contains the flow of importing assets into Oracle
Fusion Assets and posting them.
Note
You can load data to interface tables using predefined templates
and the Load Interface File for Import scheduled process, which are both part
of the External Data Integration Services for Oracle Cloud feature.
For other implementations, optionally use this feature only if
you have Secure File Transfer Protocol (SFTP) configured for it.
Loading Data from Oracle Cloud
To populate the interface table from Oracle Cloud, download the
relevant predefined spreadsheet template from the File Based Data Import for
Oracle Financials Cloud guide for this particular set of transactions.
1. Open the File Based
Data Import for Oracle Financials Cloud guide and locate the Fixed Asset Mass
Additions Import process.
2. Prepare the data in the
parent and child worksheets.
3. Click the Generate CSV
File button. The program generates both a comma-separated values (CSV) file and
a zip file.
4. Log in to the Oracle
Cloud SFTP server.
5. Transfer the zip file
to the SFTP server location.
6. Navigate to the
Scheduled Processes page.
7. Load the data using the
Load Interface File for Import process.
8. Review the results of
the process.
9. Correct any load errors
and repeat the process until all the data is uploaded.
Loading Data from the File Import and Export Page
1. Open the File Based
Data Import for Oracle Financials Cloud guide and locate the Fixed Asset Mass
Additions Import process.
2. Prepare the data in the
parent and child worksheets.
3. Click the Generate CSV
File button. The program generates both a comma-separated values (CSV) file and
a zip file.
4. Navigate to the File
Import and Export page to upload the zip file.
5. Navigate to the
Scheduled Processes page.
6. Load the data using the
Load Interface File for Import process.
7. Review the results of
the process.
8. Correct load errors and
repeat the process until all the data is uploaded.
Settings That
Affect
To submit the Post Mass
Additions process you need to select the appropriate corporate book. If your
corporate book isn't listed in the list of values, then one of the following
errors may have occurred:
|
Error
|
Solution
|
|
No mass additions
lines in a status of Post.
|
Change the status
to Post for the mass additions that are ready to be posted.
|
|
The corporate
book isn't effective for these mass additions lines.
|
Check the
effective date range of the corporate book on the Edit Book page.
|
|
The Calculate
Depreciation process ran with errors.
|
Fix the errors
and resubmit the Calculate Depreciation process. When the Calculate
Depreciation process runs successfully, resubmit the Post Mass Additions
process.
|
|
The Calculate
Depreciation process is currently running for the corporate book.
|
Wait until The
Calculate Depreciation process completes successfully, and then resubmit the
Post Mass Additions process.
|
When you run the Post Mass Additions process, mass additions
lines are processed according to the mass addition status they're assigned to.
|
Status Before Posting
|
Effect of Post Mass Additions
Process
|
Status after Posting
|
|
Post
|
Creates new asset
from the mass addition line.
|
Posted
|
|
Cost Adjustment
|
Adds the mass
addition line to an existing asset.
|
Posted
|
|
Merged
|
Mass addition
line was already merged.
|
Posted
|
|
Split
|
Mass addition
line was already split; posting doesn't affect the mass addition.
|
Split
|
|
New
|
New mass addition
line; posting doesn't affect the mass addition.
|
New
|
|
On Hold
|
Mass addition
line is on hold; posting doesn't affect the mass addition.
|
On Hold
|
|
Delete
|
Mass addition
line awaiting deletion; posting doesn't affect the mass addition.
|
Delete
|
How Are
Posted
After you successfully
load your data, you must submit the Post Mass Additions process to import the
data into the application tables and create the assets.
To submit the Post Mass Additions process:
1. On the Assets page,
click the Ready to Post link
on the Additions infotile.
2. Click Post All.
3. If the Post Mass
Additions process ends in error or warning, review the log file for details
about the rows that caused the failure.
To correct import errors:
1. Click the Exceptions link on the
Additions infotile.
2. In the Search region,
select the book and select Error in the Queue field and click Search.
3. Click Prepare All to export all
rows to a spreadsheet.
4. Review and correct the
errors in the spreadsheet and set the queue to Post for the corrected rows.
5. Once all the rows with
errors are corrected, click Submit
and Post Mass Additions to resubmit the process.
6. Repeat the submission
and error correction steps in this section until all rows are imported
successfully and the assets created.
