Thursday, June 21, 2018

How to declare and use a variable in BI Publisher report

Decalring the Varible :<?xdoxslt:set_variable($_XDOCTX, 'var', 0)?>

Do the calculation :<?xdoxslt:set_variable($_XDOCTX,'var', xdoxslt:get_variable($_XDOCTX,'var‘)+ XML columnname)?>

Display the Variable : <?xdoxslt:get_variable($_XDOCTX, 'var')?>

Thursday, March 29, 2018

Fixed assets mass additions import


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 click the program in import Process is Post Mass Additions
 àUpload the new ZIP file in the UPLOAD NEW FILE.
à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

External Data Integration Services for Oracle Cloud: Overview

https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
Help topic
https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif|https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
03/08/2017
https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif|https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
Generic
https://fusionhelp.oracle.com/helpPortal/adf/images/t.gifhttps://fusionhelp.oracle.com/helpPortal/images/seperator_img.pnghttps://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
https://fusionhelp.oracle.com/helpPortal/adf/images/t.gifhttps://fusionhelp.oracle.com/helpPortal/images/seperator_img.pnghttps://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
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:
https://fusionhelp.oracle.com/helpPortal/Graphic/XDIS_01_neh_20053117.png

Mass Additions: How They're Processed

https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
Help topic
https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif|https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
03/08/2017
https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif|https://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
Generic
https://fusionhelp.oracle.com/helpPortal/adf/images/t.gifhttps://fusionhelp.oracle.com/helpPortal/images/seperator_img.pnghttps://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
https://fusionhelp.oracle.com/helpPortal/adf/images/t.gifhttps://fusionhelp.oracle.com/helpPortal/images/seperator_img.pnghttps://fusionhelp.oracle.com/helpPortal/adf/images/t.gif
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.
Mass Additions Flowchart
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 the Post Mass Additions Process

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 Mass Additions Lines 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.



Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...