Enable Search Functionality For Move Orders Created By Other Users On Find Move Orders

In the Move Orders form (INVTOMAI), when using the Find function, the Created By field cannot bechanged. For this reason, move orders from other users cannot be queried.
The security function INV_INVTOMAI_CREATOR is not enabled in the menu being used. The form INVTOMAI.fmb within the Package TOMAI_MENU and PROCEDURE CREATED_BY_CHECK checks for the function INV_INVTOMAI_CREATOR. If it is not enabled for the user, the Created By field is not updatable.
Execute the following steps to enable the INV_INVTOMAI_CREATOR function:
A. Define the INV_INVTOMAI_CREATOR function if is does not already exist:
Navigate: System Administrator > Application > Function
Enter Function Name: INV_INVTOMAI_CREATOR
Enter User Function Name: 'Move Orders Creator'
Under the Properties tab, enter Type: Subfunction
Enter Maintenance Mode support: None
Enter Context Dependence: Responsibility
Save
B. Assign the function to the Menu you are using:
Navigate System Administrator > Application > Menu
Click on the flash light icon from Tool bar.
Add a new line to the menu:Prompt: 'Move Order Creator'Function: select 'Move Orders Creator' from the LOVDescription: 'Move Orders Creator'
Save
C. Check the Functionality
Go the the responsibility that has move orders and open move order screen.
Query for menu 'INV_MOVE_ORDER'
The Created By field in the Move Order find form should now be enabled and modifiable.
When you go to created by field you will see an LOV. Select the user whose move orders have to be View or cancel.
Hit Find button
Now click on open for the records retrieved. Select from tool bar tools > Cancel if you want to cancel or close to close the move order.
Note: You may need to sign out and back in for the change to take affect.
Ref Doc: Note:280131.1

Step by Step to Install Oracle Applications R12.0.4 On Solaris 5.10(SPARC)

Environment:

Operating Systems Requirement: Solaris 5.10 (SPARC)

Oracle Applications : e-business Suite R12.0.4

1. Command to check the operating system version: $ uname –r

2. Command to check the maintenance update level: $ cat /etc/release
Required Patches
a. 125100-04 or higher
b. 120473-05 or higher:

Command to retrieve the list of operating system patches already applied:

$ showrev -p sort > patchList

Command to check for a specific patch:

$ /usr/sbin/patchadd -p grep patch_number

Required Packages for R12
Solaris 10 (5.10)
SUNWarc
SUNWbtool
SUNWhea
SUNWlibm
SUNWlibms
SUNWsprot
SUNWtoo
SUNWi1of
SUNWi1cs
SUNWi15cs
SUNWxwfnt

Command to check for existing packages:$ pkginfo

Required Kernel Settings
Solaris 10 (5.10)

set rlim_fd_max=65536
set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=256
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100

Check the /etc/system file to verify the kernel settings.

Hostname Settings

Verify that the /etc/hosts file is formatted as follows:

127.0.0.1 localhost.localdomain localhost

.

Create Users & Groups

Groupadd dba

Useradd –d /Home/applprod –g dba applprod

Useradd –d /Home/oraprod –g dba oraprod

Start Install:Create the Stage directory and start Rapid Install.

$ cd /dump/StageR12/startCD/Disk1/rapidwiz$ ./rapidwiz

Go through the Welcome Screen & Next

Go through the Wizard Screen & Next

Go through the Oracle Configuration Manager Screen & Next

We are doing fresh ,Single node installationOn Confuguration choice screen

select Create a new configuration & Next

On Global Syatem settings Screen Provide the Port pool

Provide the database node details

Check & verify the Node Paths

Go through the licensing & select required

Select The Country Specific Functionalities

Provide the Applications Node Details

Verify the Node Information

Go through the Pre-Install Checks

Go through review & Next

Start the Installation by go through YES

Verify the Installation Stages

Verify through Post-install Checks & Next

Next Finish

Export/Import Issue with oracle 8i

While Upgrading the EMS Database to 9.2.0.6, I have faced Some issues while Importing the EMS data Using the Export DMP file that was created with an Oracle 8i (8.1.6) Release Export Utility.

Error Message:
IMP-00017: following statement failed with ORACLE error 6550:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(~,~); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"BOE_DTL"','"BED_EXP_BNK_CODE"', NULL ,NULL,NULL,0"
",0,7209,srec,1,2); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 155:
PLS-00103: Encountered the symbol "~" when expecting one of the following:

IMP-00017: following statement failed with ORACLE error 6550:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(~,~); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"BOE_DTL"','"BED_BYR_BNK_CODE"', NULL ,NULL,NULL,0"
",0,7209,srec,1,2); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 155:
PLS-00103: Encountered the symbol "~" when expecting one of the following:

Solution:
This issue occurs with an Oracle8i, 8.1.7.2 or earlier release export utility Apply the 8.1.7.3 Patch set or Use this Action plan to resolve the Data Migration Issue:
1. Re-run the export without exporting the statistics:

> exp system/password FILE=... STATISTICS=none .... (other parameters)

And re-run the import afterwards.

or:

2. Do not import the statistics that were exported in the export dump file:

a. When importing into an Oracle8i database:
> imp system/password FILE=... ANALYZE=n .... (other parameters)
or:
> imp system/password FILE=... RECALCULATE_STATISTICS=y .... (other p's)

b. When importing into an Oracle9i/Oracle10g database:
> imp system/password FILE=... STATISTICS=none .... (other parameters)
or:
> imp system/password FILE=... STATISTICS=recalculate .... (other params)