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:

Symptoms

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

REPLICATION STEPS
---------------------

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

Cause

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