MOVE CONCURRENT PROGRAM DEFINITION FROM ONE INSTACNE TO ANOTHER INSTANCE

MOVE CONCURRENT PROGRAM DEFINITION FROM ONE INSTACNE TO ANOTHER INSTANCE

========================================================================

àConnect to PUTTY

àLOGIN WITH THE CREADENTIALS

àRUN THE COMMAND   "ps -ef|grep inh" FOR PATHS

àset the environment by the above paths(/us1001/DEV/apps/apps_st/appl)

àrun the evinronment command (". APPSDEV_phl3dsjpmtdb01.env")

àThen run the command “sqlplus” for connectiong to DB with username & password

àCREATE ONE DIRECTORY IN THE SPECIFIC PATH(Optional) for all files in ONE FOLDER EASY TO DOWN LOAD AND MOVE THE FILES

àFIRST RUN THE BELOW COMMAND FOR CONCURRENT PROGRAM DEFINITION

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

EXPLANATION

apps/apps—DB username and password

JMORDERINTERFACE_FND.ldt—FOR CREATING A FILE

JM-- APPLICATION_SHORT_NAME

JMORDERINTERFACE_FND--CONCURRENT_PROGRAM_NAME

àThen we need to run the below command for DATA DEFINITION & TEMPLATE CODE DEFINITION

FNDLOAD apps/apps O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct JMORDERINTERFACE_FND_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='JM' DATA_SOURCE_CODE='JMORDERINTERFACE_FND' TMPL_APP_SHORT_NAME='JM' TEMPLATE_CODE='JMORDERINTERFACE_FND'

EXPLANATION

apps/apps—DB username and password

JMORDERINTERFACE_FND_DD.ldt—FOR CREATING A FILE IN THE SPECIFIC FOLDER.

JM-- APPLICATION_SHORT_NAME

JMORDERINTERFACE_FND-- DATA_SOURCE_CODE(data definition code)

JMORDERINTERFACE_FND—Template code

àNext, We need to run the below command for getting the RTF TEMPLATE FILE FROM THE APPLICATION and creating that file in specific folder.

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DEV)))' -LOB_TYPE TEMPLATE -LOB_CODE JMORDERINTERFACE_FND -APPS_SHORT_NAME JM -LANGUAGE en -TERRITORY US -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $JMORDERINTERFACE_FND_DT

EXPLANATION

JDBC_CONNECTION—need to give the TNS NAMES

JMORDERINTERFACE_FND—LOB_CODE(LOB code from XML Publisher Responsibility)

JM-Application short name

En—laguage in template

US—territory

àThen we need to run the below command for getting BURSTING CONTROL FILE FROM APPLICATION to specific folder.

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DEV)))" -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME JM  -LOB_CODE  JMORDERINTERFACE_FND -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME burst_JMORDERINTERFACE_FND.xml -CUSTOM_MODE FORCE

àall files got created in specific folder which you create first

àthen download the folder using SSH OR WINSCP to local machine

àNow connect to WINSCP with the destination Instance which you want to move the concurrent def

àmove the downloaded folder file to the new instance then follow the steps..

àConnect to PUTTY

àLOGIN WITH THE CREADENTIALS

àRUN THE COMMAND   "ps -ef|grep inh" FOR PATHS

àset the environment by the above paths(/us1001/DEV/apps/apps_st/appl)

àrun the evinronment command (". APPSDEV_phl3dsjpmtdb01.env")

àThen run the command “sqlplus” for connectiong to DB with username &

 password

àCREATE ONE DIRECTORY IN THE SPECIFIC PATH(Optional) for all files in ONE FOLDER EASY TO DOWN LOAD AND MOVE THE FILES

àThen we need to upload the downloaded files and concurrent prog Definition.

àRun the below command for uploading the CONCURRENT PROGRAM DEFINITION

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

àRun the below command for UPLOADING THE DATA DEFINITION & TEMPLATE DEFINITION

FNDLOAD apps/j27d1wnf O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct JMORDERINTERFACE_FND_DD.ldt

