EBI9.2:BIPVAT00 Job Creates a Huge Log and All SQL Statements Are Contained in the Log (Doc ID 2189235.1)

Last updated on APRIL 04, 2019

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.

Changes

Cause

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