Cancel the PO when there is change request exists

 To implement the solution, please execute the following steps:

1. Ensure that you have taken a backup of your system before applying the recommended solution.

2. Run the following scripts in a TEST environment first:

Script#1

---------

UPDATE po_headers_all

SET authorization_status = 'APPROVED', approved_flag = 'Y'

WHERE po_header_id = 10481132;

commit;

Script#2

---------

UPDATE po_line_locations_all

SET approved_flag = 'Y'

WHERE po_header_id = 10481132

AND po_release_id IS NULL

AND approved_flag = 'R';

commit;

Script#3

--------

UPDATE po_action_history

SET action_code = 'NO ACTION',

note = 'This is updated for Bug 5471980 '

WHERE object_id = 10481132

AND object_type_code = 'PO'

AND action_code IS NULL;

commit;

Script#4

---------

UPDATE po_change_requests

SET request_status = 'REJECTED',

change_active_flag='N'

WHERE

(

(DOCUMENT_TYPE='REQ'AND DOCUMENT_HEADER_ID='10635161')

OR

(DOCUMENT_TYPE='PO'AND DOCUMENT_HEADER_ID='10481132')

)

AND REQUEST_STATUS NOT IN ('ACCEPTED', 'REJECTED')

AND INITIATOR = 'REQUESTER';

commit;

Script#5

--------

UPDATE po_requisition_headers_all

SET change_pending_flag = NULL

WHERE requisition_header_id = 10635161; ----------Requisition Header Id

commit;

3. Once the scripts complete, confirm that the data is corrected.

4. If you are satisfied with the results, issue a commit.

5. Confirm that the data is corrected when viewed in the Oracle Applications.

6. If you are satisfied that the issue is resolved, migrate the solution as appropriate to other environments.

Blind Receiving

  Enabling allow blind receiving will default the receiving quantity to “0”, but blind receiving will let the users receive more than what has been ordered  and will not honor the receipt tolerances configured in the systems, be it providing a warning or giving error message to users if the receiving quantity is more than Ordered quantity. 

If business team is okay you can enable blind receiving, but in understanding blind receiving is a functionality to allow users to receive more than what has been ordered without any restrictions.

In general, receiving screens/forms defaults the pending quantity to be received on the Order and users needs to manually change the quantity they are receiving into the system.

If we use blind receiving it might default the quantity to 0 but will impact the Receipt tolerances not being honored. 

Advance Pricing- Promotion- Other Item Discount

 Promotion- Other Item Discount

It means that when you buy the list of products only then discount will be applied on the main product

For example only when you buy the CPU and Keyboard discount will be given for the Monitor.

Select the modifier type as "Other Item Discount". Here i am not going to give any restriction.

Click the define details

Enter the additional buy products and enter the product which need to get discount when we buy the item mentioned in the modifier.

Transaction Process Flow

Now go and create the sales order. The item price for both the items remains the same without any discount . 

The item price for FG test item  is 5 .Only when you enter the 3rd item and save discount will be applied to that.

Action >View adjustments . 10% discount applied to the 3rd Item.

Advance Pricing-Promotion -Item Upgrade

 Promotion -Item Upgrade 

To use Item upgrade option 1st you have to set Item relationships

When you order From item,  To item will be delivered instead when qty meets the range specified.

Set the Modifier Type as " Item Upgrade" and the Volume Type and Range.

Provide the Upgrade Item

Transaction Process Flow

Create the sales order. Now when the qty exceeds the value 5 it will update "To Item" in the sales order with same price.

Once you save the order. The ordered item got changed automatically 

Once you save the new item will get upgraded. When you save the modifier will be in effect . The Item number will change but with same price.

Output

1. Item #TRB1H-87956  is the old item example shampoo for 100 ml with price 10

2. Item# FG-Test Item is the new item created because now the same shampoo is given with offer as 150 ml with same price 10 . This is were the item upgrade will be used.

Advance Pricing- Price Break Header

   Discount -Price Break Header

Select the Modifier Type as "Price Break Header"Enter the Break Type as "Point"  and Volume Type as "Item Quantity"Price Break tab will be enabled if modifier is selected as price break header. Select the adjustment type as "Discount".Enter the Price break quantity range to apply the corresponding discount.

It means if you order 5 to 100 qty 10% discount will be applied.

If you order 101 to 150 qty 20% discount will be applied.

If you order 151 to 200 qty 30% discount will be applied.

Transaction Process Flow

Create the sales order. Save the transactions.

Click on Actions > View Adjustments to check the modifier got applied.

Output

The quantity is entered as 150 it falls into the 20%discount.

Which is Unit Price 10 * Discount Percentage 20/100 = 2

New Unit Price :10-2 =8

Advance Pricing- Promotion- Coupon Issue & Discount

  Promotion- Coupon Issue & Discount 

Here in this promotion 1st you can create the discount and then you can restrict the discount . When this discount need to be applied like only when you apply the coupon code discount will be applied.

Enter the Volume Type as "Item Amount" and Break Type as "Point"

Provide the Application Method as Percentage with the Value 

Now this modifier is open we have to restrict it . So only when he issue coupon this discount should be availed by the customer. Only when he buys qty of 1000 value we should issue coupon to him & and should be given 10% discount when we buys more than 200 Dollars

Now he can use the coupon only when it is provided the discount will be availed.

Transaction Process Flow

Create and book the sales order

Click on Actions > View Adjustments

You can use this coupon code for next time discount when you buy more than 200 dollar its based on the limit we set.

New Sales Order

Enter the qty and save the order

Now go to promotion /pricing attribute

Go to Coupons and search the coupon given to u to avail the discount.

Now you can see the 10% discount is availed.

Output

1. If our sales order value is more than 1000 then coupon will be issued. We can make use of this coupon code to get the discount for the upcoming sales order.

2. When we create new order for value greater than 200 we can claim this coupon to get the discount.

3. This value limit is based on what we set at the modifier level.

Advance Pricing-Promotion- Promotional Goods

   Promotion- Promotional Goods

It means if someone buy 2 pants (same item number) will get 1 free pant (same item number) .

Select the Modifier Type as "Promotional Goods" and enter the quantity range to get the modifier applied.

Go to define details

So when you get 2 pant you will get 1 pant totally free as 100% discount

Transaction Process Flow

Create the sales order and the enter the quantity as 2 and save the transaction.

So when you enter quantity 2 , new item created for 1 quantity with free of cost. Which is 100% discount.

Click on View > Adjustments to view the detailed information.