Monday, November 10, 2014

Oracle financials interface tables

General Ledger Interface Tables:-
-----------------------------------------

GL_BUDGET_INTERFACE
GL_DAILY_RATES_INTERFACE

GL_DRM_HIERARCHY_INTERFACE
GL_DRM_SEGVALUES_INTERFACE

GL_IMP_COA_ERR_INTERFACE

GL_IMP_COA_NORM_HIER_INTERFACE

 GL_IMP_COA_SEG_VAL_INTERFACE

GL_IEA_INTERFACE
GL_INTERFACE
GL_INTERFACE_CONTROL
GL_INTERFACE_HISTORY

GL_REPORT_INTERFACE

GL_XFR_INTERFACE

 

Payables Interface Tables:-
---------------------------------

AP_INTERFACE_CONTROLS
AP_INTERFACE_REJECTIONS
AP_INVOICE_INTERFACE
AP_INVOICE_LINES_INTERFACE

OIE_POL_RATES_INTERFACE

 

Receivables Interface Tables:-
------------------------------------


AR_PAYMENTS_INTERFACE_ALL
AR_TAX_INTERFACE
HZ_PARTY_INTERFACE
HZ_PARTY_INTERFACE_ERRORS
RA_CUSTOMERS_INTERFACE_ALL
RE_INTERFACE_DISTRIBUTION_ALL
RA_INTERFACE_ERRORS_ALL
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALESCREDITS_ALL

AR_INTERFACE_CONTS_ALL

AR_PMTS_INTERFACE_HEADER_GT

AR_PMTS_INTERFACE_LINES_GT

AR_PMTS_INTERFACE_LINE_DETAILS

HZ_DQM_SH_SYNC_INTERFACE

HZ_DQM_SYNC_INTERFACE

RA_INTERFACE_REQID_GT

 

Fixed Assets Interface Tables:-

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

FA_BUDGET_INTERFACE

FA_INV_INTERFACE

FA_PRODUCTION_INTERFACE

FA_TAX_INTERFACE

FA_TRANSACTION_INTERFACE

 

Cash Management Interface Tables:-

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

CE_ARCH_INTERFACE_HEADERS

CE_ARCH_INTERFACE_HEADERS_ALL

CE_ARCH_INTERFACE_LINES

CE_HEADER_INTERFACE_ERRORS

CE_LINE_INTERFACE_ERRORS

CE_STATEMENT_LINES_INTERFACE

CE_UK_VALIDATIONS_INTERFACE

 

Thursday, November 6, 2014

Manual Cost Adjustment to an Asset OR Credit Memo Adjustment to an asset from Mass Addition process

 

A cost adjustment can be entered manually or posted from the Mass Additions interface table.  Cost adjustments from Mass Additions are typically coming from Accounts Payable or Project Accounting and are beyond the scope of this How To.

To post a manual cost adjustment, navigate as follows:

   Responsibility:  Fixed Assets Manager

   Asset / Asset Workbench

   Query the asset 

   From the Summary screen in the Asset Workbench, select the Books button

   Type in the book or select the book from the popup menu

   Amortize checkbox:

     - do not check this box if depreciation should recalculate from the date placed in service

     - check this box only if depreciation should not be recalculated

   Tab to the lower half of the form and enter the adjusted cost in the cost field

 

   Click on the Done button to save

To post a Mass addition cost adjustment (Credit Memo)

Navigate to Prepare mass addition

