Author Archives: All Oracle Apps

Assign Delivery Details to Delivery

Assigning Delivery Details to Delivery

Based on the delivery details assigned to the sales Order find the delivery detail id. Now we are trying to attach the Delivery Details to the New delivery which is created.

The delivery detail can be assigned to the newly created delivery by using the public API “WSH_DELIVERY_DETAILS_PUB. Detail_to_Delivery”. Continue reading

Related posts:

Create a New Delivery for an Existing Order

Create a New delivery for an existing Sales Order

We have created a Sales Order from Back End using the Sales Order API in Booked Status. The order Number Is: 66401. When an Order is in Booked status a delivery detail’s are created and which can be viewed from Shipping –> Transactions form from Front End.

Find out the existing Ship To Location Id, ship from location id, Organization id using the following Script:

 

Sample script to create Deliveries:

Once the delivery is Created look at wsh_new_deliveries for this delivery_id:

 

Related posts:

Create Delivery API

Creating a New Delivery:

Sample Script to Create a New Delivery with respect to its Location:

Result:
New Delivery ID : 3772374
New Delivery Name: AOATest-001

Script to verify the API:

 

 

Related posts:

Release Holds on a Sales Order

Release Holds on a Sales Order:

Sample code to release a Sales Order Hold:

 

Related posts:

Workflow with Approval Notification

Creating WF Local Roles:

Adhoc roles can be created through PL/SQL from database or they can be created from Applications using User Management Responsibility. If PL/SQL is used to create roles, all user names and role names in UPPER case to avoid some errors:

Script to Create an Adhoc Role:

 Script to validate WF Roles:

 Script to Add user to an already existing Adhoc Role:

 Script to Remove user from an existing Adhoc Role:

Using Adhoc roles in workflow notifications:
Once the Roles are created in the database we can load the Roles from database as discussed from Oracle Worflow Builder as below:

Navigation: File > Load Roles from Database

Select roles you want to use and then click OK.

NEW_XAOA_NF028

NEW_XAOA_NF029

Open the notification properties and then navigate to node tab, select performer as the role you just created and loaded from database.

Modified Package Code:

Sample Code to test the workflow:

 Sample scripts to test the Workflow:

Once triggered See the below Approval Notification for either Workflow –> Notifications or directly on the screen depending on the Profile Option setup:

NEW_XAOA_NF023

Open the Notification:

NEW_XAOA_NF024

Once Approved see the Activity history or Status Diagram from Status Monitor. This can be done at any stage of the workflow once kicked off. Usually while debugging this is the first place we need to check and then check in wf tables.

NEW_XAOA_NF025

NEW_XAOA_NF026

NEW_XAOA_NF027

 

Some of the workflow tables:

WF_LOOKUP_TYPES_TL
WF_MESSAGES
WF_MESSAGE_ATTRIBUTES
WF_NOTIFICATION_ATTRIBUTES
WF_ITEM_ATTRIBUTES
WF_ITEM_ACTIVITY_STATUSES

WF_ITEM_ATTRIBUTE_VALUES

Please respond if any questions.

Related posts: