R12- Ora-01461 Can Bind A Long Value Only For Insert Into A Long Column

R12 EBS --> HRMS BUG:
Bug Details: Ora-01461 Can Bind A Long Value Only For Insert Into A Long Column

Solution:
Apply this patch:5394728 / Relink / Regerate form as mentioned below.

While Update Oracle Payroll Forms (Required for Oracle Payroll customers only)

1. Download 10.1.0.5 patch 5394728 and apply it to the 10.1.2 Application Server Oracle Home according to the instructions in the patch README.

If OPatch presents either or both of the following messages, type "Y" and continue applying the patch.

Set path using this command

$export path=$PATH:$ORACLE_HOME?OPatch

Apply patch using this command
$opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc

1. "The fixes for Patch 5394728, are included in the patch currently being installed (5394728). If you continue, they will be rolled back and the new patch (5394728) will be installed. Do you want to continue? Please respond Y|N"
2. "The following problems were encountered when backing-up the static archive files: 1. <10.1.2>/lib32/libpls10.a [ object: phb.o ]. Do you want to continue? Please respond Y|N "

2. Relink the forms, reports and Procdure Builder components using the following commands.
1. Set the OBJECT_MODE variable :

$ export OBJECT_MODE=32

2. Relink forms components:

$ cd $ORACLE_HOME/forms/lib32
$ make -f cus_forms.mk install
$ make -f cus_forms.mk sharedlib

3. Relink Procedure Builder components:

$ cd $ORACLE_HOME/procbuilder/lib32
$ make -f cus_procbuilder.mk sharedlibs

4. Relink reports components:

$ cd $ORACLE_HOME/reports/lib32
$ make -f cus_reports.mk install

3. Regenerate the form FFXWSMNG.fmx using AD Administration.


Once this is done on R12 of EBS it works fine and the bug is fixed.

Please take backup of your system before applying.

Thank you

Happy Reading

/Syed Shakir Jamal