Sunil Dutt's Oracle Apps Technical World: July 2008

Wednesday, July 30, 2008

Enhance your project documentation process with Oracle Applications Implementation Methodology (AIM)

Introduction
Having supported many software implementations including those of ERP systems I have found that project documentation is one area which requires significant improvement. Often just finding the project documentation is difficult enough and once this frustrating process is completed you find that the documentation is inadequate. This makes it very difficult to support such implementations and any new users of such software have to rely on learning from previous users whose availability is often in question.
Although poor documentation can be attributed to poor project management, in many instances the documentation is not done simply due to the effort involved and the lack of awareness as to which tools are available to facilitate the process. This article highlights how Oracle AIM advantage simplifies the documentation process and can also be used as a tool to effectively manage Oracle Applications project implementations.

AIM Overview
In my communications with a number of Oracle Applications implementer’s I have been surprised to find that there is very little awareness surrounding AIM and it is very rarely used for implementations. However, I have personally found it to be very useful in managing and documenting the Oracle Applications projects I have been involved in. I also believe it compares favorably and in many instances betters project management tools being used for other ERP system implementations.
AIM consists of a project management methodology together with the underlying documentation templates that support the tasks you perform within this methodology. This combination of a methodology together with documentation templates makes AIM a powerful tool for assisting implementation participants in running and managing projects successfully. The methodology can be used for any other software implementations but obviously the true value of AIM will be only be realized when it is used in conjunction with the Oracle specific document templates.

The methodology and structure
The methodology used is similar to traditional software project management methodologies. There are six phases within the project, these are: -
Definition – establish the business objectives and related requirements.
Define the project work plan.
Operations Analysis – analyze the operations and determine fit between organizational requirements and standard application functionality.
Design – develop detailed designs for the optimal solutions to meet the future business requirements.
Build – physical software system build and testing.
Transition – deploying the finished solution into the organisation.
Production – go LIVE!

Within these phases are the various processes – see the horizontally listed processes Each process is made up of a number of tasks. Each task has a deliverable for which there is normally a documentation template. A process such as Application and Technical Architecture may span across more than one phase. In the case of Project management it is obvious that this phase stretches across all of the project phases. The level of work required for each process within each phase can immediately be ascertained by looking at the length of the bars for each process within the phases
In order to allow customization of the methodology according to user requirements core and optional tasks have been defined. The core tasks in AIM define the minimum set of steps necessary to implement Oracle Applications. Depending on your circumstances you may want to include a number of other optional tasks.
For example, where there are interfaces to third party systems you can incorporate AIM tasks to help you examine, update and test those interfaces to work with the new system. Once you become more familiar with AIM you can therefore customize your implementation plan based on your knowledge of the tasks needed for a particular project.

An aesthetically pleasing GUI is always a plus for any software. However, one should always assess whether the GUI enhances the functionality of the software or whether it is there to simply dazzle the users without providing the underlying utility. In AIM’s instance I believe that the interface has been crafted in such a way that it clearly illustrates the structure of the implementation methodology as well as provides easy access to the relevant deliverables for each particular task.
The GUI allows you to drill down to the necessary deliverables as well as view the implementation plan in multiple different views. The very first view that a user is presented here you are shown the relevant phases and the processes within these phases. By clicking on the word for each project phase you can look at all the tasks within that particular phase which are also split according to process.
Clicking on a particular process will show you all the tasks for that particular process divided up according to the relevant project phase.

Documentation Templates
By far the most important feature and indeed “the guts” of AIM are the documentation templates that it provides. There are more than 150 templates which you can make use of and which come in a variety of formats such as MS Word documents, MS Excel Spreadsheets and MS Project Files. Each of the document templates follows a standard coding convention which corresponds to the codes used in the template of the MS Project plan. Information on how to use each template can also be found in the comprehensive help system provided.
The document templates can really be divided up into two types. Firstly there are generic project
management documents. Examples of these include the project work plan, change request documents, quality control documents, status monitoring and reporting documents. These templates should be edited and adopted as standard documents for your organisation so that they can be reused for subsequent implementations.
Secondly, there are documentation templates designed specifically for Oracle Applications implementations.
This is the feature of AIM I like the most since it makes the documentation of the system setup and configuration relatively easy. Each of the setup documents is designed in accordance with the layout of the fields within the various forms contained in each module. Hence, capturing setup information merely involves transferring the data contained in your forms directly into the word documents provided.
Conclusion
Using Oracle AIM helps you in the early stages of your implementation to establish what kind of solutions your customer wants and how Oracle Applications needs to be configured in response to customer demands. Thereafter it becomes very useful in monitoring and documenting the entire implementation process. It is particularly useful in ensuring that at the end of each phase you have signed off deliverables.
As with all project management tools, however, it is only effective to the extent that it is used and understood by those involved in the implementation.

Graphical User Interface (GUI)
An aesthetically pleasing GUI is always a plus for any software. However, one should always assess whether the GUI enhances the functionality of the software or whether it is there to simply dazzle the users without providing the underlying utility. In AIM’s instance I believe that the interface has been crafted in a way that it clearly illustrates the structure of the implementation methodology as well as provides easy access to the relevant deliverables for each particular task.
The GUI allows you to drill down to the necessary deliverables as well as view the implementation plan multiple different views. The very first view that a user is presented
shown the relevant phases and the processes within these phases. By clicking on the word for each project phase you can look at all the tasks within that particular phase which are also split according to process. Clicking on a particular process will show you all the tasks for that particular process divided up according the relevant project phase.

Documentation Templates
By far the most important feature and indeed “the guts” of AIM are the documentation templates that it provides. There are more than 150 templates which you can make use of and which come in a variety formats such as MS Word documents, MS Excel Spreadsheets and MS Project Files. Each of the document templates follows a standard coding convention which corresponds to the codes used in the template of MS Project plan. Information on how to use each template can also be found in the comprehensive help system provided.
The document templates can really be divided up into two types. Firstly there are generic project
management documents. Examples of these include the project work plan, change request documents, quality control documents, status monitoring and reporting documents. These templates should be edited and adopted as standard documents for your organisation so that they can be reused for subsequent implementations.
Secondly, there are documentation templates designed specifically for Oracle Applications implementations.
This is the feature of AIM I like the most since it makes the documentation of the system setup and configuration relatively easy. Each of the setup documents is designed in accordance with the layout of fields within the various forms contained in each module. Hence, capturing setup information merely involves transferring the data contained in your forms directly into the word documents provided.

Conclusion
Using Oracle AIM helps you in the early stages of your implementation to establish what kind of solutions your customer wants and how Oracle Applications needs to be configured in response to customer demands. Thereafter it becomes very useful in monitoring and documenting the entire implementation process. It is particularly useful in ensuring that at the end of each phase you have signed off deliverables. As with all project management tools, however, it is only effective to the extent that it is used and understood by those involved in the implementation.

GL_INTERFACE_ERRORS

Period Error Codes
EP01 This date is not in any open or future enterable period.
EP02 This set of books does not have any open or future enterable periods.
EP03 This date is not within any period in an open encumbrance year.
EP04 This date is not a business day.
EP05 There are no business days in this period.

Unbalanced Journal Error Codes
WU01 Warning: This journal entry is unbalanced. It is accepted because suspense posting is allowed in this set of books.
EU02 This journal entry is unbalanced and suspense posting is not allowed in this set of books.
EU03 This encumbrance journal entry is unbalanced and the Reserve for Encumbrance account is not defined.

Flexfield Error Codes
EF01 This Accounting Flexfield is inactive for this accounting date.
EF02 Detail posting not allowed for this Accounting Flexfield.
EF03 Disabled Accounting Flexfield.
EF04 This is an invalid Accounting Flexfield. Check your cross-validation rules and segment values.
EF05 There is no Accounting Flexfield with this Code Combination ID.

Foreign Currency Error Codes
EC01 A conversion rate must be entered when using the User conversion rate type.
EC02 There is no conversion date supplied.
EC03 A conversion rate type or an accounted amount must be supplied when entering foreign currency journal lines.
EC06 There is no conversion rate for this currency, conversion type, and conversion date.
EC08 Invalid currency code.
EC09 No currencies are enabled.
EC10 Encumbrance journals cannot be created in a foreign currency.
EC11 Invalid conversion rate type.
EC12 The entered amount must equal the accounted amount in a functional or STAT currency journal line.
EC13 The entered amount multiplied by the conversion rate must equal the accounted amount.
ECW1 Warning: Converted amounts could not be validated because the conversion rate type is not specified.

