My Oracle Support Banner

LOCAL BRA 9.1: NF_MTCH_PBL.TOF_PBL And PS_NF_MTCH_PBL.TOF_PO_PBL Are Empty (Doc ID 2580916.1)

Last updated on AUGUST 27, 2019

Applies to:

PeopleSoft Enterprise FIN Purchasing Brazil - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Doc Fiscal: PS_NF_MTCH_PBL.TOF_PBL and PS_NF_MTCH_PBL.TOF_PO_PBL are empty
The fields TOF_PBL and TOF_PO_PBL are empty in match table PS_NF_MTCH_PBL.

Customer needs these fields with values updated for use in match rules.

STEPS
The issue can be reproduced at will with the following steps:
1. Create PO and Dispatch
2. Create PO Receipt
3. Create Fiscal Document with Receipt.
4. Change the Fiscal Document Unit Price
5. Complete NF. Cannot complete. Getting the message:
“The Fiscal Document cannot be completed. (30000,534)”
6. Query: SELECT TOF_PBL, TOF_PO_PBL FROM PS_NF_MTCH_PBL WHERE BUSINESS_UNIT = 'BGPO1' AND NF_BRL_ID = '0000000008';
TOF_PBL and TOF_PO_PBL are blank




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.