Project Management

Get Involved. Join the Conversation.

Topic

    Avesh Ganodwala
    Cost center COA value is getting picked as per the...
    Topic posted July 30, 2018 by Avesh GanodwalaSilver Medal: 2,000+ Points 
    98 Views, 4 Comments
    Title:
    Cost center COA value is getting picked as per the Department effective
    Content:

    Hi,

     

    We have changed the project organization cost center value in manage department. As per the SLA, the account to derive the cost center segment is 

    Value Type Value
    Source Expenditure Organization Cost Center Segment
    Value Type Value
    Source Expenditure Organization Cost Center Segment

     

    The effective date of the change in manage department is as of today but i am processing a transaction with today's date, the updated cost center value isn't getting picked in the create accounting process.

     

     

    Comment

     

    • MANISH S

      Hi Avesh,

      Hope you are referring to PO Receipt/ AP Invoice transactions. Create Accounting process picks the account that is available in the transaction. SLA rules are for defaulting the required account in the transactions. Please verify the accounts for transactions performed after updating the SLA rule.

      Regards,

      Manish

    • Dustin Grabowski

      First a bit of clarification on the earlier response.

       

      Create Accounting process picks the account that is available in the transaction.

          Correct, based on the seeded accounting configuration.. However the account can be changed, see next response.

      SLA rules are for defaulting the required account in the transactions.

         Not totally correct.  There is a mechanism to derive and default charge accounts, etc. on procurement and other types of documents called Transaction Account Builder (TAB). This uses the same mechanisms; account rules, mapping sets, etc., however does not result in an accounting transaction being created.  Once the Account is defaulted/entered onto a transaction, when the Receipt or Invoice is actually accounted, the delivered rules will look at that account.  However that account can also be changed by creating new Account Rules and assigning them to the respective Journal Entry Rule Sets for the impacted Event Classes.  For Project based work this is pretty typical, as the project attributes will drive the final account and potentially override the 'defaulted' account. 

       

      For the specific question around the date effective changes on the organization.  The view used to extract the project organization cost center source uses the Sysdate to get the current version of the organization definition.  I'm curious if you are facing the same issue today, to eliminate any potential time stamp issues?

       

      Also, using the Subledger Accounting diagnostic along with the Subledger Accounting Setup Report is the best place to start when finding any of these types of issues.

       

      https://docs.oracle.com/en/cloud/saas/financials/18b/fausl/create-accounting.html#FAUSL734067

       

    • Avesh Ganodwala

      Hi Dustin and Manish,

       

      I did check today again now the project organization cost center source is using the Sysdate to get the current version of the organization definition.

       

      Thank you for the response and help.

       

      Regards,

      Avesh Ganodwala