Budget Error Codes
EB01 A budget version is required for budget lines.
EB02 Journals cannot be created for a frozen budget.
EB03 The budget year is not open.
EB04 This budget does not exist for this set of books.
EB05 The encumbrance_type_id column must be null for budget journals.
EB06 A period name is required for budget journals.
EB07 This period name is not valid. Check calendar for valid periods.
EB08 Average journals cannot be created for budgets.
EB09 Originating company information cannot be specified for budgets.

Encumbrance Error Codes
EE01 An encumbrance type is required for encumbrance lines.
EE02 Invalid or disabled encumbrance type.
EE03 Encumbrance journals cannot be created in the STAT currency.
EE04 The BUDGET_VERSION_ID column must be null for encumbrance lines.
EE05 Average journals cannot be created for encumbrances.
EE06 Originating company information cannot be specified for encumbrances.

Reversal Error Codes
ER01 A reversal period name must be provided.
ER02 This reversal period name is invalid. Check your calendar for valid periods.
ER03 A reversal date must be provided
ER04 This reversal date is not in a valid period.
ER05 This reversal date is not in your database date format.
ER06 Your reversal date must be the same as or after your effective date.
ER07 This reversal date is not a business day.
ER08 There are no business days in your reversal period.
ER09 Default reversal information could not be determined.

Descriptive Flexfield Error Codes
ED01 The context and attribute values do not form a valid descriptive flexfield for Journals - Journal Entry Lines.
ED02 The context and attribute values do not form a valid descriptive flexfield for Journals - Captured Information.
ED03 The context and attribute values do not form a valid descriptive flexfield for Value Added Tax.

Miscellaneous Error Codes
EM01 Invalid journal entry category.
EM02 There are no journal entry categories defined.
EM03 Invalid set of books id.
EM04 The value in the ACTUAL_FLAG must be "A" (actuals), "B" (budgets), or "E" (encumbrances).
EM05 The encumbrance_type_id column must be null for actual journals.
EM06 The budget_version_id column must be null for actual journals.
EM07 A statistical amount belongs in the entered_dr(cr) column when entering a STAT currency journal line.
EM09 There is no Transaction Code defined.
EM10 Invalid Transaction Code.
EM12 An Oracle error occurred when generating sequential numbering.
EM13 The assigned sequence is inactive.
EM14 There is a sequential numbering setup error resulting from a missing grant or synonym.
EM17 Sequential numbering is always used and there is no assignment for this set of books and journal entry category.
EM18 Manual document sequences cannot be used with Journal Import.
EM19 Value Added Tax data is only valid in conjunction with actual journals.
EM21 Budgetary Control must be enabled to import this batch.
EM22 A conversion rate must be defined for this accounting date, your default conversion rate type, and your dual currency.
EM23 There is no value entered for the Dual Currency Default Rate Type profile option.
EM24 Average journals can only be imported into consolidation sets of books.
EM25 Invalid average journal flag. Valid values are "Y", "N", and null.
EM26 Invalid originating company.
EM27 Originating company information can only be specified when inter company balancing is enabled.

Base Tables of O2C Process:

Base Tables of O2C Process:

When you entered the Order and Booked the Order following table will store the Information:

SELECT * FROM OE_ORDER_HEADERS_ALL
WHERE ORDER_NUMBER = 55950
AND HEADER_ID = 82465

SELECT * FROM OE_ORDER_LINES_ALL
WHERE HEADER_ID = 82465
AND LINE_ID IN (161391, 161393)

SELECT * FROM WSH_DELIVERY_DETAILS
WHERE SOURCE_HEADER_ID = 82465
AND SOURCE_LINE_ID in (161391, 161393)

Ø Release Status is ‘R’ (Ready to Release)

SELECT * FROM WSH_DELIVERY_ASSIGNMENTS
WHERE DELIVERY_DETAIL_ID IN (179553,179554)

Ø When u Create Delivery Details that time this table will populate the record.
Ø AND DELIVERY_ID COLUMN ALSO WILL UPDATED IN WSH_DELIVERY_ASSIGNMENTS TABLE

