Monday, July 10, 2017

CONCURRENT PROGRAM - ‘COPY TO ' Option

Copying the existing report  that  must be customized new report , by using 'Copy to ' method


Step1 :
Open the existing Concurrent program (Report name) in Application developer form
 Application Developer---> Concurrent Program
Then Query your existing concurrent program. Like 


                                                            Figure1: Open Existing Report Program

 Step2:

Click on “Copy Program button” selecting check box option “Copy Parameters”. This will help you copy    the current program definition to custom version of the program.
Also note down the name of the executable as it appears in concurrent program definition screen.


                                                           Figure2 : Concurrent Program Copy to Option


                                                             
                                                          Figure3 : Concurrent Program - Parameter

Then click ok , save it 

 Note: Note down the application within which it is registered. If the application is Oracle Purchase, then you must go to the database server and get hold the file named XXXX.rdf in $PO_TOP/reports/US.

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