Hi Hasan,
Please see attached screen shot with an error preventing me from executing shipping transaction.
I completed the booking and possibly the pick release but unable to execute the shipping transaction. The attached could help.
Thanks

That is strange. Did you apply any patches recently? Or did you do an upgrade on this environment?
Usually we get this error after the patches are applied.

Try the following:

Recompile all WSH forms using adadmin and retest the issue.

If this does not fix the issue you can try the following:

drop package apps.WSH_DELIVERY_DETAILS_INV;
$WSH_TOP/patch/115/sql/@WSHDDICS.pls;
$WSH_TOP/patch/115/sql/@WSHDDICB.pls;

Retest the issue.

This problem is identified as a bug: 11690745 and there is a patch available.

Hi,
I tried executing the adadmin and got this message. Please advise step step on how to set the appl-top directory on windows xp for the below error message while executing the Adadmin as advised.
I have not applied any patch at all.
I am using Oacle Apps 12.1.1 on wind xp:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\JonG>cd..

C:\Documents and Settings>cd..

C:\>cd oracle

C:\oracle>cd prod

C:\oracle\PROD>cd apps

C:\oracle\PROD\apps>cd apps_st

C:\oracle\PROD\apps\apps_st>cd appl

C:\oracle\PROD\apps\apps_st\appl>cd ad

C:\oracle\PROD\apps\apps_st\appl\ad>cd bin
The system cannot find the path specified.

C:\oracle\PROD\apps\apps_st\appl\ad>cd 12.0.0

C:\oracle\PROD\apps\apps_st\appl\ad\12.0.0>cd bin

C:\oracle\PROD\apps\apps_st\appl\ad\12.0.0\bin>adadmin start

APPL_TOP is not set.
Please set the value of APPL_TOP to your installation directory.

C:\oracle\PROD\apps\apps_st\appl\ad\12.0.0\bin>

You have to source the environment file first before running adadmin.

On linux this is how we do it. Please convert these commands into Windows equivalent (cmd command).

cd PROD
cd apps
cd apps_st
cd appl

. APPSPROD_linux.env (Source environment file)

Keep in mind Oracle bugs and defects are different on Windows than on Linux.

Hi
I have sourced the env file by running a batch file then executed the adadmin as suggested, I will now test the issue again to see if any changes.
Thanks

Hi
Unfortunately, I am still getting same error. I am only able to book the orders and pick but cannoy ship confirm. Any hel with order management shipping transaction will surely help.

Please confirm if you have recompiled the shipping forms and recreated the package. Thanks.

Hi,
I droped the package as suggested:Drop package APPS.WSH_DELIVERY_DETAILS_INV
Please see attached the error message received after compilation with Adadmin and I tried to test it.
For the receation of the mentioned packages, they seem not to exist as this sql below shows:
SQL> select text from user_source where name IN ('WSHDDICB','WSHDDICS');

no rows selected.
Please let me know the steps to recreate the packages.
Thanks

You said you dropped the package as suggested.
But did you recreated the package as well by issuing following commands?
$WSH_TOP/patch/115/sql/@WSHDDICS.pls;
$WSH_TOP/patch/115/sql/@WSHDDICB.pls;

The adadmin utility is simply recompiling forms; it is not recreating your package. You need to recreate it yourself using the command above, and then recompile forms using adadmin.

Hi,
Thanks for your help, but I am now having the following errors after applying the patch, running the package and recompiling the forms.
Hope the package recreation was ok as follows as the was no errors but testing the execution was not possible. So am not sure:
SQL> $WSH_TOP/patch/115/sql/@WSHDDICS.pls;

SQL> $WSH_TOP/patch/115/sql/@WSHDDICB.pls;

SQL> commit
2 ;


Order 1 shipping execution error:
Error: The document category has no valid sequence assigned.
------------------------------------
Warning: Pack Slip information could not be automatically created for delivery 3009.
------------------------------------
Error: No documents submitted.
------------------------------------
Warning: 1 deliveries will be marked as In-Transit/Closed

I already defined a document category and asigned it to a sequence. Profile value for sequence numbering at always used at resp. level but still having the error.

Order 2 shipping exection error:
WSH_CHANGE_SCHED_DATE/Schedule date for delivery detail 12009 has been postponed.
Order 2 error keeps poping up even after disabling the exception.
Please any idea what is going on here?.
Thanks

Hi
I have managed to resolve the pending issue, however, since after the patch application, compilation and etc, My report has been showing :
An error occurred while attempting to establish an applications file server connection with the node FNDFS_. There may be a network configuration problem, or the TNS listener on node FNDFS_may not be running.
SO far I have run the Autoconfig script; stopped and restared the listener services, run the adalnctl script but all to no avail.
Please anthing else I need to to do?
Thanks

There is a series of steps you could take to troubleshoot the issue.
In your scenario I would recommend you rollback to a virtual machine snapshot if you have taken in the past. That will save you from all this trouble.
The attached document lists the steps recommended by Oracle to troubleshoot this issue.