Skip navigation.

Applications

Oracle E-Business Suite

R12 - XLA / FAH - Create Accounting errs out with "95357 - There are no values for the system source XXXXX used by SLA"

vamsi kasina's picture

In case of unitended usage of system source in conditions may lead to the following error in Create Accounting:
There is a missing system source value. Please inform your system administrator or support representative that: There are no values for the system source XXXXXXXXXXXXXXXXX used by Oracle Subledger Accounting.

R12 - XLA / FAH - Business Events in Create Accounting

vamsi kasina's picture

The following business events are disabled as default by Oracle.
For any custom process those can be enabled by users. But only extract and postprocessing events will be called in document mode.
Custom code / package can be used as a subscription to the respective business event.

oracle.apps.xla.accounting.preaccounting  - To identify the events, which will be processed by create accounting
oracle.apps.xla.accounting.extract        - To populate the transaction objects only for the events in xla_events_gt

R12 - XLA / FAH - Useful Notes / GDFs / Patches

vamsi kasina's picture

Miultiple Entities GDF 9651687
In SLA Not In GL GDF 9481239

FAQ for SLA Upgrade 604893.1
SLA Obsolete Profiles 553229.1
FAQ - FSAH / FAH 729545.1
XLA Setup Diagnostics Test 942252.1

R12 - XLA / FAH - After running Validate AAD program, why the XLA dynamic package becomes invalid?

vamsi kasina's picture

Subledger Accounting / Financials Accounting Hub uses dynamic package to generate the journal entries.
Depending on the rules (AMB Setup and Event Model) the dynamic package will be created, when the Validate Application Accounting Definition program has been run.
The package will be generated with the naming convension XLA_{5DIGIT_APPL_ID}_AAD_{SEED_CUSTOM}_{6DIGIT_AAD_HASH}_PKG.
AAD_HASH value will be found in xla_product_rules_b.product_rule_hash_id.

   SELECT 'XLA_' || lpad(application_id,5,'0') || '_AAD_' || 
          product_rule_type_code || '_' || lpad(product_rule_hash_id,6,'0') || '_PKG'
   FROM xla_product_rules_b
   WHERE application_id = &p_appl_id
   AND amb_context_code = NVL('&amb_context_code','DEFAULT')
   AND product_rule_code = '&aad_code';
Examples for dynamic pakcages:
XLA_00555_AAD_C_011117_PKG
XLA_00200_AAD_S_000012_PKG

R12 - GL / XLA / FAH - Reporting Currencies

vamsi kasina's picture

There are three levels of reporting currencies.
Subledger, Journal and Balance.

The data will be create for those ledgers, when the following processes have been run.
Create Accounting - Journals will be created in SLA.
Transfer to GL & Journal Import - Journals will be created in GL.
Post to GL - Balances will be created / updated in GL.

Subledger Level - It maintains data in SLA for ALC also, you can view the accounting in SLA OA pages and other reports.

Best practice - Implementation of OA Framework Technology

This post is to discuss about the Best Practices that was followed in implementing a new Self Service Applications using OA Framework.

A College needed a web based enrollment system for its students to enroll online without needing to fill up a paper. This was designed for a new i-module for Student Enrolment was developed in OA Framework, using jDeveloper,Rapid Application Development Environment. The benefits of the RAD environment and OA Framework Technology was well utilized to meet the deadlines.

The main challenges faced by the project were , I identification of a roadmap to transform existing system and there was no proper oracle documentation on how to develop a transaction page in OA Framework.

Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux

vjain's picture

The Adventure Begins

This article is a shortened version of the full article on Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux 5.4 64-bit which can be read on Oracle-Developer.com.

I started by purchasing a brand new enterprise server without an OS. My first goal was to install the latest release of Oracle Enterprise Linux for the operating system and then to install the latest release of Oracle Database (11.2).

R12 - XLA - What are the replacement reports for 11i - AX?

vamsi kasina's picture

AX (11i)                                                                        SLA (R12)

Daily Journal Book - Line Descriptions Payables/Receivables/Inventory Journal Entries Report Daily Journal Book - Header Descriptions Payables/Receivables/Inventory Journal Entries Report Final Daily Journal Book - Header Descriptions Journal Entries Report Italian Journal Book Journal Entries Report

R12 - GL / XLA - Drilldown from GL is not consistently opening in OA pages

vamsi kasina's picture

Sometimes Drilldown from GL will open OA pages and sometimes Oracle Forms.

Here is the reason:

  • When the data is from 11i and not upgraded to R12 (means it is not in XLA tables and gl_je_headers.je_from_sla_flag is NULL), then it will open the subledger form directly.
  • When the data is from R12 or from 11i and upgraded to R12 (means it is in XLA tables and gl_je_headers.je_from_sla_flag is 'Y' or 'U'), then it will open the SLA OA page first, so that we can check the XLA data and we can open the subledger form through View Transactions button.

11i - AX - Unable to submit AX Posting Manager/Post Transactions?

vamsi kasina's picture

If the following error occurs while submitting AX Posting Manager/Post Transactions, then set the profile options, AX Application Name and GL Set of Books Name.
Which will automatically set the other two profiles.

The following are the important profile options, which need to be set to submit AX Posting Manager/Post Transactions.

  • AX Application Id
  • AX Application Name
  • GL Set of Books ID
  • GL Set of Books Name