SELECT * FROM WSH_NEW_DELIVERIES
WHERE DELIVERY_ID IN (48152,48153)
After “Launch Pick Release” Following table will populate:

SELECT * FROM WSH_PICKING_BATCHES
WHERE BATCH_ID IN (33867,33868)
Move Order Number = 33868

SELECT * FROM MTL_TXN_REQUEST_HEADERS
WHERE REQUEST_NUMBER = 34003

Ø Here Header_id is Batch Number

SELECT * FROM MTL_TXN_REQUEST_LINES
WHERE TXN_SOURCE_LINE_ID = 161391

Ø Here TXN_SOURCE_LINE_ID is the Line_ID of the OE_ORDER_LINES_TABLES.
After Ship Confirm Following table will populate:

SELECT * FROM MTL_SALES_ORDERS
WHERE SEGMENT1 = 55950
AND SALES_ORDER_ID = 42058

SELECT * FROM MTL_MATERIAL_TRANSACTIONS
WHERE INVENTORY_ITEM_ID = 149
AND TRANSACTION_REFERENCE = '82465'
AND TRANSACTION_SOURCE_ID = 42058

Ø Where TRANSACTION_REFERENCE is storing the HEADER_ID.

SELECT * FROM WSH_DELIVERY_LEGS
WHERE DELIVERY_ID IN (48152)

select * from MTL_ONHAND_QUANTITIES
where inventory_item_id = 149

After Running the “Workflow Background Process” Programme Invoice will Generate and that time following table will populate:

SELECT * FROM RA_CUSTOMER_TRX_ALL
WHERE INTERFACE_HEADER_ATTRIBUTE1 = '55950'

Ø Here INTERFACE_HEADER_ATTRIBUTE1 is the Order_Number.
Ø And TRX_COLUMN is the Invoice Number.

SELECT * FROM RA_CUSTOMER_TRX_LINES_ALL
WHERE CUSTOMER_TRX_ID = 118416

Ø Here INTERFACE_LINE_ATTRIBUTE6 Column is the LINE_ID.
Ø SALES_ORDER Column is also there which is storing ORDER_NUMBER.

SELECT * FROM AR_PAYMENT_SCHEDULES_ALL
WHERE CUSTOMER_ID = 5093
and CUSTOMER_TRX_ID = 118416

Ø To get the Outstanding of the Customer
After Transfer into the GL tables through “General Ledger Transfer Program” concurrent Programe:
SELECT * FROM GL_JE_BATCHES
WHERE NAME = 'AR 26137 Receivables 2202288: A 26137'

SELECT * FROM GL_JE_HEADERS
WHERE JE_BATCH_ID = '72750'
AND JE_HEADER_ID = 62120

SELECT * FROM GL_JE_LINES
WHERE JE_HEADER_ID = 62120
--AND REFERENCE_5 = 10016902

Here Reference_5 is the Invoice Number.
Receipt Transaction :

SELECT * FROM AR_CASH_RECEIPTS_ALL
WHERE RECEIPT_NUMBER = 'NKREC_240105'

Ø Before Adjustment STATUS is UNAPP Or UNID but Once u Applied with Invoice It will change into “APP”.

SELECT * FROM AR_RECEIVABLE_APPLICATIONS_ALL
WHERE CASH_RECEIPT_ID = 21116

Ø In this Table APPLIED_CUSTOMER_TRX_ID store the CUSTOMER_TRX_ID of the RA_CUSTOMER_TRX_ALL table.
Order Type is Return Only:

SELECT * FROM OE_ORDER_HEADERS_ALL
WHERE ORDER_NUMBER = 55987

SELECT * FROM OE_ORDER_LINES_ALL
WHERE HEADER_ID = 82634

Ø LINE STATUS IS “AWAITING_RETURNS”.
Ø Order Line Type should be “Return (Receipt)”.

SELECT * FROM RCV_SHIPMENT_HEADERS
WHERE RECEIPT_NUM = 7607
AND SHIPMENT_HEADER_ID = 30539

SELECT * FROM RCV_SHIPMENT_LINES
WHERE SHIPMENT_HEADER_ID = 30539

