Tuesday, March 24, 2020

RA Transaction error: The entered amount does not have the correct currency precision

At the creation of RA Transaction standard program went in error with below Error messages:
Check error in Error table: RA_Interface_Errors_All

Error# 1) The supplied amount must match unit selling price times the quantity when you do not use an AutoInvoice Clearing account.

Error# 2) The entered amount does not have the correct currency precision


Failed Reason: If you set the currency precision to 2 digits, you cannot use values with 3 digits for your transactions.

You used more than two precision in Unit Price.


Solution: Use the Manage Auto Invoice Lines spreadsheet to correct the amounts to 2-digit precision.

Use 2-digits precision in Unit Price.

SQL*Loader-128: unable to begin a session ORA-01005: null password given; logon denied


This error related to shell script file.

Error: Username:Password:
            SQL*Loader-128: unable to begin a session
            ORA-01005: null password given; logon denied

Solution: 
            Use $1 parameter  (UID_PWD=$1) in shell script (.prog) file. 


In shell script 1st five parameters are standard.

$0 - Shellscript name
$1 - Oracle username/password
$2 - User_id
$3 - Oracle Applications username
$4 - Concurrent request id

Also from $5, $6 ..... will be the shell script/user defined arguments.


FND-CP-ESP: Child: exec:: No such file or directory

This error is related to Shell Script file.
This issue happened due to below reasons:

1. No proper Soft-Link (Symbolic Link) created
2. Converted .prog file to Unix has accidentally converted in DOS format.

Check or use below steps to resolve the error:

1) Convert File format into UNIX
     dos2unix XXABC_Shell_Scrp.prog XXABC_Shell_Scrp.prog


2) Make sure that file has execution 777 permissions
    $XXABC_TOP/bin/XXABC_Shell_Scrp.prog
    =>chmod 777 XXABC_Shell_Scrp.prog


3) Check symbolic link 
     ln -s $FND_TOP/bin/fndcpesr/ $<PROD_TOP>/bin/<host file name without
extension>.

=>ln -s $FND_TOP/bin/fndcpesr XXABC_Shell_Scrp

Note: Use shell script file without Extension in Symbolic link creation.

Steps to get ZPL code output using Zebra viewer - Online

Introduction ZPL is a print language used by many label printers. A print language is a set of commands that can be used to draw elements li...