OZF Funds Accrual Engine Not Updating Accurals From Order Management Within Budget Utilization

(Doc ID 388075.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

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

Symptoms

Trade Management User Creates Accrual budget and ships order from Order Management but finds the
accrual is not within Budget Checkbook Utilization after running OZF-TM : Funds Accrual Engine

Steps To Reproduce
(R)
- Create an Accrual Budget
- Create Order within Order Management
- Verify "view Adjustments"
- Modifier from TM is listed
- Ship Order
- Run Auto invoice
- Run Funds Accrual Engine
- Budget Utilizations are not being updated with accrual
- The Budget is not updated

NOTE: To view all messages in the log file debug must be set to yes as a site level profile option


Logfile
+---------------------------------------------------------------------------+
Trade Management: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
OZF_FUND_ACCRUAL module: OZF-TM : Funds Accrual Engine
+---------------------------------------------------------------------------+
Current system time is 20-JUL-2006 16:55:41
+---------------------------------------------------------------------------+
**Starts**20-JUL-2006 16:55:42
**Ends**20-JUL-2006 16:55:42
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
<===> ORDER MANAGEMENT ACCRUALS BEGIN <===>
<====ORDER MANAGEMENT ACCRUALS BEGIN TIME 20/07/06 04:55:42 P.M. ====>
STARTING MESSAGE QUEUE
NO MORE MESSAGES IN THE QUEUE T
/*************************** END OF QUEUE MESSAGE *************************/
QUEUE PROCESSED 0 MESSAGES
START Exception Message .......
<====EXCEPTION QUEUE START TIME 20/07/06 04:55:42 P.M. ====>
In Queue Exception
NO MORE MESSAGES IN THE QUEUE T
END Exception Message Return Code
<====EXCEPTION QUEUE END TIME 20/07/06 04:55:42 P.M. ====>
<====ORDER MANAGEMENT ACCRUALS END TIME 20/07/06 04:55:42 P.M. ====>
x_retcode x_errbuf
<===> ORDER MANAGEMENT ACCRUALS END <===>
<===> REPROCESS ALL FAILED GL POSTING BEGIN <=== >
<====REPROCESS ALL FAILED GL POSTING BEGIN TIME 20/07/06 04:55:42 P.M. ====>
D: Begin posting to GL for all failed postings
D: End successfully posting to GL for all failed postings
<====REPROCESS ALL FAILED GL POSTING END TIME 20/07/06 04:55:42 P.M. ====>
REPROCESS_FAILED_GL_POSTING x_retcode=0 x_errbuf=
<===> REPROCESS ALL FAILED GL POSTING END <===>
<===> POST OFFINVOICE UTILIZATION TO GL BEGIN <===>
<====POST OFFINVOICE UTILIZATION TO GL BEGIN TIME 20/07/06 04:55:42 P.M. ====>
D: post_offinvoice_to_gl() BEGIN
D: l_utilIdTbl count: 0
D: post_offinvoice_to_gl() END
<====POST OFFINVOICE UTILIZATION TO GL END TIME 20/07/06 04:55:42 P.M. ====>
<===> POST OFFINVOICE UTILIZATION TO GL END <===>
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


The following SQL output does not return any records.

SELECT  t.queue, t.enq_time, t.msg_state, t2.price_adjustment_id,
        t2.operation, t2.line_id, t2.list_line_type_code,
        t2.header_id, t2.applied_flag, t2.list_header_id,
        t2.adjusted_amount, t2.last_update_date
FROM    aso.aq$aso_order_feedback_t t, Table(t.user_data.line_adj_varray) t2
WHERE   t.consumer_name = 'OZF'
AND     t2.header_id = (select header_id from apps.oe_order_headers_all
where order_number = &order_number)

no rows selected

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