My Oracle Support Banner

FAE Error - D: Post_offinvoice_to_gl(): Exception (Doc ID 2186147.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Trade Management Funds Accrual Engine concurrent request has error 'D: post_offinvoice_to_gl(): exception' when running with parameter 'Repost To GL' set to Y.

 

FAE Log:

------------
<===> POST OFFINVOICE UTILIZATION TO GL BEGIN  <===>
<====POST OFFINVOICE UTILIZATION TO GL BEGIN TIME 04/09/16 07:33:58 P.M.
====>
  D: post_offinvoice_to_gl(): exception
<====POST OFFINVOICE UTILIZATION TO GL END TIME 05/09/16 01:18:01 P.M.  ====>
<===> POST OFFINVOICE UTILIZATION TO GL END  <===>
<===> VOLUME OFFER ADJUSTMENT BEGIN <=== >
<====VOLUME OFFER ADJUSTMENT BEGIN TIME 05/09/16 01:18:01 P.M.  ====>
in api get_volume_2 -- ready to call get_as_of_date_volume
apply discount Y
other values
l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to


SELECT count(*)
  FROM   ozf_funds_utilized_all_b
    WHERE  utilization_type = 'UTILIZED'
    AND    gl_posted_flag = 'N'
    AND    object_type = 'ORDER'
    AND    price_adjustment_id IS NOT NULL;
==> 73,333

l_offer_id/l_qp_list_header_id/l_cust_account_id/l_bill_to/l_ship_to

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.