Skip to Content
author's profile photo Former Member
Former Member

Missing PCA document in BW during delta extraction of 0EC_PCA_3

Hi experts,

We are using Oracle 10g Data base for our ECC6.0 R/3 system.During BW extraction some of the PCA line item records got missed which gets update in data base table GLPCA in R/3 after successful document creation.

We are in the process of analysis to find out the root cause of the issue as we are approaching year end close.

Please let me know how to get the following logs(Information) in R/3

1.Total time taken in Application server for a particular document which was Entered.

2.Total time taken for a document from posting(Document entry) to successful data base server update.

(OR Application server to Data base server update log details OR Document posting to DB write for a document)

Please treat this as a matter of urgency

Regards

Kumar

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 08:56 AM

    You cant get any of those logs.. as you mentioned in your other post - that's why the safety is there!

    A number of reasons could have caused this - as I mentioned in the other post - including sm13 errors that are fixed at a later time

    To fix it I would take a dump of GLPCT into a flat file - and then take your BW query - find the profit centres using excel or something that are in error then do a repair load

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I thought payment run is only for AP and AR documents.Is Payment run applicable for PCA journal also?

      true the AP and AR postings will come in the PRC4 load in 0EC_PC_1.

      But the other side of the AP and the AR is bank which is posted directly to 0EC_PCA_3.

      Go to the AP posting for the payment - then document overview and you will see the balance sheetposting for the bank

      In th emenu accoutning documents somewhere is the link to the PCA document - you can check there

      The sm13 errors naturalyl wont excist as they have been processed

      This is goign to be a nightmare to try and prove - I gave up trying to do this when I lost some data once

      Yes GLPCA is the line item table that 0EC_PCA_3 reads

      0EC_PCA_1 in full mode reads GLPCT but 0EC_PCA_1 in delta mode - actually creates a proper RSA7 delta queue for GLPCA but summarises into a GLPCT structure(!!! yeah I know!)

      My only requirement is GLPCT data - I currently run this every hour based on the delta queue and also I have a real time read for up to the second reads for importatn queries

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.