My Oracle Support Banner

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.