SELECT * FROM RCV_TRANSACTIONS
WHERE SHIPMENT_HEADER_ID = 30539

Ø IN RCV_SHIPMENT_LINES Table OE_ORDER_HEADER_ID AND OE_ORDER_LINE_ID Column is Link with OE_ORDER_HEADER AND OE_ORDER_LINE Tables.
Ø After Receiving the Material at “Receiving Stage” at that time Order Line Status will be “Awaiting Return Disposition”.
Ø After Deliver the Material to “Inventory” at that time Order Line Status will be “Returned” and One More Line will be Created with “Remaining Quantity”
For Example: If your Order line quantity is 3 and you have received 1 quantity than one More line will be created with 2 quantity in OE_OREDER_LINES table with status “AWAITING_RETURNS”
Base Tables of List of LOV in Sales Order Screen:
Customer Name:
PARTY_NAME Column of HZ_PARTIES table.
Customer Number:
ACCOUNT_NUMBER Column of HZ_CUST_ACCOUNTS table.
Ø Where PARTY_ID Column is the Link between HZ_PARTIES and HZ_CUST_ACCOUNTS tables.
Customer Contact:
FIRST_NAMELAST_NAME Column of AR_CONTACTS_V view.
Bill To and Ship to Locations:
CUST_ACCT_SITE_ID Column of HZ_CUST_SITE_USES_ALL table.
Order Type:
Name and Description Column of OE_TRANSACTION_TYPES_V View
To Get the Payment Terms:
SELECT * FROM RA_TERMS
Look Up Values:
Ø REQUEST_DATE_TYPE For Line Set
Ø SALES_CHANNEL
Ø FREIGHT_TERMS
Ø SHIPMENT_PRIORITY
Ø PAYMENT TYPE
To Get the Shipping Method:
SELECT * FROM WSH_CARRIER_SERVICES
SELECT * FROM WSH_ORG_CARRIER_SERVICES
WHERE ORGANIZATION_ID = '207'
To get the FOB:
Value is storing into the AR_LOOKUP where LOOKUP_TYPE = ‘FOB’
Drop Shipment Process:
Ø Once you booked the Order with type “Mixed” and line source type is “External” in “Shipping” tab that time the line status will be “Booked” in both the levels Header as well as line.
Ø After booked the Order we have to do “Purchase Release” or run the “Workflow Background Process”.
Workflow back ground process transfer the Sales Order Data into the PO_REQUISITIONS_INTERFACE_ALL Interface table to create the Purchase Requisition.
Once the Data is populated in Interface table then Run “Requisition Import” program to transfer the data into the base tables.
After that Line Status will be “Awaiting Receipt”.
Purchase Requisition Number can see at Line level in Additional Information option under that “Drop Ship” tab.
Link between Sales Order, Purchase Requisition and Purchase Order we can fine in

SELECT * FROM OE_DROP_SHIP_SOURCES
Here you will get ORDER_HEADER_ID, REQUISITION_HEADER_ID, REQUISITION_LINE_ID, PO_HEADER_ID, and PO_LINE_ID

Ø After Creating the Requisition Run the Auto creates option to create the Purchase Order against that purchases requisition.
Ø Receipt the Material :
If you received partially then Order Line status will be remain same like “Awaiting Receipt” Once you completely receipt the material then only status will changed into “Shipped”.
Ø Then after one Purchase Invoice will be created in Payables Module against the Purchase order and once sales invoice will be created in Receivables module against the sales order.

Sunday, July 20, 2008

API's

