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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms