HOW TO INCOMPLETE A PO THAT IS IN PROCESS

applying the patch 19254890:R12.PO.D. no need to apply the patch. just run poxrespo.sql as below can incomplete the PO

sqlplus apps/apps @poxrespo.sql

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Mar 30 14:38:34 2017
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Please enter the PO number to reset : 1408
Please enter the organization id to which the PO belongs (Default NULL) : 102
Do you want to delete the action history since the last approval ? (Y/N) N

Processing STANDARD PO Number: 1408
......................................
Aborting Workflow...
Updating PO Status..
Done Approval Processing.
document reset successfully
please COMMIT data

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

How to increase SGA_MAX_SIZE, SGA_TARGET and PGA_AGGREGATE_TARGET in Oracle 11g

SQL> show parameter sga

NAME     TYPE VALUE

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

lock_sga     boolean FALSE

pre_page_sga     boolean FALSE

sga_max_size     big integer 2G

sga_target     big integer 2G

SQL> ALTER system SET sga_max_size=4G scope=spfile;

System altered.

SQL> ALTER system SET sga_target=4G scope=spfile;

System altered.

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

SQL> show parameter pga

NAME     TYPE VALUE

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

pga_aggregate_target     big integer 3G

SQL> alter system set PGA_AGGREGATE_TARGET=4G scope=spfile;

System altered.

***Bounce the database for apply the changes done.

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 4275781632 bytes

Fixed Size    2260088 bytes

Variable Size  738198408 bytes

Database Buffers 3523215360 bytes

Redo Buffers   12107776 bytes

Database mounted.

SQL> show parameter sga

NAME     TYPE VALUE

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

lock_sga     boolean FALSE

pre_page_sga     boolean FALSE

sga_max_size     big integer 4G

sga_target     big integer 4G

SQL> show parameter pga

NAME     TYPE VALUE

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

pga_aggregate_target     big integer 4G

Non critical error ORA-48913 caught while writing to trace file "/ebiz/ebizdb/tech_st/11.2.0/admin/PRODDB_ebiz/diag/rdbms/proddb/PRODDB/trace/PRODDB_ora_110928_999999999.trc"Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reachedWriting to the above trace file is disabled for now on...

Oracle 11g Recommendations are  below.

SQL> show parameter max_dump_file

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size string 20000
SQL> alter system set max_dump_file_size=UNLIMITED scope=both;

System altered.

SQL> show parameter max_dump_file

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size string UNLIMITED