My Oracle Support Banner

R12.2.9 AP: Unable to See the Requester Information in Invoice Workbench Though in Table AP_INVOICE_LINES_ALL the field REQUESTER_ID is NOT NULL (Doc ID 2742382.1)

Last updated on DECEMBER 07, 2023

Applies to:

Oracle Payables - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR
---------------
Unable to see the requester information in invoice workbench though in table AP_INVOICE_LINES_ALL, REQUESTER_ID is NOT NULL

EXPECTED BEHAVIOR
-----------------------
Should be able to see requester information in invoice workbench if in table AP_INVOICE_LINES_ALL, REQUESTER_ID is NOT NULL

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Query invoice in workbench
2. Requester filed is empty

Note: It's not only Requester field  that could appear null . Several other fields that can appear null after saving like:  Default Distribution Account, Purchasing Category, Product Type, Business Category fields

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


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