Thursday, November 2, 2017

MOVE CONCURRENT PROG DEF FROM ONCE INSTANCE TO ANOTHER INSTANCE

Valueset
=========

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXRS_CUST_PRICING_TYPE_NEW_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XXRS_CUST_PRICING_TYPE_NEW"


Concurrent Program Definition
======================================

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRS_WIP_PROD_TIME.ldt PROGRAM APPLICATION_SHORT_NAME="XXRS" CONCURRENT_PROGRAM_NAME="XXRS_WIP_PROD_TIME"


XXRSOE_CUST_PRICING

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRSOE_CUST_PRICING.ldt PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="XXRSOE_CUST_PRICING"


Data Definition and Template Registration
======================================

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XXRS_WIP_PROD_TIME_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXRS' DATA_SOURCE_CODE='XXRS_WIP_PROD_TIME' TMPL_APP_SHORT_NAME='XXRS' TEMPLATE_CODE='XXRS_WIP_PROD_TIME'



DATA_TEMPLATE (Data Source .xml file)
=====================================

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -APPS_SHORT_NAME XXRS -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $XXRS_WIP_PROD_TIME_D


RTF TEMPLATE (Report Layout .rtf file)
======================================

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -APPS_SHORT_NAME XXRS -LANGUAGE en -TERRITORY 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $XXRS_WIP_PROD_TIME_DT



Bursting File
=============
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))" -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME XXRS  -LOB_CODE  XXRS_ASN_ERROR_RPT -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME XXRS_ASN_ERROR_RPT_BURST.xml -CUSTOM_MODE FORCE


===================
upload commands
===================

Valueset
=========
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XXRS_CUST_PRICING_TYPE_NEW_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


Concurrent Program
===================

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRS_WIP_PROD_TIME.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE




Data Definition and Template Registration
======================================

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXRS_WIP_PROD_TIME_DD.ldt


DATA_TEMPLATE (Data Source .xml file)
=====================================

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml -APPS_SHORT_NAME XXRS -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME


RTF TEMPLATE (Report Layout .rtf file)
======================================

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=DEV)))' -LOB_TYPE TEMPLATE -LOB_CODE XXRS_ASN_ERROR_RPT -XDO_FILE_TYPE RTF -FILE_NAME $XXRS_TOP/XXRS_ASN_ERROR_RPT_en_US.rtf -APPS_SHORT_NAME XXRS -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME



Bursting File
=============

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION  "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=DEV)))"  -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME XXRS  -LOB_CODE  XXRS_ASN_ERROR_RPT -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME XXRS_ASN_ERROR_RPT.xml -CUSTOM_MODE FORCE


Table level Data flow for Order to Cash Flow (Oracle Apps)

In this blog I have highlight some of the KEY tables involved in Order to Cash table. There are lot of database table involves in this flow , but I have highlighted the key table and link between these tables.It help you while desiging the reports &queries. These tables are
OE_ORDER_HEADERS_ALL                  OE_ORDER_LINES_ALL 
WSH_DELIVERY_DETAILS                    WSH_DELIVERY_ASSIGNMENTS
WSH_NEW-DELIVERIES                         WSH_DELIVERY_LEGS
WSH_TRIP_STOPS                                   WSH_TRIPS
M TL_TRX_REQUEST_LINES                MTL_MATERIAL_TRANSACTION_TEMP
OE_SETS                                                     OE_LINE_SETS                     
PO_LINES_ALL                                         MTL_RESERVATIONS
MTL_MATERIAL_TRANSACTIONS_ALL
Data Flow Diagram
    In case you need sql Queries , please feel free to contact me.


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