Category Archives: General Ledger

Using custom GL_INTERFACE tables for Journal Import http://oraclemaniac.com/2012/03/06/using-custom-gl_interface-tables-for-journal-import/   Oracle Maniacs’ Notes   DECLARE bulk_errors EXCEPTION; PRAGMA EXCEPTION_INIT (bulk_errors, –17594); TYPE t_int_record_type IS TABLE OF gl_interface%ROWTYPE INDEX BY BINARY_INTEGER; P_INT_RECORDS t_int_record_type; v_sob_id NUMBER; v_run_id NUMBER; v_group_id NUMBER; v_request_id NUMBER; v_request_status BOOLEAN; … Continue reading →

General Ledger: Journal Import Process (Doc ID 130542.1) General Ledger Journal Import Process (Doc ID 130542.1)

Oracle Web ADI Setups Prerequisite GL: Default Desktop Viewer (Profile Options) (ID = 45943.1) Internet Options èSecurity Setting (ID = 746192.1) WEB ADI Can’t Create excel spread sheet Hand (Check Internet Options ID = 789122.1) Run time error 1004 Opening … Continue reading →

Vision Demo Document Index (Procurement) (Doc ID 1075748.1) In this Document Purpose Troubleshooting Steps API: Open Interface : Integration with Order Management: Integration with Inventory: Integration with WIP: Integration with MRP: Integration with Oracle Sourcing: Purchase Order: Accounting: References Applies to: … Continue reading →

CREATE OR REPLACE PROCEDURE APPS.XX_GL_INTERFACE__TRFANS_PROC(Errbuf OUT VARCHAR2, Retcode OUT VARCHAR2) /******************************************************************************    NAME:             XX_GL_INTERFACE__TRFANS_PROC    PURPOSE:      — We can upload the interface data as following inforamtions    ###################    Actual Balance Jurnals          Budget Balance Journals        Encumbrance Balance … Continue reading →

GL-Technical Bulletins (Doc ID 66651.1) To Bottom Oracle General Ledger Technical Bulletins SQL script to provide detailed information on a GL batch, Release 10 & 11Note:70093.1 Tips on Printing FSG Reports CR: 229803 (HTML) FSG – Using Parent and Summary … Continue reading →

–###################################################################### — Script to get chart of account details from Oracle Apps financials –##################################################################### SELECT gcc.code_combination_id, gcc.segment1, DECODE (gcc.segment1, NULL, ”, apps.gl_flexfields_pkg.get_description_sql (gcc.chart_of_accounts_id, 1, gcc.segment1 ) ) seg1_desc, gcc.segment2, DECODE (gcc.segment2, NULL, ”, apps.gl_flexfields_pkg.get_description_sql (gcc.chart_of_accounts_id, 2, gcc.segment2 ) ) seg2_desc, … Continue reading →

Oracle Budget Inquiry Process & Reporting Process Budget Setup Defining Budget GL  èBudgets èDefine èBudgetèDefine Budgets GL  èBudgets èDefine èOrganizationsè Defining Budget Organizations First Account Assignment, than Accounts Range Assignment GL è BudgetsèJournals è Entering Budget Journals   Oracle Budget … Continue reading →