Posting Single Ledger
Locked
 
|
Hello Erman,
Can you please tell me about the poor performance tht posting single ledger request is taking a lot of time to complete approx 1 hour and 20 mins. Can you help and tell me what could be wrong? Oracle EBS Release 12.1.3 Database version 11.2.0.4.0 Thanks and Regards, Saad |
Re: Posting Single Ledger
Administrator
|
Hi, What is the short name of the program? 27 Eki 2016 07:32 tarihinde "Saad Qaiser Khan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı: Hello Erman, |
|
|
The short name is GLPPOSS.
|
Re: Posting Single Ledger
|
Administrator
|
The db session of the concurrent request should be investigated...
What is written in its concurrent request logfile? If there is nothing useful written there, enable trace for the concurrent, rerun and check the trace file of the session. Take a look at this Support note: GLPPOSS: Posting Has Poor Performance And is Hanging at INSERT INTO GL_ACCOUNT_HIERARCHIES (Doc ID 746560.1) |
|
|
How could be the db session could be investigated?
This is the output of log file that comes in PSL General Ledger: Version : 12.0.0 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. GLPPOSS module: Posting: Single Ledger +---------------------------------------------------------------------------+ Current system time is 27-OCT-2016 07:18:47 +---------------------------------------------------------------------------+ >> glpmai() 27-OCT-2016 07:18:47 PPOS0003: *** Posting Process Started *** PPOS0004: All phases to posting will be detailed in this log. PPOS0219: glpmai() - Your Posting Run ID is 110700 >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 >> glpini() 27-OCT-2016 07:18:47 >> glpuch() 27-OCT-2016 07:18:47 << glpuch() 27-OCT-2016 07:18:47 >> glpueh() 27-OCT-2016 07:18:47 << glpueh() 27-OCT-2016 07:18:47 >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 << glpini() 27-OCT-2016 07:18:47 >> glppva() 27-OCT-2016 07:18:47 << glppva() 27-OCT-2016 07:18:47 >> glpfcr() 27-OCT-2016 07:18:47 << glpfcr() 27-OCT-2016 07:18:47 >> glpsec() 27-OCT-2016 07:18:47 SHRD0118: Updated 0 record(s) in table: GL_JE_BATCHES SHRD0118: Updated 0 record(s) in table: GL_JE_BATCHES >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 << glpsec() 27-OCT-2016 07:18:47 >> glphok() 27-OCT-2016 07:18:47 << glphok() 27-OCT-2016 07:18:47 >> glpsqi() 27-OCT-2016 07:18:47 << glpsqi() 27-OCT-2016 07:18:47 >> glpcjl() 27-OCT-2016 07:18:47 << glpcjl() 27-OCT-2016 07:18:47 >> glpcbs() 27-OCT-2016 07:18:47 SHRD0118: Updated 1 record(s) in table: GL_JE_HEADERS SHRD0118: Updated 0 record(s) in table: GL_JE_BATCHES SHRD0118: Updated 0 record(s) in table: GL_JE_BATCHES SHRD0118: Updated 0 record(s) in table: GL_JE_HEADERS SHRD0118: Updated 0 record(s) in table: GL_JE_HEADERS SHRD0118: Updated 0 record(s) in table: GL_JE_BATCHES SHRD0118: Updated 1 record(s) in table: GL_JE_HEADERS SHRD0118: Updated 1 record(s) in table: GL_JE_BATCHES SHRD0118: Updated 1 record(s) in table: GL_JE_BATCHES >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 << glpcbs() 27-OCT-2016 07:18:47 >> glpisl() 27-OCT-2016 07:18:47 >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 << glpisl() 27-OCT-2016 07:18:47 >> glpiil() 27-OCT-2016 07:18:47 >> glpince() 27-OCT-2016 07:18:47 SHRD0118: Updated 0 record(s) in table: GL_JE_HEADERS >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 << glpince() 27-OCT-2016 07:18:47 PPOS0247: There are no intercompany or intracompany journals that require balancing. << glpiil() 27-OCT-2016 07:18:47 >> glpcib() 27-OCT-2016 07:18:47 << glpcib() 27-OCT-2016 07:18:47 >> glpmni() 27-OCT-2016 07:18:47 SHRD0147: Finished processing rows << glpmni() 27-OCT-2016 07:18:47 >> glperp() 27-OCT-2016 07:18:47 >> glperp() 27-OCT-2016 07:18:47 >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 << glperp() 27-OCT-2016 07:18:47 >> glpsqp() 27-OCT-2016 07:18:47 << glpsqp() 27-OCT-2016 07:18:47 >> glpipi() 27-OCT-2016 07:18:47 SHRD0117: Inserted 2 record(s) into GL_POSTING_INTERIM >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 SHRD0117: Inserted 0 record(s) into GL_POSTING_INTERIM >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 >> glugts() 27-OCT-2016 07:18:47 << glugts() 27-OCT-2016 07:18:47 << glpipi() 27-OCT-2016 07:18:47 >> glpip2() 27-OCT-2016 07:18:47 PPOS0206: No statistical amounts in monetary journal entries found ... << glpip2() 27-OCT-2016 07:18:47 >> glpidi() 27-OCT-2016 07:18:47 SHRD0117: Inserted 2 record(s) into GL_DAILY_POST_INT1 >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 SHRD0117: Inserted 2 record(s) into GL_DAILY_POST_INT1 >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 SHRD0117: Inserted 4 record(s) into GL_DAILY_POST_INT >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 >> glugts() 27-OCT-2016 07:18:47 << glugts() 27-OCT-2016 07:18:47 << glpidi() 27-OCT-2016 07:18:47 >> glpire() 27-OCT-2016 07:18:47 << glpire() 27-OCT-2016 07:18:47 >> glpsum() 27-OCT-2016 07:18:47 << glpsum() 27-OCT-2016 07:18:47 >> glpitr() 27-OCT-2016 07:18:47 >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 << glpitr() 27-OCT-2016 07:18:47 >> glpidt() 27-OCT-2016 07:18:47 SHRD0117: Inserted 0 record(s) into GL_DAILY_POST_INT >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 << glpidt() 27-OCT-2016 07:18:47 >> glpibr() 27-OCT-2016 07:18:47 >> glpibr.concurrency() 27-OCT-2016 07:18:47 << glpibr.concurrency() 27-OCT-2016 07:18:47 SHRD0147: Finished processing rows SHRD0117: Inserted 0 record(s) into GL_BALANCES >> glpidb() 27-OCT-2016 07:18:47 SHRD0117: Inserted 0 record(s) into GL_DAILY_BALANCES << glpidb() 27-OCT-2016 07:18:47 >> glucmt() 27-OCT-2016 07:18:47 << glucmt() 27-OCT-2016 07:18:47 << glpibr() 27-OCT-2016 07:18:47 >> glpubr() 27-OCT-2016 07:18:47 >> glpubr.concurrency() 27-OCT-2016 07:18:47 << glpubr.concurrency() 27-OCT-2016 08:35:30 SHRD0147: Finished processing rows SHRD0118: Updated 2 record(s) in table: GL_BALANCES SHRD0117: Inserted 0 record(s) into GL_BALANCES_DELTA >> glpudb() 27-OCT-2016 08:38:39 SHRD0118: Updated 4 record(s) in table: GL_DAILY_BALANCES << glpudb() 27-OCT-2016 08:38:39 >> glpfdel() 27-OCT-2016 08:38:39 SHRD0119: Deleted 0 record(s) from GL_BC_PACKETS. SHRD0119: Deleted 0 record(s) from GL_BC_PACKETS. << glpfdel() 27-OCT-2016 08:38:39 SHRD0118: Updated 2 record(s) in table: GL_JE_LINES SHRD0118: Updated 1 record(s) in table: GL_JE_HEADERS SHRD0118: Updated 1 record(s) in table: GL_JE_HEADERS SHRD0118: Updated 1 record(s) in table: GL_JE_BATCHES SHRD0118: Updated 1 record(s) in table: GL_JE_BATCHES >> gl_bc_dual() 27-OCT-2016 08:38:39 << gl_bc_dual() 27-OCT-2016 08:38:39 >> glucmt() 27-OCT-2016 08:38:39 << glucmt() 27-OCT-2016 08:38:39 >> glucmt() 27-OCT-2016 08:38:39 << glucmt() 27-OCT-2016 08:38:39 << glpubr() 27-OCT-2016 08:38:39 >> glncbe() 27-OCT-2016 08:38:39 >> glutbe() 27-OCT-2016 08:38:39 << glutbe() 27-OCT-2016 08:38:39 >> glusbe() 27-OCT-2016 08:38:39 << glusbe() 27-OCT-2016 08:38:39 << glpcbe() 27-OCT-2016 08:38:39 >> glpsqx() 27-OCT-2016 08:38:39 << glpsqx() 27-OCT-2016 08:38:39 >> glucmt() 27-OCT-2016 08:38:39 << glucmt() 27-OCT-2016 08:38:39 PPOS0037: **** POSTING IS NOW COMPLETE *** << glpmai() 27-OCT-2016 08:38:39 +---------------------------------------------------------------------------+ Executing request completion options... Output file size: 1194 +------------- 1) PRINT -------------+ Printing output file. Request ID : 18437318 Number of copies : 0 Printer : noprint +--------------------------------------+ Finished executing request completion options. +---------------------------------------------------------------------------+ Concurrent request completed successfully Current system time is 27-OCT-2016 08:38:39 +------------------------------------------------------- |
Re: Posting Single Ledger
|
Administrator
|
Enable db trace for the concurrent program , run the concurrent program and then check the concurrent request db trace file. For enabling trace for the conc. program, use conc define form.. check oracle documentation for details. 27 Eki 2016 09:08 tarihinde "Saad Qaiser Khan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı: How could be the db session could be investigated? |
|
|
Hello Erman/Saad,
I came across similar issue for Posting Ledger in August. I contacted Oracle Support. I had to apply all the patches for 12.2 in the doc below: 1055606.1 and the functional team did the rest. You can do a clone/backup of your instance and test it IMG_03082016_140759.png Hope this helps :) Regards, Roshan |
Re: Posting Single Ledger
|
Administrator
|
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 |
|
|
Thanks Erman/Roshan,
Will test these in the Test environment tomorrow. Thanks and Regards, Saad |
|
|
Hello,
Can you please recommend me some good document or you can tell that how to check already applied patches of database and how to apply patch? I have check on the internet but getting some error of oraInst.loc while checking for already applied patches. Do I have to run this command on certain specified location. Like I am running this command opatch lsinventory -details on /home/oracle but it throws this error. Cannot open the file: /etc/oraInst.loc Please use -invPtrLoc option and specify the correct file for OPatch to look for central inventory. Thanks and Regards, Saad Khan |
Re: Posting Single Ledger
|
Administrator
|
It seems you have no central inventory pointer file (/etc/oraInst.loc). I dont know if you have central inventory either. But, lets 'see by the quick solution for below;
We will use the oraInst.loc locataed in your ORACLE_HOME... Login to your OS with the RDBMS owner (i.e oracle) set your environment Then include opatch in your PATH ; [oracle@erman dbhome_1]$ export PATH=$PATH:$ORACLE_HOME/OPatch Lastly use your oraInst.loc file located in the $ORACLE_HOME for the Inventory Pointer Location. [oracle@erman dbhome_1]$ opatch lsinventory invPtrLoc=$ORACLE_HOME/oraInst.loc This will do the work.. You can get opatch related info from docs.oracle.com : https://docs.oracle.com/cd/E11882_01/em.112/e12255/title.htm Universal Installer and OPatch User's Guide |
Re: Posting Single Ledger
|
Administrator
|
Hi Saad,
Also for the future; please open a new issue when the question you ask is not related with the current issue. Thanks |
«
Return to EBS 12.2
|
1 view|%1 views
| Free forum by Nabble | Edit this page |