Today I was releasing the transport request at that time I was able to release the child request but parent request was giving the error like " Test call of transport control program (tp) ended with return code 0232"
This error is coming because of SAPSR3 user is expired in database.
SAP has suggested a note (1519872 - SAP Database User Profile SAPUPROF) for this & now from Oracle 11G onwards we have to change the password of SAPSR3 user in every 6 months.
Change the password through BRTOOLS to update the same in SAPUSER table as well.
To avoid the change of password every 6 months download the profile script attached with the above note.
Run the script as per note & check the below command in sqlplus prompt to confirm the expiry date of users.
SQL > select USERNAME, ACCOUNT_STATUS, EXPIRY_DATE from dba_users;
Cheers.... :)
