My Oracle Support Banner

EBI 9.2: BIPRELD Process Abends at BIPRELD.LDLNSTG.UPDREV23 (SQL) When Contract Has Revenue Plan As Billing Manages the Revenue (Doc ID 2619165.1)

Last updated on DECEMBER 20, 2019

Applies to:

PeopleSoft Enterprise FIN Transaction Billing Processor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms



BIPRELD Job Abends at BIPRELD.LDLNSTG.UPDREV23 (SQL). The issue was identified in PUM 33.


ERROR
-----------------------

"SQL Error: ORA-01407: cannot update ("SYSADM"."PS_BI_ACCT_LN_STG"."PROJECT_ID") to NULL".



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Enter amount based contract with milestone bill plan, make sure use project chartfield is unchecked.

2. Add fixed amount event.

3. Add revenue plan as Billing manages revenue.

4. Bring fixed bill event from contracts to billing.
5. Run BIIF0001 to create a bill.
6. Run single action job, preload fails.



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.