3 Responses to R12 Customer Bank Accounts

  1. Apps says:

    Your query does not returen any data

  2. Bobby says:

    I have a package that works in Oracle Apps 11i instance. This package is using 11i tables in its cursors. we are moving this package to r12 and thus this package has to run in r12 using r12 tables. I have heard that a lot of tables have been changed from 11i to r12 in oracle financials. here is the code.
    Some of the tables in the AP that were used in 11i were AP_BANK_ACCOUNTS_ALL, AP_BANK_BRANCHES, AP_CHECKS_ALL,

    AP_INV_SELECTION_CRITERIA_ALL,

    fnd_lookup_values_vl. I need to know their R12 counterparts or the R12 tables that needs to be inserted here.

    SELECT DISTINCT abb.attribute1 attribute1

    FROM APPS.ap_bank_accounts_all ABA,

    APPS.ap_bank_branches ABB,

    XXAP.XXAP_CD_PAYBATCH_APPR_OUT XCOUT,

    APPS.AP_INV_SELECTION_CRITERIA_ALL AISC

    WHERE aisc.checkrun_id = xcout.batch_id

    AND aisc.bank_account_id = aba.bank_account_id

    AND aba.bank_branch_id = abb.bank_branch_id

    SELECT ABB.ATTRIBUTE1 MESSAGE_ID,

    FROM APPS.AP_BANK_ACCOUNTS_ALL ABA,

    APPS.AP_BANK_BRANCHES ABB,

    APPS.AP_CHECKS_ALL CHK,

    APPS.AP_INV_SELECTION_CRITERIA_ALL AISC,

    APPS.fnd_lookup_values_vl FLV,

    XXAP.XXAP_APP_OUT XCOUT

    WHERE ABA.bank_branch_id = ABB.bank_branch_id

    AND AISC.bank_account_id = ABA.bank_account_id

    AND XCOUT.batch_id = AISC.checkrun_id

    AND CHK.checkrun_id = AISC.checkrun_id

    AND CHK.PAYMENT_METHOD_LOOKUP_CODE = AISC.PAYMENT_METHOD_LOOKUP_CODE

    AND ABA.ATTRIBUTE4 = FLV.LOOKUP_CODE

    • AP_BANK_ACCOUNTS_ALL – is replaced by IBY_EXT_BANK_ACCOUNTS_V (one base table is IBY_EXT_BANK_ACCOUNTS).

      AP_BANK_BRANCHES — is replaced by CE_BANK_BRANCHES_V.

      AP_CHECKS_ALL — Haven’t replaced by some other table in R12. Only some new columns are added to this table for maintaining real time synchronization with Oracle Payments and Cash Managements. Some existing columns from the same table have also been made obsolete.

      I think you can still use AP_INV_SELECTION_CRITERIA_ALL table and the table fnd_lookup_values_vl is still valid in R12.

      Thanks
      Dibyajyoti

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: