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 MAY 16, 2019

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.