Financial Statement (FS) report cat not be completed

10-11  Source: Network gathering  Views:0 

Advertisement
Hi,
I am running a month-end FS on EBS R12 but it is running very long time and can not
be completed. How do I resolve or tune this program?
I issue a TOP command in my Linux OS and I see this process which eats
all the CPU (100%), How do I know if this process is the the FS program being run (inside the database)?
PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND
9763 oracle 25 0 100 7:35.75 3.6 1121m 146m 142m R oracle
Thanks
I run the commands recommended by metalink...
select ss.sid,se.command,ss.value CPU ,se.username,se.program
from v$sesstat ss, v$session se
where ss.statistic# in
(select statistic#
from v$statname
where name = 'CPU used by this session')
and se.sid=ss.sid
and ss.sid>6
order by ss.sid
For the values of command please look at the definition of V$session in the reference manual.
To find out what sql the problem session(s) are executing, run the following query:
select s.sid, event, wait_time, w.seq#, q.sql_text
from v$session_wait w, v$session s, v$process p, v$sqlarea q
where s.paddr=p.addr and
s.sid=&p and
s.sql_address=q.address;
And I got this processes common SID:
SID EVENT WAIT_TIME SEQ# SQL_TEXT
350 SQL*Net message to client -1 173 select distinct SLJEH.ledger
350 SQL*Net message from client 0 222 select distinct SLJEH.ledger
350 SQL*Net message from client 0 8 select distinct SLJEH.ledger
350 SQL*Net message from client 0 1224 select distinct SLJEH.ledger
350 SQL*Net message from client 0 8 select distinct SLJEH.ledger
350 SQL*Net message from client 0 296 select distinct SLJEH.ledger
350 SQL*Net message from client 0 174 select distinct SLJEH.ledger
350 SQL*Net message from client 0 119 select distinct SLJEH.ledger
350 SQL*Net message from client -1 1052 select distinct SLJEH.ledger
350 SQL*Net message from client -1 552 select distinct SLJEH.ledger
350 SQL*Net message from client 0 10 select distinct SLJEH.ledger
350 SQL*Net message from client 0 708 select distinct SLJEH.ledger
350 SQL*Net message from client 0 3040 select distinct SLJEH.ledger
350 SQL*Net message from client 0 16 select distinct SLJEH.ledger
350 SQL*Net message from client 0 276 select distinct SLJEH.ledger
350 SQL*Net message from client 0 44 select distinct SLJEH.ledger
350 SQL*Net message from client 0 62 select distinct SLJEH.ledger
350 enq: TX - row lock contention 0 614 select distinct SLJEH.ledger
350 SQL*Net message from client 0 34 select distinct SLJEH.ledger
350 SQL*Net message from client 0 235 select distinct SLJEH.ledger
350 SQL*Net message from client 0 44 select distinct SLJEH.ledger
350 Streams AQ: waiting for messages in the queue 0 463 select distinct SLJEH.le
350 Streams AQ: waiting for messages in the queue 0 1492 select distinct SLJEH.le
350 SQL*Net message from client 0 316 select distinct SLJEH.ledger
350 SQL*Net message from client 0 1322 select distinct SLJEH.ledger
350 SQL*Net message to client -1 967 select distinct SLJEH.ledger
350 SQL*Net message from client 0 464 select distinct SLJEH.ledger
350 SQL*Net message from client -1 548 select distinct SLJEH.ledger
350 SQL*Net message from client 0 636 select distinct SLJEH.ledger
350 SQL*Net message from client 0 4 select distinct SLJEH.ledger
350 pipe get 0 359 select distinct SLJEH.ledger
350 pipe get 0 477 select distinct SLJEH.ledger
350 SQL*Net message from client 0 2376 select distinct SLJEH.ledger
350 SQL*Net message from client 0 229 select distinct SLJEH.ledger
350 SQL*Net message from client 0 336 select distinct SLJEH.ledger
350 SQL*Net message from client 0 363 select distinct SLJEH.ledger
350 SQL*Net message from client 0 358 select distinct SLJEH.ledger
350 SQL*Net message from client 0 752 select distinct SLJEH.ledger
350 SQL*Net message from client 0 205 select distinct SLJEH.ledger
350 enq: TX - row lock contention 0 1320 select distinct SLJEH.ledger
350 SQL*Net message from client 0 388 select distinct SLJEH.ledger
350 SQL*Net message from client 0 40 select distinct SLJEH.ledger
350 pipe get 0 337 select distinct SLJEH.ledger
350 SQL*Net message from client 0 6879 select distinct SLJEH.ledger
350 SQL*Net message from client 0 246 select distinct SLJEH.ledger
350 SQL*Net message from client 0 64 select distinct SLJEH.ledger
350 SQL*Net message from client 0 137 select distinct SLJEH.ledger
350 SQL*Net message from client 0 2023 select distinct SLJEH.ledger
350 SQL*Net message from client 0 484 select distinct SLJEH.ledger
350 SQL*Net message from client 0 295 select distinct SLJEH.ledger
350 SQL*Net message from client 0 254 select distinct SLJEH.ledger
350 Streams AQ: waiting for time management or cleanup tasks 0 2 select distinct SLJEH
350 Streams AQ: qmn coordinator idle wait 0 7 select distinct SLJEH.ledger
350 rdbms ipc message 0 705 select distinct SLJEH.ledger
350 rdbms ipc message 0 127 select distinct SLJEH.ledger
350 Streams AQ: qmn slave idle wait 0 2 select distinct SLJEH.ledger
350 SQL*Net message from client 0 4306 select distinct SLJEH.ledger
350 rdbms ipc message 0 5 select distinct SLJEH.ledger
350 rdbms ipc message 0 444 select distinct SLJEH.ledger
350 rdbms ipc message 0 25 select distinct SLJEH.ledger
350 rdbms ipc message 0 6 select distinct SLJEH.ledger
350 smon timer 0 11263 select distinct SLJEH.ledger
350 rdbms ipc message 0 1473 select distinct SLJEH.ledger
350 rdbms ipc message 0 1832 select distinct SLJEH.ledger
350 rdbms ipc message 0 183 select distinct SLJEH.ledger
350 rdbms ipc message 0 7 select distinct SLJEH.ledger
350 rdbms ipc message 0 19 select distinct SLJEH.ledger
350 pmon timer 0 5 select distinct SLJEH.ledger
68 rows selected.
Related articles
  • Financial Statement (FS) report cat not be completed 10-11

    Hi, I am running a month-end FS on EBS R12 but it is running very long time and can not be completed. How do I resolve or tune this program? I issue a TOP command in my Linux OS and I see this process which eats all the CPU (100%), How do I know if t

  • Financial statement version INT does not exist 11-30

    Hello Friends, I hope someone can help me figure this out and I've read discussions similar, just not exactly what I'm looking for.  When I run the following reports: S_ALR_87012271 S_ALR_87012272 S_ALR_87012273 I receive the following error message:

  • Business One Profit and Loss Statement Budget Report Subtotals not Working 11-30

    We are running Business One 9.0 The Budget profit and loss report appears to be badly written. Rather than having the budget data in the same line as the actual, the report creates extra lines for the budgets AND adds more data to the actuals column.

  • Maintain financial statement in sap 10-11

    dear all we work with the following concept when we post any entry we enter fund in fund field because we activate fund mangement  , i need to create financial statement from report painter from transaction code fgi4 and i need to make classification

  • "Your request could not be completed" - Please help? 11-30

    Trying to acquire a few board games - and this message keeps popping up. Can anyone help please? I've tried the "Settings => General => .... " but I don't have "Reset" - so this approach unfortunately doesn't help me....  Some so

  • Financial Statement - FGI3 for fund balance reporting from FMGLFLEXT 10-11

    Hi Guys, We are on ECC 6.0 with PSM and new GL turned on. The issue is that my users want to see the same financial statement as they saw in classic GL with their R/3. SAP has a fund balance report or otherwise the financial statements for public sec

  • Financial Statements report - F.01 10-11

    Hello, I posted this question to the abap forum, but maybe you can help me better. As you know, the account amounts from the financial statement report come from financial documents. And when you create a financial document  you specify a document ty

  • Daily Financial Statement Report 10-11

    I have defined a Trial Balance using a financial statement version. However, the report can only be generated by "posting period", I need to be able to generate my report by "posting date" so as to enable me see the trial balance on a

  • Financial statement generator & Oracle Reports Manager 10-11

    We are moving into Oracle Apps R12.1.3 on Solaris. Most end user machines are Windows 7 & going to be Windows 8. Some are Windows XP. Majority have Microsoft 2007 and some have Microsoft 2010. Financial Statement Generator (FSG) reports are called fr

  • Can S_PLO_86000028 Financial Statement report generate Cost-center report? 11-30

    Dear Experts, I've tried with S_PLO_86000028  Financial Statement report and it could generate report based on Profit Center but when I tried with Cost Center, it show no record.  Can this report generate cost center wise report? regards, AbrahamHi S

  • Financial Statement Report - Special items in FSE2 11-30

    Hi,     I'm trying to rebuild the GL Balance Report using transaction FSE2, but I can't delete or create new "special items" (the red node ones). Anyone knows how to create or delete "special items" at FSE2 to custumize the Financial S

  • Financial Statement report (Tr. F.01) by item hierarchy 11-30

    Hi, I have created hierarchy items in the financial statement version via tr. FSE2. Can I run the financial statement report for such a hierarchy item? Or is it only possible to select the G/L accounts of that hierarchy and create a variant for the F

  • Financial Statement - S_ALR_87012284 Loss not tally 11-30

    Hi Experts, The users informed that the Loss figures for current year.  Period 1 to 3 in 2010 is not correct assigned. Any ideas how to do the troubleshooting? Checked with them, they has carry out the standard monthly closing activities expect to co

  • Financial Statement Version in Report Painter 11-30

    Hi there, Can anybody please assist.  When you have made changes to a FSV, you copy the structure to Report Painter with KE5b - but this is only for GLPCT table (EC-PCA).  Which transaction can be used to do the same for cost centres CCSS table?Hi, 1

  • Net results not apearing in Financial statement 11-30

    Hi We have created a Financial statement verion (FSV) in FSE2 and assigned in a report painter Balance sheet report (FSI5). The issue is the "Net Profit" is not displayed in the report painter report. Its showing in F.01. ThanksDear, Suresh. Is

  • Report which shows to which Financial Statement Version belong the account. 11-30

    Dear All, In transaction FSE3 I can see all accounts in Financial Statement Version, but I need vice versa: for given account I need to know if the account is in the Financial Statement Version (also which area of it). Is there any report to get this

  • Bex Report issue - transaction data of type Char not dispalyed complete 10-11

    Hi BI Expers , I have one issue related to Bex reports here I have complete data loaded in DSO , there is one field Job Title which is having a length of 60 char . When I am executing the report in Bex Analyzer , the value for Job Title is getting tr

  • Error: Your request could not be completed because a failure occurred while the report was being processed. 10-11

    Post Author: sagimann CA Forum: Deployment Hello, I'm not sure if this is due to bad deployment, but I suspect it is, at least due to bad environment. My env is: Solaris 10 64 bit Oracle 10g client installed under /opt/oracle/app/oracle/product/10.2.

  • HP LaserJet Pro 400 Printer M401a (CF270A) is not printing complete statement on letterhead 10-11

    Dear i have supplied printer HP LaserJet Pro 400 Printer M401a (CF270A)Qty 10 to my customer but its not printing complete statement there is missing ink in the words and also spots are coming on the page. the page is letterhead of the company. could

  • F.01 - Financial Statements (Not assigned) 10-11

    Hi, Please give me any tip. I created a financial statement version, all accounts were included. I executed the transaction F.01 (Financial Statements) with mark in ALV tree control (list output), the balance sheet is displayed, I expand subtree, aft