1 Reply Latest reply on May 10, 2011 4:08 PM by rkgoud

    Need to populate PO Charge Account in PO Distributions Form

    858905
      Hi

      I am converting legacy PO's into Oracle 11.5.10.
      I need to populate PO Charge Account in PO Distributions Form in Purchase Order for every shipment which is on legacy PO line, which column in PO_DISTRIBUTIONS_INTERFACE table should be populated.
      I could see 6 Segments setup (company,cost center,account,product,initiative,future) in Oracle from the distribution form.
      I am assuming that i need to populate below columns in PO_DISTRIBUTIONS_INTERFACE table.

      CHARGE_ACCOUNT_SEGMENT1
      CHARGE_ACCOUNT_SEGMENT2
      CHARGE_ACCOUNT_SEGMENT3
      CHARGE_ACCOUNT_SEGMENT4
      CHARGE_ACCOUNT_SEGMENT5
      CHARGE_ACCOUNT_SEGMENT6

      Could you let me know if i am right or wrong.

      thanks.
        • 1. Re: Need to populate PO Charge Account in PO Distributions Form
          rkgoud
          Well, you can directly populate the charge_account_id in po_distributions_interface if you know the ccid from gl_code_combinations. In our system, I see that they get charge_account_id from mtl_parameters. It depends how you are receiving these segments and want to default them.

          Even if you use different segment values instead of charge_account_id, the interface may generate new combination. You may have to check the documentation.