vamsi kasina's blog
11i - AX - Why my Transaction has been accounted without Journal Entries?
Submitted by vamsi kasina on Sun, 2009-06-07 03:46
AX (Global Accounting Engine) creates journal entries only when the accounted amount is not equal to Zero.
As AX summarizes the journal entries by Plan Name (Accounting Class), Code Combination Id, Third Pary Id and Sub Id, if the accounted amount becomes zero, in those cases AX won't create Journal Entries.
- Login to post comments
R12 - XLA / FAH - Create Accounting is giving output as Blank
Submitted by vamsi kasina on Sun, 2009-06-07 03:25
Hope you haven't selected Report parameter as "No Report".
Create Accounting has mainly two templates.
"Subledger Accounting Program Report - Standard" inturn calls "Subledger Accounting Program Report - Sub Template".
"Subledger Accounting Program Report - Sub Template" is a sub template and shouldn't be used directly while submiting the Create Accounting.
If the output is blank, the template needs to be crosschecked, which is available in the Options Button of the SRS window.
How to get the version of the files?
Submitted by vamsi kasina on Sat, 2009-06-06 13:51
For Packages:
SELECT text
FROM all_source
WHERE name = Upper('&package_name')
AND line = 2;
For Other Files:
SELECT af.subdir,
af.filename,
afv.version
FROM ad_files af,
ad_file_versions afv
WHERE af.file_id = afv.file_id
AND af.filename = '&file_name'
ORDER BY afv.creation_date DESC;Is count(*) giving 0 rows? (Or) Isn't SELECT giving desired output?
Submitted by vamsi kasina on Sat, 2009-06-06 13:43
Are you using MO view like ap_invoices?
For all org_ids' data -> Use ap_invoices_all
For specific org_id's data -> 11i -> dbms_application_info.set_client_info(&org_id);
R12 -> mo_global.set_policy_context('S',&org_id);R12 - GL / XLA / FAH - How to link GL data to the subledger data or vice versa
Submitted by vamsi kasina on Sat, 2009-06-06 13:16
gl_je_lines (je_header_id, je_line_num) -> gl_import_references (je_header_id, je_line_num) gl_import_references (gl_sl_link_table, gl_sl_link_id) -> xla_ae_lines (gl_sl_link_table, gl_sl_link_id) xla_ae_lines (applicaiton_id, ae_header_id) -> xla_ae_headers (application_id, ae_header_id) xla_ae_headers (application_id, event_id) -> xla_events (application_id, event_id) xla_events (application_id, entity_id) -> xla.xla_transaction_entities (application_id, entity_id)
R12 - XLA / FAH - Create Accounting (with Transfer to GL parameter as Yes) is not transferring all the journal entries to GL
Submitted by vamsi kasina on Sat, 2009-06-06 12:59
Create Accounting (with Transfer to GL parameter as Yes) will transfer only the journal entries to GL, which have been created by the same Create Accounting run.
To transfer the journal entries to GL, which have been accounted by previous Create Accounting (with Transfer to GL parameter as No) runs, "Transfer Journal Entries to GL" concurrent program needs to be run.
R12 - XLA / FAH - Difference between Draft, Final, etc in Create Accounting / Online Accounting
Submitted by vamsi kasina on Sat, 2009-06-06 12:41
Online Accounting: (For single entity / transaction)
Only few subledgers are providing this feature.
Draft will create journal entries, which are not final, which means they are not ready to be transferred to GL.
You can see the accounting in xla_ae_headers and xla_ae_lines.

