R12 R11 PAXINRVW: APP-FND-00698: Flexfield Segment Combination Not Found (Doc ID 375050.1)

Last updated on JUNE 06, 2016

Applies to:

Oracle Project Billing - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
FORM:PAXINRVW.FMB - Invoices



Symptoms

In the PAXRVRVW Revenue Review screen (Project Billing Super User> Billing > Revenue Review)

When trying to query revenue for the project, the following error is received:

APP-FND-00698: Flexfield segment combination not found.

Details:
" APP-FND-00588: Program error: An error has occurred while looking up a
flexfield segment combination. Please inform your support representative that:

The FND_FLEX_SERVER validation function has encountered a null or negative
combination ID (-107379825) while trying to look up the segment values for this
combination. This may indicate an invalid entry in the unique ID column of the
combinations table.

Inform your system administrator that the combination identified by the unique
ID number 64 could not be found in the combinations table for the flexfield
structure identified by Application = SQLGL, Flexfield Code = GL# and
Structure Number 101 "

The log file for PATTGL module: PRC: Interface Revenue to General Ledger shows:

+===============================+
| Transferring Revenue to GL |
+===============================+
Current system time is 23-JUN-2006 19:00:46

Gain and Loss flag for Implementaion level : Y
Enabled the Realized gain and loss account ...
......

Calling AutoAccounting to fetch a set of code combination IDs
Current system time is 27-JUN-2006 10:33:39
*****************************
Entering paaaui()
Current system time is 27-JUN-2006 10:33:39
Entered paaffc
select CODE_COMBINATION_ID,
enabled_flag,
nvl(to_char(start_date_active, 'J'), -1),
nvl(to_char(end_date_active, 'J'), -1),
SEGMENT5||'.'||SEGMENT1||'.'||SEGMENT2||'.'||SEGMENT3||'.'||SEGMENT4||'.'||SEGMENT6||'.'||SEGMENT7||
'.'||SEGMENT8,detail_posting_allowed_flag,summary_flag
from GL_CODE_COMBINATIONS
where CHART_OF_ACCOUNTS_ID = 101
and SEGMENT5 in ('','10201','10601','20503','40205')
order by SEGMENT5, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT6, SEGMENT7, SEGMENT8
paaffc : num_flex = 11494
paaffc: Before paafui call check: mc_ptr=0, mc_end_ptr=5
Warning in Flex Validation for line '321'
Null GL# 101 key flexfield is not allowed
Warning in Flex Validation for line '321'
Null GL# 101 key flexfield is not allowed
paafui: In paafui, decrementing mcptr: mc_ptr=6, mc_end_ptr=5
Leaving paaaui()
Current system time is 27-JUN-2006 10:33:39
*****************************
AutoAccounting returned 6 code combination IDs
Current system time is 27-JUN-2006 10:33:39
AA ERROR while validating CCIDs for project_id 321
Transferring all revenues for project ID=321. AutoAccounting error code=4
Current system time is 27-JUN-2006 10:33:39
Determining project level WIP amounts.
Current system time is 27-JUN-2006 10:33:39
Project level WIP: Unbilled Receivable=0, Unearned Revenue=465000
Current system time is 27-JUN-2006 10:33:39
Locking a set of draft revenues to transfer
Current system time is 27-JUN-2006 10:33:39
Opening a cursor to fetch draft revenues to transfer
Current system time is 27-JUN-2006 10:33:39
Currency Code : USD
Current system time is 27-JUN-2006 10:33:39
Computing WIP for revenue # 1 of project # 321. Current system time is 27-JUN-2006 10:33:39
patwip: Rejecting because Auto accounting error
patwip: Rejecting revenue 1 of project 321 with code AA_FAIL
patwip : After calling patcua: Realized gain amount .. = Realized loss amount .. =
patwip: Realized gain amount = Realized loss amount = RgainCCid = -1073798288 RlossCCid =
-1073798284
Current system time is 27-JUN-2006 10:33:39


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms