Clarity

  • 1.  XOG of financial transaction

    Posted Sep 26, 2013 06:33 PM
    I´m trying to XOG a new transaction. This is my XML write file:

    <?xml version="1.0" encoding="UTF-8"?>
    <!-- edited with XML Spy v4.3 U (http://www.xmlspy.com) by Murali (Niku Corporation) -->
    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:noNamespaceSchemaLocation="../xsd/nikuxog_inboundTransaction.xsd">
    <Header action="write" externalSource="ORACLE-FINANCIAL" objectType="transaction" version="6.0.11"/>
    <Transactions>
    <Transaction

    externalID="1"

    chargeCode="capital"

    chargeable="1"

    inputTypeCode="execution"

    projectID="PRJ-00000123"

    resourceID="xxxxx"

    taskID="5005141"

    transactionDate="2013-09-23"

    transactionType="L"

    actualCostRate="5845.29"

    billRate="5845.29"

    importStatus="N"

    voucherNumber="NF004"

    units="1">
    </Transaction>

    </Transactions>
    </NikuDataBus>

    And this is the result of the XOG:

    <XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
    <Object type="transaction"/>
    <Status elapsedTime="0.136 seconds" state="SUCCESS"/>
    <Statistics failureRecords="0" insertedRecords="1" totalNumberOfRecords="1" updatedRecords="0"/>
    <Records/>
    </XOGOutput>


    So, apparently everything went fine, but where is my transaction? Looking through another post I´ve seen the suggestion of running the job: "Post Transactions to Financials". I did it, but still could not find the transaction.

    Any help is welcome.


  • 2.  RE: XOG of financial transaction

    Posted Sep 26, 2013 08:13 PM
    After the transaction is imported,

    1. Run Post Transactions to Financials
    2. Post to WIP
    3. Import Financial Actuals
    4. Time Slicing
    5. Investment Allocations


  • 3.  RE: XOG of financial transaction

    Posted Sep 27, 2013 01:40 AM
    Post transactions to financials, would process timesheet transactions only. The Voucher transactions would be readily available in transactions list once XOGGed in.

    Once the voucher transactions are XOGGed in, they must appear in transactions list on GUI, and the records should be in PPA_TRANSCONTROL. Then you can run Post to WIP. This would move the transactions records to table PPA_WIP.

    Regards
    Chandrani


  • 4.  RE: XOG of financial transaction

    Posted Sep 27, 2013 03:05 AM
      |   view attached
    .


  • 5.  RE: XOG of financial transaction

    Posted Sep 30, 2013 08:50 AM
    From the messages I understand that I did everything right and that the transaction should appear. Yet, it is not there. I get success on the XOG but the transaction is nowhere to be seen. Any ideas on how to troubleshoot this? I´m sure I must be doing something simple wrong, but have no idea what it could be.

    Thanks


  • 6.  RE: XOG of financial transaction

    Posted Sep 30, 2013 09:03 AM
    Hello Victor,

    It looks like, this issue needs more troubleshooting, I guess you would be needing to raise a case with CA Support.

    Regards
    Chandrani


  • 7.  RE: XOG of financial transaction
    Best Answer

    Posted Sep 30, 2013 03:16 PM
      |   view attached
    I have 12.1.0.5840 0.1 003
    If I XOG in

    <?xml version="1.0" encoding="UTF-8"?>
    <!-- edited with XML Spy v4.3 U (http://www.xmlspy.com) by Murali (Niku Corporation) -->
    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:noNamespaceSchemaLocation="../xsd/nikuxog_inboundTransaction.xsd">
    <Header action="write" externalSource="ORACLE-FINANCIAL" objectType="transaction" version="6.0.11"/>
    <Transactions>
    <Transaction
    externalID="1"
    chargeCode="Capital"
    chargeable="1"
    inputTypeCode="normal"
    projectID="zCompleted"
    resourceID="kinnunenad"
    taskID="5000730"
    transactionDate="2009-05-22"
    transactionType="L"
    actualCostRate="120"
    billRate="150"
    importStatus="N"
    voucherNumber="NF004"
    units="2">
    </Transaction>

    </Transactions>
    </NikuDataBus>

    which is the sample file slightly modified to match my project, resource and other data.

    It goes in without errors.

    If I query

    SELECT [PAC_IMP_HEADER_ID]
    ,[SOURCEMODULE]
    ,[TRANSIMPORTKEY]
    ,[EXTERNALTRANSNO]
    ,[EXTERNALBATCHID]
    ,[TRANSTYPE]
    ,[TRANSDATE]
    ,[QUANTITY]
    ,[RATE]
    ,[COST]
    ,[CHARGEABLE]
    ,[NOTES]
    ,[SITE]
    ,[IMPORTSTATUS]
    ,[IMPORTDATE]
    ,[ERRORCODE]
    ,[WORKINT]
    ,[WORKBUF]
    ,[PROJECT_CODE]
    ,[COMPANY_CODE]
    ,[IMPORTEDBY_RESOURCE_CODE]
    ,[RESOURCE_CODE]
    ,[ROLE_CODE]
    ,[JOB_ID]
    ,[EXTERNAL_ID]
    ,[TASKID]
    ,[RATE_CURRENCY]
    ,[COST_CURRENCY]
    ,[EXTERNAL_SOURCE_ID]
    ,[APPLY_TO_EXTERNAL_ID]
    ,[CHARGE_CODE]
    ,[INPUT_TYPE]
    ,[FATALERROR]
    ,[TRANSCLASS]
    ,[USER_LOV1]
    ,[USER_LOV2]
    ,[EXPENSE_TYPE]
    FROM [c8a].[niku].[IMP_TRANSACTIONIMPORT]
    Where transdate < '2010-01-01'

    I get

    0
    50
    5000044
    NULL
    NULL
    L
    2009-05-22 00:00:00.000
    2.000000
    150.000000
    120.000000
    1
    NULL
    NULL
    N
    2013-09-30 21:49:14.297
    0
    NULL
    NULL
    zCompleted
    NULL
    NULL
    kinnunenad
    NULL
    NULL
    1

    I can also see in in the Invalids.
    So it is ready for the first step in Atul's list

    Whether or not it will go further from there in Transaction port to Financials depends if the normal criteria is met.
    I did not yet test if the rates in the file will honoured and the other data licke the voucher number will be passed on to WIP in later processing.


    Martti K.




    .


  • 8.  RE: XOG of financial transaction

    Posted Oct 02, 2013 04:57 PM
    You need to send in a group id if you want the invoice (voucher) to show up in Clarity.
    See this post
    101474045


  • 9.  RE: XOG of financial transaction

    Posted Oct 02, 2013 05:02 PM
    If there is no field with the name invoice(voucher) in IMP_TRANSACTIONIMPORT where would the value go?

    Martti K.

    Edit

    Looking at the referenced thread it goes
    pac_imp_transimport_header > ppa_transcontrolapinfo > ppa_wipapinfo
    after XOGIng and moves during processing.


  • 10.  RE: XOG of financial transaction

    Posted Oct 02, 2013 04:57 PM
    You need to send in a group id if you want the invoice (voucher) to show up in Clarity.
    See this post
    101474045