EBI9.2:BIPVAT00 Job Creates a Huge Log and All SQL Statements Are Contained in the Log

(Doc ID 2189235.1)

Last updated on JANUARY 03, 2017

Applies to:

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


On 9.2 version, BIPVAT00 Job creates a huge log and all SQL statements are contained in the log.


  1. The issue can be reproduced at will with the following steps:
  2. Create contract
  3. Add contract Lines
  4. Add FIN-CA line
  5. Access Billing plans
  6. Assign Immediate Billing method
  7. Add Customer info
  8. Add revenue allocation details
  9. Save contract
  10. Process Contract to create billing interface
  11. INTFC_ID created
  12. Process Billing interface
  13. Process ended in success; access BIPVAT00 process
  14. Check Message log; A great number of SQL statement in the message log


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