Oracle APPS Query to Link AP Payments, GL

Query to Link AP Payments, GL and SLA Tables: R12 AP GL XLA SELECT   SUM (xal.accounted_cr), SUM (xal.accounted_dr), aia.invoice_amount, ...

Oracle APPS :GL:CCID validation

 SELECT GCC.code_combination_id                 INTO l_ccid                 FROM GL_CODE_COMBINATIONS GCC, GL_SETS_OF_BOOKS GSOB        ...

Oracle EBS : GL: Transfer Accounting to GL

How to Transfer Accounting to General Ledger in Release 12 A)Create Accounting is used for Release 12 to Generate Accounting: Receivab...

Oracle Fusion :Leger Structure Deployment Issues

Issue: JBO-FND:::FND_KF_STR_NO_REQUIRED_LABEL: <MESSAGE><NUMBER>FND-2742</NUMBER> <TEXT>You must assign a requ...

Oracle APPS:Invoice posted to disabled code

There is an invoice posted to a accounting code segment value that was disabled (still the combination is enabled). The segment value...

Oracle Applications :Drill down from GL to AR Query

Oracle Applications :Drill down from GL to AR Query Below query is useful for drilling down from GL to AR invoices S SELE...

Implementation Check list for Oracle Financials

Implementation Check list for Oracle Financials  The set ups   a) Supplier sites,    b)Matching   tolerances,   c)Distribution sets...

Oracle Apps:Year end process in GL

Oracle Apps:Year end process in GL   Is it mandatory to use the below two programs during year end process ? Close Process...

Oracle Applications : Finance Certification Questions

Oracle eBusiness Suite Finance  Certification Questions . List of (any five) Standard reports of G/L. a) Budget Summary/ Detail....

Oracle eBusiness Suite : Link between AP/AR and XLA tables

It is linked with GL_JE_BATCHES by JE_BATCH_ID and linked with GL_JE_HEADERS, GL_JE_LINES by JE_HEADER_ID  This table is linked with X...

Oracle eBusiness Suite : Mapping between GL and AR

The General Ledger Transfer process puts rows into GL_IMPORT_REFERENCES.REFERENCE21 to REFERENCE30. If the journal is imported in de...