Group Team
In this article, we will see how to disable the Ship Confirm button in Shipping Transaction Form for any specific delivery name using C3 Augument.

Form Name for Shipping Transaction form is WSHFSTRX.

In the C3 Augumenter form, select the Form Name “WSHFSTRX”.
Advance Block

Go to Advance tab.
Enter the sequence number “10”.
In the description, give meaningful name. We have given” Disable Ship Confirm Button when delivery number is 99846385”.
In the event name enter “WHEN-NEW-RECORD-INSTANCE”

we need to give the block name. Block name for the delivery name can be found from the shipping transaction form itself. Select the delivery name is shipping transaction form. Then goto HELP -->Diagnostics-->Examine. We can see that block name is ‘DLVY’.

Enable the Advanced block by selecting the enabled check box.

Condition Block
In the condition block, we can specify the condition when the action need to be executed.
Enter the sequence number as 10.
Next we need to enter the condition type.


Following are the condition type which can be used
a. Item Value
b. Constant
c. SQL Statement
d. Profile Value
e. Application
f. Responsibility
g. User
h. Organization
i. Language

We have selected SQL Statement for the Cond Left Type.
In the cond Left Text, specify the sql statement to be executed.
In this case we have given following
Select name from wsh_deliveries where name =&P_DELIVERY_NAME

&P_DELIVERY_NAME is the parameter. It is explained in later section.

In the Join type select “Equal = “.
In the Cond Right Type, select Constant from the List Value.
In the cond Right Text, enter the valid delivery name when the ship confirm button need to be disabled.
99846385 is a valid delivery name.
Enable the conditions by selecting the enabled check box.
Parameter creation
&P_DELIVERY_NAME is used in the query. We will see how to use it.
Click on the Parameter button.
In the Param Name enter P_DELIVERY_NAME.
In the Param type enter “Item”.

Param value we need to enter the delivery name details. i.e BLOCK.FIELD_NAME
For delivery name, it is DLVY.NAME


Actions Block
In this block we need to specify the action that need to be performed. In our case, we need to disable the Ship Confirm button.
Enter the sequence number as 10.
In the Action type, enter “Set Item Property”.
In the action item we need to specify the Ship Confirm button details. i.e BLOCK.FIELD_NAME

For Ship Confirm button, it is DLVY_BUTTONS.BUTTON5
In the value type, enter ‘ENABLED’.
In the Action Value, enter the value as ‘N’.
Enable the action also.

Open the shipping transaction form and Query based on the delivery name “99846385”.
 
We can see that Ship Confirm button will be disabled.




1 Response
  1. Sridevi K Says:

    Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.


Post a Comment