Re: Posting Single Ledger

Posted by ErmanArslansOracleBlog on Oct 27, 2016; 5:39pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Posting-Single-Ledger-tp1452p1459.html

Hello

Thanks for your contrubition Roshan.. your comment is helpful.
As you said, the document 1055606.1 is a good place to look, as well.

Saad 's env is 12.1.3 and the following patch fixes a poor performance problem..

Saad,
consider to apply it

Patch 22850140: PSA CONSOLIDATED PATCH FOR MAR-16
 
10109408 UNABLE TO CANCEL OR UNRESERVE PO
11856887 FUNDS CHECK ENHANCEMENT
12414858 R12.1.3 POXPOEPO PERFORMANCE ISSUE DURING QUERY
12746900 BAD PERFORMANCE IN GLLEZL RUN FROM FAGLTRN IN SUMMARY MODE
12965313 BAD PERFORMANCE IN GLLEZL RUN FROM FAGLTRN IN SUMMARY MODE
14563642 PSA ROLLUP PATCH AS OF MAY 2013
16792185 AVAILABLE FUNDS ERROR IF POST ENCUMBRANCE JE FROM AP IN GL FIRST
17589167 ORPHAN RECORDS IN GL_BC_PACKET_ARRIVAL_ORDER FOR INVOICE MATCHED
"17642793 POSTING: SINGLE LEDGER - POOR PERFORMANCE DUE TO PSA RELATED DB OBJECTS." --> you may be hitting this.
17843722 PSA SETUP DIAGNOSTIC FAILS AT BUDGET ASSIGNMENT RANGE - ODX-0458 ROWCOUNT = 0