Oracle EBS, Fusion and OIC

This blog is for Oracle Ebs, Fusion and OIC Techno- Functional People. I am sharing my work experience through this blog.

Thursday, 7 August 2014

at August 07, 2014

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Oracle Fusion SQL Queries to get Sales Person/Sales Representative information for an Order

1) Get sales person details if the Sales Person ID is known SELECT jrs.SALESREP_NUMBER , jrs.status , jrs.START_...

P2P : Procure to Pay Cycle in Oracle Apps

P2P CYCLE: INVENTORY=> REQUIESTITION=> RFQ=> QUOTATION=> QUOTATION ANALYSIS=> PURCHASE ORDER =>...
Order to Cash (O2C) Cycle in Oracle Apps

Order to Cash (O2C) Cycle with in Oracle Apps Enter the Sales Order Book the Sales Order Launch Pick Release Ship Confirm Create In...
Query to get GL code combinations description

---------- 1) Below given query can be used TO get concatenated Gl code combinations segment AND its description USING API GL_FLEXFIELDS_PK...

Total Pageviews

Popular Posts

P2P : Procure to Pay Cycle in Oracle Apps

P2P CYCLE: INVENTORY=> REQUIESTITION=> RFQ=> QUOTATION=> QUOTATION ANALYSIS=> PURCHASE ORDER =>...
Order to Cash (O2C) Cycle in Oracle Apps

Order to Cash (O2C) Cycle with in Oracle Apps Enter the Sales Order Book the Sales Order Launch Pick Release Ship Confirm Create In...
Query to get GL code combinations description

---------- 1) Below given query can be used TO get concatenated Gl code combinations segment AND its description USING API GL_FLEXFIELDS_PK...
AP to GL Link using XLA Tables

The table is called GL_IMPORT_REFERENCES . It is linked with GL_JE_BATCHES by JE_BATCH_ID and linked with GL_JE_HEADERS, GL_JE_LINES by ...
How to create soft link for host program

Kindly create shell script xxcust_test_shell_script and save it as .prog. Then transfer it to XXCUST_TOP/bin folder by using putty/win...
How to set Org context in 11i and R12

In 11i: Begin dbms_application_info.set_client_info('&ORG_ID'); End; In R12: BEGIN MO_GLOBAL.SET_POLICY_CONTEXT(...
Query to get AP invoice Payment details

AP Invoice payments details query AP_DOCUMENTS_PAYABLE SELECT * FROM AP_DOCUMENTS_PAYABLE WHERE calling_app_id = 200...
Oracle Apps Interview Question and Answer - SQL & PLSQL

1. Advantages of stored functions and procedures · Applications can be modularized. · Easy maintenance. ...
List of API in Oracle Apps for TCA, AP, PO and AOL

Sr. No. Detail API Name Module 1 Create Customer Account HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT TCA 2 Create a Customer Account Rel...
Link between GL and AR through XLA

The main link to bind information together is the GL_SL_LINK_ID. This field exists in GL_JE_LINES, GL_IMPORT_REFERENCES and XLA_AE_LINES ta...

Copyrights @ Oracle apps Technical Consultant:-. Ethereal theme. Theme images by mammamaart. Powered by Blogger.