UMD ie Unitask Migration Director

"Unitask" is third party tool which operates with Oracle EBS to download code components as package.
Its known as UMD ( Unitask Migration Director )

More details are at http://www.unitask.com

Follow below steps to generate package and upload:

1 Navigate to Responsibility : Unitask Object Migration Manager Developer
2 Create New Package
3 Select objects needed for package
4 It will submit two concurrent programs
    UMD: Create Download Script
    Unitask Object Migration Manager: Download Package (UMD: Download Package)
5 Output report shows details of what package is made of. Output file is in tar format.
6 Once programs are completed, package can be viewed/saved by clicking view link in menu of same responsibility.
7 Download package on local machine
8 Move package file to different instance and upload using same responsibility

Notes : 

• For modifying already created package unfreeze it and change
• Control files or application server files can be picked up as "Application Server File" , source path can contain dynamic variables like $XBOL_TOP
• I could not find option for migrating table along with data. May be not feasible ?
• It creates shell script to install objects 
• Menu/ Responsibilities can be migrated

Its simple approach to get code downloaded from one instance and migrate to other.
It covers concurrent program definition, executable, lookups , pl/sql packages, table, view definitions and many more objects.. simple r i g h t?

XML Response file not parsing

We faced big issue on UAT days due to hidden error caused by XMLPARSER

    response_parser := xmlparser.newparser;
    xmlparser.parseclob(response_parser, response_clob);
    resp_dom_doc := xmlparser.getdocument(response_parser);

This caused SOAP UI response XML parsing error and aborting
supportable search , presenting incomplete results.

Exception: ORA-31011: XML parsing failed ORA-19202: Error
occurred
in
XML processing LPX-00217: invalid character 26 (U+001A) Error at
line 1 Stack: ORA-06512: at "XDB.DBMS_XMLPARSER", line 191
ORA-06512: at "APPS.XXRH_SUPX_USER_SVC_PKG", line 759

After lot of search on net and Oracle SR, I found below simple solution to replace control characters from XML clob

pout_response_clob:= regexp_replace(pout_response_clob, '['||chr(1)||'-'||chr(13)||chr(14)||'-'||chr(31)||chr(127)||']','');

What this does is replaces all the control chars and gives back clob which can be parsed by XMLPARSER

More details - https://forums.oracle.com/forums/thread.jspa?messageID=10265001

There are other related functions like DBMS_XMLGEN.CONVERT , DBMS_LOB.CONVERTCLOB etc 

This finding helped us to save big go-live!!!

"Dhundane pe khuda bhi milta hain! "