R12.2.5 Instance: Missing Pay_awt_group_id And Pay_awt_group_name fields at 'Payables Open Interface Invoices' form

Last updated on JANUARY 04, 2017

Applies to:

Symptoms

On : 12.2.5 version, Invoice Issues & MassAdd

ACTUAL BEHAVIOR
---------------
When Users access the 'Open Interface Invoices' form at Payables responsibility -
Users could not select the Folder created with query including the fields - pay_awt_group_id and pay_awt_group_name
to enter the Invoice Interface information at 'Open Interface Invoices' form (APXIIFIX).


EXPECTED BEHAVIOR
-----------------------
When Users access the 'Open Interface Invoices' form at Payables responsibility -
Users must be able to enter the payment withhholding tax group information.
Fields - PAY_AWT_GROUP_ID and PAY_AWT_GROUP_NAME must be made available at 'Open Interface Invoices' form (APXIIFIX.fmb file).


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Payables Responsibility and open the 'Open Interface Invoices' form to enter / view the Invoice Interface data.
2. From the Menu, Select the Folder created with query including the fields - PAY_AWT_GROUP_ID and PAY_AWT_GROUP_NAME
3. The following message appears -
FRM-40105: Unable to resolve reference to item INVOICES_PROMPT.PAY_AWT_GROUP_ID

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot -
have the Payables Invoices created through interface program - 'Payables Open Interface Invoices' that have payment withhholding tax groups.
enter or view the payment withhholding tax group data available at the Invoice Interface tables.

Cause