API's
FND_PROGRAM.EXECUTABLE ( )
FND_PROGRAM.DELETE_EXECUTABLE( )
FND_PROGRAM.REGISTER( )
FND_PROGRAM.DELETE_PROGRAM( )
FND_PROGRAM.PARAMETER( )
FND_PROGRAM.DELETE_PARAMETER( )
FND_PROGRAM.INCOMPATIBILITY( )
FND_PROGRAM.DELETE_INCOMPATIBILITY( )
FND_PROGRAM.REQUEST_GROUP( )
FND_PROGRAM.DELETE_GROUP( )
FND_PROGRAM.ADD_TO_GROUP( )
FND_PROGRAM.REMOVE_FROM_GROUP( )
FND_REQUEST.SUBMIT_REQUEST( )
FND_CONCURRENT.WAIT_FOR_REQUEST( )
FND_REQUEST.SET_PRINT_OPTIONS ( )
FND_GLOBAL.USER_IDFND_GLOBAL.APPS_INITIALIZE(user_id in number,resp_id in number,resp_appl_id in number);
FND_GLOBAL.LOGIN_ID
FND_GLOBAL.CONC_LOGIN_ID
FND_GLOBAL.PROG_APPL_ID
FND_GLOBAL.CONC_PROGRAM_ID
FND_GLOBAL.CONC_REQUEST_ID
FND_PROFILE.PUT(name,value)
FND_PROFILE.GET(name IN varchar2,value out varchar2)
API’S IN APPS
PO
PO_CUSTOM_PRICE_PUB
PO_DOCUMENT_CONTROL_PUB
PO_DOC_MANAGER_PUB
PO_WFDS_PUB
AP
AP_NOTES_PUB
AP_WEB_AUDIT_LIST_PUB
INV
INV_COST_GROUP_PUB
INV_ITEM_CATALOG_ELEM_PUB
INV_ITEM_CATEGORY_PUB
INV_ITEM_PUB
INV_ITEM_REVISION_PUB
INV_ITEM_STATUS_PUB
INV_LOT_API_PUB
INV_MATERIAL_STATUS_PUB
INV_MOVEMENT_STATISTICS_PUB
INV_MOVE_ORDER_PUB
INV_PICK_RELEASE_PUB
INV_PICK_WAVE_PICK_CONFIRM_PUB
INV_RESERVATION_PUB
INV_SERIAL_NUMBER_PUB
INV_SHIPPING_TRANSACTION_PUB

Order to cash life cycle

Order cycle
1.customer sends details of order or sales dept brings order from customer.
2.Enter the order in Sales order (SO)
3.Book an SO
4.Check for ATP (Available to promise)
5. Check for CTP (Capable to Promise) and CTD (capable to deliver)
6.Schedule SOship date
7.Send SO Acknowledgement
8.Resolve SO Holds
9.Release Credit Holds (Go to SO actions tab and release hold or increase the credit amount in customers->>standard-->>profile:amount)
10.Pick material (Pick release material from Inventory)
11.Pick wave MO is generated by system and material is moved to staging
12.prepare material for shipment (Packing)
13.Load Material
14.Ship material (Send ship documentslike bill of lading,customer invoice,packing list,vehicle load sheet)
15.Generate invoice in AR AR-> setup-> Auto invoice and send it to cus.
16.customer followup (calling customer thruphone,Dunning letters etc)
17.Customer payment aganist the invoice and receive payment
18.Financial reconcilation (reconsile shipment and payment done by customer)
Order to cash life cycle contains following steps
Order Entry --> OrderBooked --> Pick release --> Ship confirm --> Auto invoice
--> invoice --> Receipt --> Bank Reconcilations

Steps in Order management
Enter the sales orderBook the sales order
Steps in Shipping exexution
release the sales order for picking
Ship confirm the sales order
Steps in Receivables
Run auto invoiceInvoiceBank Reconcilation

Technical point of o2c(order to cash) is as follows
first we setup the customer,tax category details,item details,pricing definitions,payment terms,freight terms and then only we can order the product.
for set up main base tables are
RA_CUSTOMERS,
RA_ADDRESSES,
RA_CUST_SITE_USES_ALL
then go for the order entry
here effected tables are
OE_ORDER_HEADERS_ALL,
OE_ORDER_LINES_ALL
flow_status_code for both tables will be 'ENTER'
then book the order
flow_status_code for both tables of
OE_ORDER_HEADERS_ALL,
OE_ORDER_LINES_ALLwill be 'Booked'
WSH_DELIVERY_DETAILS,
WSH_DELIVERY_ASSIGNMENTS will be going to effect.
the pick release
the flow_status_code for OE_ORDER_HEADERS_ALL will be 'BOOKED"
and flow_status_code for OE_ORDER_LINES_ALL will be 'awaiting shipping"
pick conform
flow_status_code for both tables of OE_ORDER_HEADERS_ALL,
OE_ORDER_LINES_ALL will be 'PICKED'
ship conform
flow_status_code for both tables of OE_ORDER_HEADERS_ALL,
OE_ORDER_LINES_ALL will be 'SHIPPED'
here in WSH_NEW_ASSIGNMENTS the status_code is 'CL' then the order details are conformed and otherwise it is 'Open' stage
here in WSH_DELIVERY_DETAILS the oe_interface_flag is 'Y' then the order is closed and if it is 'N' it is an error in the order line details and we need to assign line level order details
once the shipping is conformed invoice will be generated
the effected tables are RA_CUSTOMER_TRX_ALL,RA_CUSTOMER_TRX_LINES_ALL
this is O2C

