Data Fix Process

1.  Prepare Script – To take a Back up

1.1 There is a Sample Example explained for you to apply the Data Fix Process.
Before goint to apply the Update/Delete/Insert statements we need to take a date backup from the Instance. Here we need to create a file with sample code

--Copyright (c) 2005 Emerson Electric Company

--This program contains proprietary and confidential information.

--All rights reserved except as may be permitted by prior

--written consent.

--

--%PCMS_HEADER_SUBSTITUTION_START%

--File Name:   %ARCHIVE%

--PVCS Spec:   %PID%

--

--Attribute Label:  %LABEL%

--

--Description:

--%PD%

--

--Modification History:

--%PL%

--%PCMS_HEADER_SUBSTITUTION_END%

--*******************************************************************

  --

  -- project        : EPM

  --

  -- application    : EMR Order Management

  --

  -- script         : XXDFIX_AP_INV_SELECTION_BACKUP.sql

  --

  -- created by     : Mohali

  -- creation date  : 29-AUG-2017

  --

  -- description    : Datafix for tables APPS.AP_INV_SELECTION_CRITERIA_ALL

  --

  -- parameters     : <parameter1> :  NA

  --                   <parameter2> : NA

  --

  -- inputs         : NA

  --

  -- outputs        : <NA>

  --

  -- platform os  : Sun OS 5.8

  -- platform - h/w :  <h/w name>

  --

  -- database       : Oracle 10.2.0.4.0

  -- apps. Release  : Oracle Applications R 11.5.10

  --

  -- development and maintenance history

  --

  -- date           author   description

  -- ------------   -----------------   ---------------------------------------

  -- 29-AUG-2017   MOHALI     Update APPS.AP_INV_SELECTION_CRITERIA_ALL

  -- ***************************************************************************

DELETE FROM apps.ap_checkrun_conc_processes_all

     WHERE checkrun_name = 'MKK 022017 TEST PIC ACH' AND org_id = '8106';

COMMIT;

UPDATE APPS.AP_INV_SELECTION_CRITERIA_ALL

SET STATUS = 'FORMATTED'

WHERE CHECKRUN_NAME = 'MKK 022017 TEST PIC ACH'

AND ORG_ID= '8106'

AND CHECKRUN_ID = '593043';

COMMIT;

/

SHO ERR;

1.2  Make a file with above script and save it to local system with .tis format.

2.  Prepare a Script – To Update/Delete Command

2.1 Prepare a script for Update/Delete commands

--Copyright (c) 2005 Emerson Electric Company

--This program contains proprietary and confidential information.

--All rights reserved except as may be permitted by prior

--written consent.

--

--%PCMS_HEADER_SUBSTITUTION_START%

--File Name:   %ARCHIVE%

--PVCS Spec:   %PID%

--

--Attribute Label:  %LABEL%

--

--Description:

--%PD%

--

--Modification History:

--%PL%

--%PCMS_HEADER_SUBSTITUTION_END%

--*******************************************************************

  --

  -- project        : EPM

  --

  -- application    : EMR Order Management

  --

  -- script         : XXDFIX_AP_INV_SELECTION_UPDATE.sql

  --

  -- created by     : Mohali

  -- creation date  : 29-AUG-2017

  --

  -- description    : Datafix for tables APPS.AP_INV_SELECTION_CRITERIA_ALL

  --

  -- parameters     : <parameter1> :  NA

  --                   <parameter2> : NA

  --

  -- inputs         : NA

  --

  -- outputs        : <NA>

  --

  -- platform os  : Sun OS 5.8

  -- platform - h/w :  <h/w name>

  --

  -- database       : Oracle 10.2.0.4.0

  -- apps. Release  : Oracle Applications R 11.5.10

  --

  -- development and maintenance history

  --

  -- date           author   description

  -- ------------   -----------------   ---------------------------------------

  -- 29-AUG-2017   MOHALI     Update APPS.AP_INV_SELECTION_CRITERIA_ALL

  -- ***************************************************************************

DELETE FROM apps.ap_checkrun_conc_processes_all

     WHERE checkrun_name = 'MKK 022017 TEST PIC ACH' AND org_id = '8106';

COMMIT;

UPDATE APPS.AP_INV_SELECTION_CRITERIA_ALL

SET STATUS = 'FORMATTED'

WHERE CHECKRUN_NAME = 'MKK 022017 TEST PIC ACH'

AND ORG_ID= '8106'

AND CHECKRUN_ID = '593043';

COMMIT;

/

SHO ERR;

2.2  Make a file with above script and save it to local system with .sql format.

2.3  Place both the files under XXDFIX/11.0/ADMIN/SQL path in PVCS

3.  Run Kintanta

Create a New Package by mentioning the objects names in Kintana and Deploy the package in BetsyN1, S0 Vice versa.
The Kintana Package by default will create the backup and update the data aswell.

4.  Others