My Oracle Support Banner

LOCAL BRA 9.1: CFOP field not exist in table PS_NF_MTCH_PBL (Doc ID 2580929.1)

Last updated on SEPTEMBER 02, 2019

Applies to:

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

Symptoms

CFOP field not exist in table PS_NF_MTCH_PBL.

Customer needs this field with values to create 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 CFOP FROM PS_NF_MTCH_PBL WHERE BUSINESS_UNIT = 'XXXXX' AND NF_BRL_ID = '0000000008';
CFOP field not exists in NF_MTCH_PBL


Changes

 

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
Changes
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.