Oracle Apps Stuff in Net

http://wordpress.com/tag/oracle-order-management/
http://georgenet.net/oracle/
http://oracleebusinesssuite.wordpress.com/
http://www.sap-img.com/oracle-database/oracle-application-hints-and-tips.htm
http://garethroberts.blogspot.com/2007/09/standard-report-to-csv-file-via-bi.html
http://oracle-hrms-11i.blogspot.com/
http://www.w3schools.com
http://www.ebusinesslab.cn
http://www.trutek.com/index.php?id=53
http://feeds.feedburner.com/OracleAppsFAQ
http://onlineappsdba.com/index.php/category/identity_manager/
http://www.richardbyrom.com/download.htm
http://www.appsworkshop.com
http://onlineappsdba.blogspot.com/
http://www.admin.ox.ac.uk/financials/helpsheets/
http://oracleqa2.blogspot.com
http://peopleapps.com/
http://aspen.ithaca.edu:7778/portal/page_pageid=133,77462&_dad=portal&_schema=PORTAL
http://www.frp.qut.edu.au/frptoolkit/frptraining/finance/purchasing/enter_req.jsp
http://www.orafaq.com/forum/i/0/
http://www.chain-sys.com/demo_ground.shtml
http://www.ebusinesslab.cn
http://www.sqlmanager.net/en/news/sql/1133
http://blogs.oracle.com/xmlpublisher/2007/08/07
http://advait.wordpress.com/oracle-apps-11i-profiles/
http://www.infocaptor.com/articles/sql.html
http://oracle-applications-rama.blogspot.com/2007_10_01_archive.html
http://www.more4apps.com/?gclid=CKXglPqfhI8CFQh6gwod9zR91w
http://www.appssys.com/
http://oraclecrp.com/
http://www.oracleappsblog.com/index.php/forum
http://download.oracle.com/docs/cd/A60725_05/html/comnls/us/ap/invoic13.htm
http://main.uab.edu/show.asp?durki=73096
http://main.uab.edu/show.asp?durki=66289
http://www.learndiscoverer.com/downloads/downloads.htm
https://internet-apps.com/iapps/ic/InvReports.html
https://app.smartturn.com/occam/help/help_en/inv_reports.html
http://www.oracleappshub.com/category/oracle-purchasing/
http://oracle-applications-rama.blogspot.com/
http://www.appsdba.com/
http://www.eas.gwu.edu/home/support/documentation/documentation.cfm
http://www.fin.gov.nl.ca/ComptrollerGeneral/oraclemanuals/purchasing
http://www.fin.gov.nl.ca/ComptrollerGeneral/oraclemanuals/accountspayable/default.htm
http://oraclea2z.blogspot.com
http://www.oraclefans.com/oraclefans/forum/erpfinan/
http://www.erpfans.com/
http://www.teachmeoracle.com/forum/
http://www.esnips.com/_t_/oracle+apps
http://docs.huihoo.com/oracle/docs/B25516_06/current/html/doclist.html
http://www.umec.com.tw/r11i/html/trmdoc.html
http://www.orafaq.com/forum/t/49413/0/
http://erpstuff.com/forum.asp?FORUM_ID=3
http://www.ysn.ru/docs/oracle/workflow.920/
http://www.praetoriate.com/shad_fin9.htm
http://www.praetoriate.com/oracle_tips.htm
http://www.tacticspartners.com
http://www.geocities.com/oracletricks/oraapps/
http://oracle-financials-11i.blogspot.com/
http://www.visualbuilder.com/showCode.php?id=81369&scd_id=2849
http://www.java2s.com/Code/Oracle/PL-SQL/CatalogPL-SQL.htm
http://www.idevelopment.info/data/Programming/plsql/PROGRAMMING_PLSQL_Home.cgi
http://oracleapplications-11i.blogspot.com
http://oracle-hrms-11i.blogspot.com
http://learn-oracle-apps.blogspot.com
http://oracle-aol-11i.blogspot.com
http://oraclehrmsapps.blogspot.com
http://computerebook.blogspot.com/
http://www.oracle.ask2ask.com
http://www.appsdbablog.com
http://blogs.oracle.com/schan/
http://www.filibeto.org/sun/lib/nonsun/oracle/10.2.0.1.0/B19306_01/workflow.102/b15853/T361836T361982.htm
http://www.workflowfaq.com/
http://www.miraclewisdom.com/oracle_applications.htm
http://oracleappstechnology.blogspot.com/2007/07/why-is-it-called-apps-and-not-oracle.html
http://appstechnical.blogspot.com/
http://garethroberts.blogspot.com/2007/08/audit-trail-must-do-bank-accounts.html
http://getappstraining.blogspot.com/2006/10/what-happens-when-you-login-to-apps.html
http://www.coaug.org/presentations.html
http://www.appworx.com/solutions/oracle.cfm
http://www.infocaptor.com/articles/2006/01/view-discoverer-reports-through-oracle.html
http://web.mit.edu/sapr3/windocs/bporb06a.htm
http://www.ctipc.com/Novaware/IC.htm
http://www.virginia.edu/integratedsystem/howdoi/HTML/NAV5537U.htm
http://www.bscaler.com/erm/next_generation_erp.htm
http://www.cougarmtn.com/accounting-software-reports/accounts-payable.asp
http://www.dbtips.com/
http://www.sucharitha.com/
http://www.fors.com/velpuri2/Applications/8.htm
http://bfa.sdsu.edu/~leap/appsupgrade.htm
http://bfa.sdsu.edu/~leap/documentation.htm
http://www.purchasing.upenn.edu/buyinfo/guide/
http://www.acsspr.com/po.html
http://www.frameware2000.com/reports.htm
http://www.virginia.edu/integratedsystem/howdoi/HTML/NAV5515U.htm#ZZZ_TUT_1
http://www.mainstreetasp.com/purchase.htm
http://scripts4oracle.blogspot.com/
http://orafact.com/index_files/Page1023.htm
http://www.erpstuff.com/topic.asp?TOPIC_ID=2353
http://www.eplanetlabs.com/oracle-1Z0-141-Certification.html
http://onlineappsdba.blogspot.com/

