3 Replies Latest reply: Dec 18, 2013 10:04 AM by Miguel B RSS

    how to populate this fields in ce_bank_accounts?

    Miguel B

      Hey there, first, i want to apologize for my bad english.

       

      i'm working with Cash management and i'm using this API ce_bank_pub because the bank are internals. i have the load from banks and branch, and kinda the bank accounts, but i can´t find how to populate this fields, that are mandatory for my requeriment:

      AUTORECON_AP_MATCHING_ORDER

      AUTORECON_AR_MATCHING_ORDER  

      RECON_ENABLE_OI_FLAG

      RECON_OI_FLOAT_STATUS

      RECON_OI_CLEARED_STATUS

      RECON_OI_MATCHING_CODE

      AUTORECON_AP_MATCHING_ORDER2

       

      this is my "flow of work", first, i load the data with SQL*Loader in a custom/personal table, after this, i have a cursor that select all the records of this table and do some validations, after this (and if all the records are ok) i use the API ce_bank_pub.

      i don't know if that API support those fields, I've read the documentation but can not find what I require.

      any help will be appreciate.

      thanks a lot.

      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      [SPANISH]

      Estoy trabajando con una carga de bancos, sucursales, cuentas bancarias y usos de cuentas, hasta ahorita todo bien, solo tengo problemas al poblar los campos que se muestran en la parte de arriba en la tabla ce_bank_accounts, estoy utilizando el API ce_bank_pub ya que los bancos son internos.

      mi procedimiento, o la manera que lo hago es ésta:

      cargo los datos con SQL*Loader a una tabla intermedia/temporal por decirlo así, posteriormente un cursor selecciona los datos para realizar las validaciones y las reglas de negocio y si los datos son correctos utilizo el API, eso es en general para las 4 cosas, pero los campos de arriba no se como cargarlo, modificarlos o si hay alguna otra manera para agregarselos.

      cualquier ayuda es apreciada.

      Muchas gracias.

        • 1. Re: how to populate this fields in ce_bank_accounts?
          Miguel B

          ¿alguien que me pueda ayudar?

          ¿someone can help me?

           

          thanks.

          • 2. Re: how to populate this fields in ce_bank_accounts?
            Ivruksha

            Hi Miguel,

             

            hope this helps ...

            AUTORECON_AP_MATCHING_ORDER - Order of matching statement lines to AP transactions, by transactions first or by batch first, lookup type BATCH_OR_TRX
            AUTORECON_AR_MATCHING_ORDER - Order of matching statement lines to AR transactions, by transactions first or by batch first, lookup type BATCH_OR_TRX
            AUTORECON_AP_MATCHING_ORDER2 - Order of matching statement lines to AP transactions, by transactions first or by batch first, lookup type BATCH_OR_TRX_OR_GROUP

            For all the above three fields, navigate to Lookups from Cash Management responsibility and find the lookup type BATCH_OR_TRX, this will have 3 values, B for Batch, G for Group and T for Transaction ..... pass any one of the three value as per your requirement ..

             

            RECON_OI_MATCHING_CODE - Open interface transactions matching code, T for matching by transaction number, D for matching by date and amount. Lookup type: OI_MATCHING_CRITERIA
            For the above field, navigate to Lookups from Cash Management responsibility and find the lookup type OI_MATCHING_CRITERIA, this will have 2 values D for Date and Amount, T for Transaction Number .... Pass any one of the two values as per your requirement ...

             

            RECON_ENABLE_OI_FLAG -  Flag to indicate whether to allow reconciliation of statement lines to open interface transactions, Y or N
            As per your requirement indicate Y or N ....

             

            RECON_OI_FLOAT_STATUS - Code to specify the float status for open interface transactions
            RECON_OI_CLEARED_STATUS  - Code to specify cleared status for open interface transactions
            I am not sure about the above two ...i.e. the values that needs to be passed ...

             

            Regards,

            Ivruksha

            • 3. Re: how to populate this fields in ce_bank_accounts?
              Miguel B

              thanks, but it helps me just a little.

              I have some knowledge of what is each field, the problem here is how to populate them, I've tried with the API I've been using (ce_bank_pub, and filling the bankacct_use_rec_type record) but apparently does not support.

              I have based CE_R12_BANK_MODEL_PUBLIC_API documentation concerning my version.


              anyway, thank you very much and if you know someone who has loaded internal banks would greatly appreciate it.