MOAC On The Scheduling Organizer Screen has No Data Found Error (Doc ID 2794313.1)

Last updated on JULY 26, 2021

Applies to:

Symptoms

Find when using MOAC multi org error in scheduling organizer screen not able to process the records for any other org than the default org .
We have setup the MOAC profiles to show records for all the orgs but when we try to process any org present on screen other than the default org for that Responsibility the following error occurs



ERROR
-----------------------
Debug file
ORA-01403: no data found value of customer trx type id 0 in no data found for cust_trx_type_id - tax code

Form
ORA-01403: no data found oe_order_cache procedure get_tax_calculation




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate: Order, Returns > Order Organizer > go to tab Scheduling > populate the Internal Item and remove the default operating unit
You will see records of different operating units
Try to change the QTY reserved for the operating unit other than default one
Below error pops up and the record can not be processed further. Also the operating unit on
error screen is default operating unit even when selected operating
MOAC profile setup for reference
3. Receive Errors:
Debug file
ORA-01403: no data found value of customer trx type id 0 in no data found for cust_trx_type_id - tax code

Form
ORA-01403: no data found oe_order_cache procedure get_tax_calculation

Cause

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