http://download-uk.oracle.com/docs/cd/A60725_05/html/comnls/us/ap/index.htm

Oracle Apps Training Videos

Query to retieve KFF's in Oracle E-Business Suite

SELECT COUNT(*),
FAT.APPLICATION_NAME
FROM FND_ID_FLEXS FIF,
FND_APPLICATION_TL FAT
WHERE FAT.APPLICATION_ID = FIF.APPLICATION_ID
AND FAT.LANGUAGE = 'US'
GROUP BY FAT.APPLICATION_NAME
ORDER BY FAT.APPLICATION_NAME

SELECT FA.APPLICATION_SHORT_NAME,
FAT.APPLICATION_NAME,
FIF.ID_FLEX_CODE,
FIF.ID_FLEX_NAMEFROM FND_ID_FLEXS FIF,
FND_APPLICATION FA,
FND_APPLICATION_TL FAT
WHERE FA.APPLICATION_ID = FIF.APPLICATION_ID
AND FAT.APPLICATION_ID = FA.APPLICATION_ID
AND FAT.LANGUAGE = 'US'
ORDER BY FAT.APPLICATION_NAME,
FIF.ID_FLEX_NAME

Sunil Dutt's Oracle Apps Technical World

Wednesday, July 30, 2008

HZ Architecture

AIM Methodology

GL_INTERFACE_ERRORS

Base Tables of O2C Process:

Sunday, July 20, 2008

API's

Order to cash life cycle

Oracle Apps Stuff in Net

Oracle Apps Training Videos

Query to retieve KFF's in Oracle E-Business Suite

Apps Tables

Followers

Blog Archive

About Me

Total Visits