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 laterInformation 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 |