1. Query the Credit memo using invoice number (CM #)

2. You can see the status will be “NEW”, click on “add to asset” button

3. Select the original Asset item, which you want to reduce the Costing

  - Amortize adjustment ---->do not check this box if depreciation should recalculate from the date placed in service

  - check this box only if depreciation should not be recalculated

4. click on ‘done’ button, after finishing this the status will be “HOLD”

5. Re-query the assets and change the status queue as ‘POST’ then click ok,

6. After select post queue, the status queue will be show as “COST ADJUSTMENT”

7. Click ‘done’ button

8. Run the post mass addition

9. You can find the concurrent output for the adjustment amount

10. Query the original asset and check the Financial information, there you can see new transaction added as ADJUSTMENT, now the credit memo will be adjusted the costing information

11. Revised depreciation will be take in place from Credit Memo date of services onwards,…

12. You can run the depreciation and check the status for new costing & depreciation information.

How to create .dbc file in oracle

 

Navigate to $INST_TOP/admin/install directory

Find the adgendbc.sh script

Run the command adgendbc.sh, It will generate .dbc file under $INST_TOP/appl/fnd/secure

Tuesday, November 4, 2014

How to determine if the workflow services are up and running?

 

The following query also returns the status of the workflow services:

 

SELECT   fcq.user_concurrent_queue_name container_name,
         DECODE (fcp.os_process_id,
                 NULL, 'Not
Running',
                 fcp.os_process_id
                ) procid,
         fcq.max_processes target, fcq.running_processes actual,
         fcq.enabled_flag enabled, fsc.component_name, fsc.component_type,
         fsc.startup_mode, fsc.component_status, SYSDATE dates
    FROM apps.fnd_concurrent_queues_vl fcq,
         apps.fnd_cp_services fcs,
         apps.fnd_concurrent_processes fcp,
         fnd_svc_components fsc
   WHERE fcq.manager_type = fcs.service_id
     AND fcs.service_handle = 'FNDCPGSC'
     AND fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
     AND fcq.concurrent_queue_id = fcp.concurrent_queue_id(+)
     AND fcq.application_id = fcp.queue_application_id(+)
     AND fcp.process_status_code(+) = 'A'
ORDER BY fcp.os_process_id, fsc.startup_mode;

Monday, November 3, 2014

INVALID_PAYEE (Invalid payee identifier) Running Automatic Remittances Creation Program

 

Solution:

Assign an operating unit to the payee using the following navigation:


Funds Capture Setup Administrator > Funds Capture Setup > Payees > Assign Operating Units


NOTE: It is currently possible to choose inactive operating units from the list of values (ER 10626881 has been raised requesting this functionality to be changed).  If an inactive operating unit has been chosen, this will result in the INVALID_PAYEE error.  To verify if an operating unit is inactive, use the following SQL:


select ORGANIZATION_ID, DATE_FROM, DATE_TO
from hr_operating_units;


An operating unit is inactive if the "DATE_TO" field is populated.

Receipt Reconciliation Fails With APP-AR-999967188 The Receipt is in the Process Of Funds Capture Settlement

image

 

1. One possible cause for this error is an incomplete transaction on the Funds Capture side.

To verify if the transaction has been completed in Funds Capture, please run the following query (using the receipt number of the failing receipt as parameter):

SELECT status
  FROM iby_trxn_summaries_all
WHERE transactionid IN (
          SELECT transactionid
            FROM iby_fndcpt_tx_operations
           WHERE trxn_extension_id IN (
                                      SELECT payment_trxn_extension_id
                                        FROM ar_cash_receipts_all
                                       WHERE receipt_number =
                                                             '&receipt_number'))
   AND trxntypeid = 100;

If the above query returns a value of 100, please execute the Create Settlement Batches request, as explained in  Note  550146.1 How To Generate Remittance Format Report In Release 12.

2. If the value returned by the query is 0, this means that the transaction is completed on the Funds Capture side and the issue might be caused by a code bug.
get_settlement_status cursor in package ARP_REVERSE_RECEIPT did not include check for reqtype 'ORAPMTEFTCLOSEBATCH' . As result AR is unable to validate that transaction was settled in  Payments.

Version of ARREREVB.pls contains

Cursor get_settlement_status IS
SELECT summ.status
FROM iby_fndcpt_tx_operations op,iby_trxn_summaries_all summ
WHERE op.trxn_extension_id = p_extension_id
AND op.transactionid = summ.transactionid
AND summ.reqtype in ('ORAPMTCAPTURE', 'ORAPMTRETURN',
'ORAPMTCREDIT', 'ORAPMTVOID', 'ORAPMTBATCHREQ')
ORDER BY summ.trxnmid desc;


as we can see 'ORAPMTEFTCLOSEBATCH' is not included.

3. In case the value retrieved by the above query is different than 100 and 0, please log a service request against Oracle Payments/Funds Capture product for further analysis.

Solution:

To resolve the issue, apply Patch 10389524:R12.AR.B