1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

R12- CE Tables and Changes

Discussion in 'Oracle Apps Technical' started by Ramji, Feb 7, 2012.

  1. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Cash Management (CE)
    New Tables
    Table Name
    Feature Area
    CE_BANK_ACCOUNTS
    Bank Account Model
    CE_BANK_ACCT_USES_ALL
    Bank Account Model
    CE_GL_ACCOUNTS_CCID
    Bank Account Model
    CE_INTEREST_BALANCE_RANGES
    Balances and Interest Calculation
    CE_INTEREST_RATES
    Balances and Interest Calculation
    CE_INTEREST_SCHEDULES
    Balances and Interest Calculation
    CE_BANK_ACCT_BALANCES
    Balances and Interest Calculation
    CE_PROJECTED_BALANCES
    Balances and Interest Calculation
    CE_INT_CALC_DETAILS_TMP
    Balances and Interest Calculation
    CE_CASHFLOWS
    Bank Account Transfers
    CE_CASHFLOW_ACCT_H
    Bank Account Transfers
    CE_PAYMENT_TRANSACTIONS
    Bank Account Transfers
    CE_PAYMENT_TEMPLATES
    Bank Account Transfers
    CE_TRXNS_SUBTYPE_CODES
    Bank Account Transfers
    CE_XLA_EXT_HEADERS
    Subledger Accounting
    CE_CONTACT_ASSIGNMENTS
    Bank Account Model
    CE_AP_PM_DOC_CATEGORIES
    Bank Account Model
    CE_PAYMENT_DOCUMENTS
    Bank Account Model
    CE_SECURITY_PROFILES_GT
    Bank Account Model
    CE_CHECKBOOKS
    Bank Account Model
    Changed Tables
    Table Name
    Feature Area
    Brief Description of Change
    CE_AVAILABLE_TRANSACTIONS_TMP
    Bank Statement Reconciliation
    Add LEGAL_ENTITY_ID and ORG_ID
    CE_STATEMENT_RECONCILS_ALL
    Bank Statement Reconciliation
    Add LEGAL_ENTITY_ID
    CE_ARCH_RECONCILIATIONS_ALL
    Bank Statement Reconciliation
    Add LEGAL_ENTITY_ID
    CE_SYSTEM_PARAMETERS_ALL
    System Parameters
    Add LEGAL_ENTITY_ID; Add Columns for BAT project
    CE_ARCH_HEADERS
    Bank Statement
    droap ORG_ID
    CE_ARCH_INTERFACE_HEADERS
    Bank Statement
    droap ORG_ID; Add more balance columns
    CE_ARCH_INTRA_HEADERS
    Bank Statement
    droap ORG_ID
    CE_INTRA_STMT_HEADERS
    Bank Statement
    droap ORG_ID
    CE_STATEMENT_HEADERS
    Bank Statement
    droap ORG_ID
    CE_STATEMENT_HEADERS_INTERFACE
    Bank Statement
    droap ORG_ID; Add more balance columns
    CE_CASHPOOLS
    Cash Leveling
    Add LEGAL_ENTITY_ID
    CE_PROPOSED_TRANSFERS
    Cash Leveling
    Add columns for Balance project
    CE_LEVELING_MESSAGE
    Cash Leveling
    Add columns for Balance project
    CE_TRANSACTIONS_CODES
    Bank Statement
    Add Columns for Multi-pass reconciliation feature
    CE_STATEMENT_LINES
    Bank Statement
    Add CASHFLOW_ID
    Obsolete Tables
    Table Name
    Feature Area
    Replaced By
    CE_ARCH_HEADERS_ALL
    Bank Statement
    CE_ARCH_HEADERS
    CE_ARCH_INTERFACE_HEADERS_ALL
    Bank Statement
    CE_ARCH_INTERFACE_HEADERS
    CE_ARCH_INTRA_HEADERS_ALL
    Bank Statement
    CE_ARCH_INTRA_HEADERS
    CE_INTRA_STMT_HEADERS_ALL
    Bank Statement
    CE_INTRA_STMT_HEADERS
    CE_STATEMENT_HEADERS_ALL
    Bank Statement
    CE_STATEMENT_HEADERS
    CE_STATEMENT_HEADERS_INT_ALL
    Bank Statement
    CE_STATEMENT_HEADERS_INTERFACE
    New Views
    View Name
    Feature Area
    CE_SECURITY_PROFILES_V
    Bank Account Model
    CE_LE_BG_OU_VS_V
    Bank Account Model
    CE_BANK_ACCOUNTS_V
    Bank Account Model
    CE_BANK_BRANCHES_V
    Bank Account Model
    CE_BANK_ACCT_USES
    Bank Account Model
    CE_BANK_ACCTS_GT_V
    Bank Account Model
    CE_BANK_ACCT_USES_BG_V
    Bank Account Model
    CE_BANK_ACCT_USES_LE_V
    Bank Account Model
    CE_BANK_ACCT_USES_OU_V
    Bank Account Model
    CE_BANK_ACCTS_CALC_V
    Balances and Interests Calculation
    CE_INTEREST_RATES_V
    Balances and Interests Calculation
    CE_260_CF_RECONCILED_V
    Bank Statement Reconciliation
    CE_260_CF_TRANSACTIONS_V
    Bank Statement Reconciliation
    CE_260_CF_REVERSAL_V
    Bank Statement Reconciliation
    CE_INTERNAL_BANK_ACCTS_GT_V
    Cash Positioning
    CE_XLA_EXT_HEADERS_V
    Subledger Accounting
    CE_INTERNAL_BANK_ACCTS_V
    Bank Account Model
    CE_BANKS_V
    Bank Account Model
    CE_BANK_ACCTS_SEARCH_GT_V
    Bank Account Model
    CE_XLA_TRANSACTIONS_V
    Subledger Accounting
    CEFV_BANK_ACCOUNTS
    Business Intelligence Service
    CEBV_BANK_ACCOUNTS
    Business Intelligence Service
    CEFV_BANK_BRANCHES
    Business Intelligence Service
    CEBV_BANK_BRANCHES
    Business Intelligence Service
    Changed Views
    View Name
    Feature Area
    Brief Description of Change
    CE_101_RECONCILED_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_101_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_185_RECONCILED_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_185_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Subledger Accounting and Bank Account Model features
    CE_200_RECONCILED_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_200_BATCHES_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_200_REVERSAL_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_200_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_222_RECONCILED_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_222_BATCHES_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_222_REVERSAL_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_222_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_222_TXN_FOR_BATCH_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_260_RECONCILED_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_260_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_801_RECONCILED_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_801_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_801_EFT_RECONCILED_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_801_EFT_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_999_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_999_RECONCILED_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_999_REVERSAL_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_ALL_STATEMENTS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_ARCH_RECONCILIATIONS
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_AVAIL_STATEMENTS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_AVAILAVLE_BATCHES_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_AVAILAVLE_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_BANK_TRX_CODES_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_INTERNAL_BANK_ACCOUNTS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_MISC_TAX_CODE_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_MISC_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_RECEIVABLE_ACTIVITIES_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_RECONCILED_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_REVERSAL_TRANSACTIONS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_STAT_HDRS_INF_V
    Bank Statement Reconciliation
    Enhancement related to MOAC, Balances and Interests Calculation and Bank Account Model feature
    CE_STATEMENT_HEADERS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC, Balances and Interests Calculation and Bank Account Model features
    CE_STATEMENT_LINES_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_STATEMENT_RECONCILIATIONS
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_SYSTEM_PARAMETERS
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_SYSTEM_PARAMETERS_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CE_TRANSACTION_CODES_V
    Bank Statement Reconciliation
    Enhancement related to MOAC and Bank Account Model features
    CEBV_CASH_FORECAST_CELLS
    BIS Views
    Enhancement related to Bank Account Model features
    CEBV_ECT
    BIS Views
    Enhancement related to Bank Account Model features
    CEFV_BANK_STATEMENTS
    BIS Views
    Enhancement related to Bank Account Model features
    CEFV_CASH_FORECAST_CELLS
    BIS Views
    Enhancement related to Bank Account Model features
    CEFV_ECT
    BIS Views
    Enhancement related to Bank Account Model features
    CE_TRANSACTION_CODES_V
    Bank Statement Reconciliation
    Enhancement related to Bank Statement Reconciliation features
    CE_CP_XTR_BANK_ACCOUNTS_V
    Cash Positioning
    Enhancement related to Bank Account Model features
    CE_XTR_CASHFLOWS_V
    Cash Positioning
    Enhancement related to Bank Account Model features
    CE_AP_FC_PAYMENTS_V
    Cash Forecasting
    Enhancement related to Bank Account Model features
    CE_AR_FC_RECEIPTS_V
    Cash Forecasting
    Enhancement related to Bank Account Model features
    CE_AR_FC_INVOICES_V
    Cash Forecasting
    Invalid object fix
    CE_SO_FC_ORDERS_V
    Cash Forecasting
    Invalid object fix
    CE_SO_FC_ORDERS_NO_TERMS_V
    Cash Forecasting
    Invalid object fix
    CE_SO_FC_ORDERS_TERMS_V
    Cash Forecasting
    Invalid object fix
    CE_FORECAST_ROWS_V
    Cash Forecasting
    Invalid object fix
    CE_CP_BANK_ACCOUNTS_V
    Cash Positioning
    Enhancement related to Bank Account Model features
    CE_CP_WS_BA_V
    Cash Positioning
    Enhancement related to Bank Account Model features
    CE_CP_DISC_OPEN_V
    Cash Positioning
    Enhancement related to Bank Account Model features
    CE_CP_WS_LE_V
    Cash Positioning
    Enhancement related to Bank Account Model features
    CE_CP_XTO_V
    Cash Positioning
    Enhancement related to Bank Account Model features
    CE_CP_SUB_OPEN_BAL_V
    Cash Positioning
    Enhancement related to Bank Account Model features
    CE_CP_WS_BA_DISC_V
    Cash Positioning
    Enhancement related to Bank Account Model features
    CE_P_BA_SIGNATORY_HIST_V
    BIS View
    Enhancement related to Bank Account Model features
    CE_FC_ARI_DISC_V
    Cash Forecasting
    Enhancement related to Subledger Accounting features
    Obsoleted Views
    View Name
    Feature Area
    Replaced By
    CE_ARCH_HEADERS
    Bank Statement
    Table with the same name
    CE_ARCH_INTERFACE_HEADERS
    Bank Statement
    Table with the same name
    CE_ARCH_INTRA_HEADERS
    Bank Statement
    Table with the same name
    CE_INTRA_STMT_HEADERS
    Bank Statement
    Table with the same name
    CE_STATEMENT_HEADERS
    Bank Statement
    Table with the same name
    CE_STATEMENT_HEADERS_INTERFACE
    Bank Statement
    Table with the same name
     
    raviagr7052 and Bharat like this.
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    Thanks for such a good material. Really helpful it was.
     
  3. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bharat,

    Pleasure m8. Also I can give you a solution for your internal requisition issue. Get a document with screen shot of every possible window and upload in a doc. I will take a look. For some modules I need to connect. Others I could do without by just understanding the issue. Sadly this is your clients' environment. Too many things need to be looked at to debug in a logical manner and its better always doing it online.

    Is this the only time it has failed.
    Have you tried doing a fresh one and seen if its working?
    cheers
    Ramji
     
    Bharat likes this.
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    There is only one screen exists m8 which is about requisition. Just created using internal requisition. But its not getting approved. It was in ' in-process' status. That's the problem exists. Have gone through all the possible ways what you have said before, but they are not changing my status to approved. Unfortunately I too haven't got any solution for that.
     
  5. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    SM.Bharat,

    I think I know what is causing it. Try this . Try to enter a requisition using another employee's id and see if it works. You will get the answer. Still not clear, I will clarify
    Ramji
     
  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    I have tried by changing employee but its not working for that too.
     
  7. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    I have created another user and tried in that user, but still the same error.For all users requisitions are not getting approved.
     
  8. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji bhai,

    I have created different users and tried to create internal requisition, but its not working. And one more thing is while creating OSP item I identified that for "manager" job I didn't identified any positions available for particular organization. I think setups are changed for employee, jobs and their positions. So this effect may influencing not to approve due to no positions available for job under organization
     
  9. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bharat,

    That is what I wanted you to check and understand. You are on the ball now.
    cheers
    Ramji
     
  10. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Thank you ramji.. I will look into those things now and try to fix it.
     
  11. rollingstar35

    rollingstar35 Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    75
    Hello

    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
     
  12. y1452001

    y1452001 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    SELECT ac.REMIT_BANK_ACCT_USE_ID,
    cb.BANK_ACCOUNT_NAME,
    ac.REMITTANCE_BANK_ACCOUNT_ID
    FROM ra_customer_trx_all ra ,
    ar_cash_receipts_all ac ,
    ar_receivable_applications_all aaa,
    CE_BANK_ACCOUNTS cb,
    CE_BANK_ACCT_USES_ALL ca
    WHERE aaa.application_type = 'CASH'
    AND aaa.cash_receipt_id = ac.cash_receipt_id
    AND aaa.applied_customer_trx_id = ra.customer_trx_id
    AND ra.CT_REFERENCE='10001' – SO ORDER NUMBER
    AND cb.BANK_ACCOUNT_ID = ca.BANK_ACCOUNT_ID
    Ra.org_id = ac.org_id
    AND cb.ORG_ID = ‘82’
    Question -> Returning multiple rows? How to get sales order beneficiary name, account?
     
  13. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    To get Sales Order Beneficiary name then we need to add HZ_PARTIES right?
     
  14. y1452001

    y1452001 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    The beneficiary bank details will not come from hz_parties. The bank account name info will come from CE_BANK_ACCOUNTS as per my understanding.
    There are 2 things with organization unit.

    Organization name must be in hr_organization_units Vs Bank account name must be in table CE_BANK_ACCOUNTS. How to get bank account name for the organization? The below query not sure if correct/wrong? Somebody closely look into it because in sales order the beneficiary would be organization. Isn't it?

    SELECT ac.REMIT_BANK_ACCT_USE_ID,
    cb.BANK_ACCOUNT_NAME,
    ac.REMITTANCE_BANK_ACCOUNT_ID
    FROM ra_customer_trx_all ra ,
    ar_cash_receipts_all ac ,
    ar_receivable_applications_all aaa,
    CE_BANK_ACCOUNTS cb,
    CE_BANK_ACCT_USES_ALL ca
    WHERE aaa.application_type = 'CASH'
    AND aaa.cash_receipt_id = ac.cash_receipt_id
    AND aaa.applied_customer_trx_id = ra.customer_trx_id
    AND ra.CT_REFERENCE='10001' – SO ORDER NUMBER
    AND cb.BANK_ACCOUNT_ID = ca.BANK_ACCOUNT_ID
    Ra.org_id = ac.org_id
    AND cb.ORG_ID = ‘82’
     
  15. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Yes bank details will come from CE_BANK_ACCOUNTS table itself. I thought you are looking for sales order customer name. Apologies for misunderstanding and thanks for update.