àRun the below command for UPLOADING THE RTF TEMPLATE FILE

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD j27d1wnf -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST)))" -LOB_TYPE TEMPLATE -LOB_CODE JMORDERINTERFACE_FND -XDO_FILE_TYPE RTF -FILE_NAME $JMINTRFACEORDER TEMPLATE_SOURCE_JM_JMORDERINTERFACE_FND_en_US.rtf -APPS_SHORT_NAME JM -NLS_LANG en -TERRITORY US -LOG_FILE $JMORDERINTERFACE_FND_LOG

àRun the below command for UPLOADING THE BURSTING CONTROL FILE

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD j27d1wnf -JDBC_CONNECTION  "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST)))"  -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME JM  -LOB_CODE  JMORDERINTERFACE_FND -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME BURSTING_FILE_JM_JMORDERINTERFACE_FND.xml -CUSTOM_MODE FORCE

àDONE FOR THE PROCESS  NEEDS TO CHECK WHEATHER ALL THE CONCURRENT PROGRAM DEFINITIONS , RTF FILES, BURSTING CONTROL FILES.

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.

O2C Order Status in Lines & Shipping in Back End & Front End

Status	Lines-Back End	Front End	WSH-Back End	front end	Triggered Programs
Entered	ENTERED	ENTERED	-		-
Booked	AWAITING_SHIPPING	AWAITING_SHIPPING	R	Ready to Release
Pic Release	AWAITING_SHIPPING	Awaiting Shipping	S	Released to Warehouse	Pick Selection List Generation,Pick Slip Report
Pick Confirm	AWAITING_SHIPPING	Picked	Y	Staged/Pick Confirmed
Ship Confirm	AWAITING_SHIPPING	Picked	C	Shipped
After Runnning Trip Stop	SHIPPED	Shipped	C	Interfaced	run Interface Trip Stop - SRS
After Work flow Bgnd  Process	CLOSED	Closed	C	Interfaced	Workflow Background Process
Invoice	CLOSED	Closed	C	Interfaced Delivery Level='Closed' Trip Level='Closed'	Autoinvoice Master Program, Autoinvoice Import Program, Prepayment Matching Program (Prepayments Matching Program)

Oracle Applications : Opening Periods

What is Period:

1. An interval of time characterized by the occurrence of a certain condition, event, or phenomenon: a period of economic prosperity.

2 Geology A unit of time, longer than an epoch and shorter than an era.

Significance Of Opening Periods in Oracle apps:

TO OPEN MONTHLY PERIODS OF DIFFERENT MODULES OR NEXT YEAR AND FOLLOW THE BELOW STEPS

1. HOW TO OPEN INVENTORY PERIODS (INV) :

Follow the below given navigation path :

INVENTORY - > ORACLE INVENTORY - > ACCOUNTING CLOSE CYCLE - > INVENTORY ACCOUNTING PERIODS

2. HOW TO OPEN PAYABLE PERIODS (AP):

Follow the below given navigation path :

PAYABLES - > ORACLE PAYABLES - > ACCOUNTING - > CONTROL PAYABLES PERIODS

3. HOW TO OPEN RECEIVABLE PERIODS (AR) :

Follow the below given navigation path :

RECEIVABLES - > ORACLE RECEIVABLES - > CONTROL - > ACCOUNTING - > OPEN/CLOSE PERIODS

4. HOW TO OPEN GENERAL PERIODS (GL) :

Follow the below given navigation path :

GENERAL SUPER LEDGER - > SETUP - > OPEN/CLOSE

5 Navigate to Purchasing SuperUser->Setup->Financials->Accounting->Control Purchasing Periods , then enter the Fiscal year and click Go button.

(If it prompts for selecting Operating Unit,select it and click Go button.)

Query to get whether accounting period or not?

SELECT   application_id
into     g_application_id
  FROM   fnd_application_tl
 WHERE   application_name = 'Receivables'


SELECT   SET_OF_BOOKS_ID INTO P_SOB_ID FROM GL_SETS_OF_BOOKS

P_ACCOUNTING_DATE IS YOUR period

FUNCTION validate_gl_accounting_date (p_accounting_date   IN DATE,
                                      p_sob_id            IN NUMBER)
   RETURN BOOLEAN
IS
   v_count   NUMBER := 0;
BEGIN
   SELECT   COUNT ( * )
     INTO   v_count
     FROM   gl_period_statuses gps
    WHERE       gps.application_id = g_gl_application_id
            AND gps.set_of_books_id = p_sob_id
            AND gps.closing_status IN ('O', 'F')
            AND p_accounting_date BETWEEN NVL (gps.start_date,
                                               p_accounting_date)
                                      AND  NVL (gps.end_date,
                                                p_accounting_date);

   IF v_count > 0
   THEN
      RETURN TRUE;
   ELSE
      RETURN FALSE;
   END IF;
END validate_gl_accounting_date;

Run Concurrent Program from Form: Launch SRS Built In

Run Concurrent Program from Form: Launch SRS Built In

Form Personalization to run Concurrent Program from Form 

Built-in : Launch SRS Program.

Example :

Our Requirement is to Run Production Batch Sample Label from Production Batch Form.

We could completed this requirement through Form Personalization in below steps.

A)-Define 1 Menu : Special Menu for the Report, that shall show in tools Menu bar.

B)-Attach Concurrent Program menu with this Special Menu (defined in the above step).

C)- Store batch id ( For parameter to run your concurrent) in one Global variable.

D)- In Concurrent Definition window , Assign Global variable value to the Parameter for Batch id.

Here are the screen shots.

Requirement is like Below.

Goto Help --> Diagnostics --> Custom Code --> Personalize.

Add 1 New Sequence for You personalization, and Select Event as When-New-Form-Instance.

Goto Actions, and Choose any 1 special Menu.

Once menu is define, we need to attach Concurrent program to this menu.

Create new Sequence, for attaching The concurrent program with special menu defined in above step.

Goto Actions, here we need to define 2 Actions

1)- Global Variable to store Batch ID for Parameter.

2)- Attach Concurrent program to the Special Menu.

Global Variable name should be Logical and unique, as this needs to be pass to your concurrent program.

Save your work, Till here personalization is done for Concurrent program is attached and run, now Concurrent program will be run , but we have to assign Parameters manually, it will not pick any parameter automatically.

Step-3, To pass parameters from Batch form automatically.

GO TOà System adminà applicationà Concurrentà define

Now we have to attach Global variable from above steps to Concurrent Program.

Go to Parameters, and then pass global variable from the earlier form i.e, Batch Form.

Select Batch id parameter.

Its Default Type Should be SQL Statement.

Then Pass the 

“select :GLOBAL.XX_BATCH_ID from dual”

Now try to run report from Batch form,

How to call a Concurrent Program from a Special Menu Item?

Well, we can run our concurrent programs from a Special Menu Item, and if you have a requirement of this sort, you can use the steps below to use Form Personalization Builtin to achieve this task in couple of minutes.

1] First create the Special Menu Item wherever required through Form Personalization. Here I have added a Special Menu Item called ‘Assign Item to a Subinventory’ to the Form-‘INVIDITM’. For that assign the Trigger Event as ‘WHEN-NEW-FORM-INSTANCE’.

2] In Actions Tab, choose the type as ‘MENU’ and select the Menu Entry and give a Proper Menu Label.

3] Create the Concurrent Program which you want to attach to this custom menu item. Once created, assign the program to the Request Group of the Responsibility. Also it is required to add the ‘Lunch SRS Form’ Function (Requests: Submit) to the main menu of that responsibility. If you don’t do this step you may get Form Personalization error in later steps.

4] Create one more entry in Form Personalization window with Trigger Event as your custom menu item.

5] Here select the Actions Type as ‘Builtin’ and Builtin Type as ‘Lunch SRS Form’. In the program name give the name of your concurrent program.

6] Validate and Apply Now

Once done, you will be able to view the custom menu item in the Form and when you will click it, it opens the SRS Form with your concurrent program.