GINV Multiple Order Schedules Lines With Advance Pay Indicator on One Line As ‘Yes’ and One Line As ‘No’ Rejected on Order With Error When One Schedule Cancelled: PA_IT_ORDER_ADV_PYMT_IND (Doc ID 3049009.1)

Last updated on SEPTEMBER 24, 2024

Applies to:

Symptoms

There are 2 schedules on an order with different Advance Pay Indicator values.
- Schedule #1 is active and has Advance Pay Indicator = 'Yes'
- Schedule #2 is cancelled and has Advance Pay Indicator = 'No'

Code is validating this data coming from G-Invoicing and errors:  PA_IT_ORDER_ADV_PYMT_IND 

Steps to reproduce

1. Create one order with Advance/Non-Advance for BIO (Buyer Initiated Order).
2. Approve from requesting and push to project to complete load program.
3. Reject the order from exception tab.
4. Go to G-Invoicing and cancel one line and submit it
5. Approve it and push to project
6. Order is still showing in Exception because both lines pay indicator is showing different.
7. Again reject the order and go back to G-Invoicing.
8. Restore the cancel line and change the Advance Pay Indicator from 'Yes' to 'No'.
9. Now both lines are in same pay indicatory and cancel the 2 lines and submit.
10. Approve order and pull to projects.
11. Now order is showing in order tab with error: PA_IT_ORDER_ADV_PYMT_IND.

While pulling the order, the code should not consider the cancel lines pay indicator.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.