My Portfolio

Multi Period Accounting (MPA) 3 – SLA MPA Feature From Oracle R12.0, subledger accounting (SLA) is introduced to Oracle E-Business Suite, which is a event-based accounting generation engine. From R12.1, MPA feature is introduced to SLA architecture. It enables users to create accounting for  a single accounting event  for more than one GL period.  Taking an example for prepaid expense, when AP invoice validated, an accounting event “Invoice Validation” will be created, by create accounting, the multiple period accounting journals will created for this event. As one SLA accounting journal can have only one GL date, so the relationship between event and SLA journal is 1:m. The multiple period accounting process is depicted as below diagram. Setup Define Accounting Derivation Rule (ADR): This is used to get the journal entry account for recogonition entries. (Dr. Expense, Cr. Prepaid expense) Define Journal Entry Type (JLT): Accural journal entry type Recogonition journal en...

--TO check the status of inventory period SELECT OOD.ORGANIZATION_CODE, OAP.PERIOD_NAME, OPEN_FLAG, OAP.SUMMARIZED_FLAG FROM APPS.ORG_ACCT_PERIODS OAP, apps. org_organization_definitions ood where upper(oap.period_name) = upper('&period_name') AND OAP.ORGANIZATION_ID = OOD.ORGANIZATION_ID order by ood.organization_code

If the PO and the price are on the first line, and the price field is grayed out. Cause Analysis: As Per  Oracle Functionality, if the PO line is received and/or Billed (Partially or fully), system will not allow to change the Price . Here the Line is billed, so it's not allowing to change Price. Resolution: Go to Shipments from PO Summary and see the status of the line. If you see here the Line 1,  quantity 1 is billed. So as said above,  the PO form was not allowing to change the Price, it was grayed out. There will be the same situation if it's "Received" also. Now if you want to change the Price, the following actions should be performed: If PO is received Partially or Fully   ›   The received quantity should be returned back to Supplier. And then system will allow changing the Price on that Line. If PO is Billed Partially or Fully   ›   For the Billed quantity, you should have either Credit Memo or Debit Memo in ERP. Once that is in ERP, you ...

An Introduction to Basics of Interfaces in Oracle Apps. Interface Basics(AP r12 - AR - GL) Interfaces in Oracle Application: An Introduction What are Interfaces? ·           Interfaces are used in Oracle Applications to integrate external systems and Data Conversion. ·           The interfaces are mainly used to either transfer data from Oracle Applications to a flat file or data from legacy system to Oracle Applications. ·           Used extensively at the time of Data Conversion from legacy/ old systems to a fresh implementation of Oracle Applications. ·           Used also at regular intervals when data transfer is from other live systems if the systems are not defined in Oracle Applications implementation. ·           Oracle provides flexible and flexible tools ...