Entries by Oracle ERP Apps Guide

, , , ,

Retirement of Oracle AIM & AIM for Business Flows

Last week there was an email from Oracle for retirement for legacy Methods like AIM Advantage, AIM for Business Flows, EMM Advantage. These methods and Methodology been used by mostly Oracle Consulting,and there partners. The retirement date is January 31, 2011. Going Forward , OUM is going to be replaced by these methods, and not to forgot […]

, , , , , , ,

R12 SLA Tables join conditions to AR, AP, INV,Payments and Receiving

Here I am trying to describe R12 SLA(Sub Ledger Accounting) Procedure. 1) All accounting performed before transfer to the GL. Accounting data generated and stored in “Accounting Events” tables prior to transfer to GL 2) Run “Create Accounting” to populate accounting events (SLA) tables. User can “View Accounting” only after “Create Accounting” is run. Create […]

, , , , ,

Running Fast Formula From Backend – Oracle HRMS

Prerequisites: Step1 : Create the Element and Element linksStep2: write the fast formulaStep3: Attach the fast formula in Formula ResultsPackage used to call the fast formula from the backed : ff_execSimple Code Snippet below:       l_formula_id        NUMBER;      l_element_inputs    ff_exec.inputs_t;      l_element_outputs   ff_exec.outputs_t;      l_in_count          NUMBER;      l_out_count         NUMBER;      l_pay_value         NUMBER;   BEGIN      BEGIN         SELECT formula_id           INTO l_formula_id           FROM ff_formulas_f          WHERE […]

, , , , , ,

FND Messages In Oracle HRMS

FND MESSAGES:Here i am Explaining  how to create Fnd Messages  via  E-Business suite  and the implementation of message retrieval via the pl/sql API package provided with Oracle Applications.Creating an Oracle E-Business Suite Message To create a message in the E-Business suite message library you will need the “Application Developer” responsibility.Navigate to Application Developer > Application […]

, , , , , ,

Complete GL Interface – PL/SQL Procedure

Pre-Requisites:    ————–      a) set of books should be defined      b) Current Conversion rates and accounting periods need to be defines      c) Source and Category Name Should be defined     Interface Tables:    —————-      GL_INTERFACE     Base Tables:    ———–       GL_JE_HEADERS       GL_JE_LINES  […]