R12 Cannot Enter Any Receipt APP-PO-14142 rcv_receipts_th.insert_transaction-001: ORA-0000: [ID 945443.1]

R12 Cannot Enter Any Receipt APP-PO-14142 rcv_receipts_th.insert_transaction-001: ORA-0000: [ID 945443.1] 

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

Modified 21-SEP-2010 Type PROBLEM Status PUBLISHED 

In this Document
Symptoms
Changes
Cause
Solution
References



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



Applies to: 
Oracle Inventory Management - Version: 12.0.0 to 12.1.1 - Release: 12 to 12.1
Information in this document applies to any platform.
FORM:RCVRCERC.FMB - Enter Receipts 
Symptoms
On R 12.1.1, when attempting to save any Purchase Order Receipt in the Enter Receipts Form RCVRCERC , the following error occurs:

ERROR
APP-PO-14142: rcv_receipts_th.insert_transaction-001:
ORA-0000: normal, successful completion
Cause: A SQL error has occured in rcv_receipts_th.insert_transaction.

Steps To Reproduce:


N> Receiving > Receipts 
Enter the Purchase Order number 
Click Find. 
Receipts form is activated with the PO details. 
Click in Check Box to the left of the line item. 
Press the Save icon. 
Error occurs:
Changes
Migration from R12.0.6 to 12.1.1 / R12.PO.B.1 



Cause
Some files / forms need to be recompiled in a specific order:
Libraries :
RCVRCERH.pld
RCVRCERL.pld
RCVCOTRX.pld

Forms:
RCVRCERC.fmb
RCVCOFND.fmb


Solution
To implement the solution, please execute the following steps:

1. Login as APPS owner and Set the environment on Application tier.

2. cd $AU_TOP/resource

3. Execute the following commands to recompile the libraries:

a. frmcmp.sh module=$AU_TOP/resource/RCVRCERH.pll userid=APPS/output_file=$AU_TOP/resource/RCVRCERH.plx module_type=library batch=yes compile_all=special

a. frmcmp.sh module=$AU_TOP/resource/RCVRCERL.pll userid=APPS/output_file=$AU_TOP/resource/RCVRCERL.plx module_type=library batch=yes compile_all=special

a. frmcmp.sh module=$AU_TOP/resource/RCVCOTRX.pll userid=APPS/output_file=$AU_TOP/resource/RCVCOTRX.plx module_type=library batch=yes compile_all=special

4. cd $AU_TOP/forms/US.

5. Execute the following commands to generate the forms:

a. frmcmp.sh userid=apps/ module=RCVRCERC.fmb output_file=$AU_TOP/forms/US/RCVRCERC.fmx
module_type=form batch=no compile_all=special

b. Now copy the RCVRCERC.fmx to $PO_TOP/forms/US

c. frmcmp.sh userid=apps/ module=RCVCOFND.fmb output_file=$AU_TOP/forms/US/RCVCOFND.fmx
module_type=form batch=no compile_all=special

d. Now copy the RCVCOFND.fmx to $PO_TOP/forms/US

6. Ensure the plx and fmx are generated with proper owner (same as point#1)

7. Log into the apps and Retest