Sairam Nimmagadda

Steps to modify CUSTOM.PLL Here are the steps in short to modify CUSTOM.pll file - R12 Prerequisites : Ensure that you have following files downloaded into your local machine before working on the CUSTOM.pll file. APPCORE.pll APPDAYPK.pll FNDSQF.pll                                  Steps : Step1 :  Download the CUSTOM.PLL file from AU/resource top. Step2 :  Open the Oracle Forms Builder, and open the CUSTOM.pll file. Step3 :  Double click on the CUSTOM*(Package Body) Step4 :  Add the code for the required event and for the desired form in the Package Body Step5 :  Save the changes. Step6 :  Compile the CUSTOM.pll file.(CTRL + SHIFT + K) Step7 :  Upload(File Transfer using FTP tools) the updated CUSTOM.pll file to AU/resource top Step8  :  Login to UNIX box and navigate to AU/resource top Step9 :  Use the following command to...

Understanding data flow for “Standard Order” 1. Order Entry This is first stage when Order in enter in system. When the order is entered it basically creates a record in order headers and Order Lines table. •oe_order_headers_all (Here the flow_status_code as entered) •oe_order_lines_all (flow_status_code as entered) ( order number is generated) 2. Order Booking This is next stage , when Order which is entered in step 1 is booked and Flow status changed from Entered to Booked.At this stage , these table get affected. •oe_order_headers_all (flow_status_code as booked, booked_flag updated) •oe_order_lines_all (flow_status_code as awaiting shipping, booked_flag updated) •wsh_new_deliveries (status_code OP open) •wsh_delivery_details (released_status ‘R’ ready to release) Same time, Demand interface program runs in background And insert into inventory tables mtl_demand 3. Reservation This step is required for doing reservations SCHEDULE ORDER PROGRAM runs...

We have to use f60gen for compiling forms and libraries in Oracle Applications Version 11i. Some places you need to put the custom form (fmb) under $AU_TOP/forms/US. In some places i have seen the form(fmb) under source code directories. Either is the the case, you need to compile the fmb and place the fmx in the appropriate directory Step 1: Login to application server Step 2:  Go to the directory $AU_TOP/forms/US                      --> Place “.fmb” file in binary mode Step3:  Execute the “f60gen” command to generate “.fmx”.  Syntax: f60gen module=.fmb userid=apps/ output_file=.fmx module_type=form batch=no compile_all=special Sample Syntax:  f60gen module=$AU_TOP/forms/US/XXCUSTOM.fmb userid=apps/appspassword output_file=$CUSTOM_TOP/forms/US/XXCUSTOM.fmx module_type=form  batch=no compile_all=special

Recently i faced an issue where my BI Publisher add-in for MS Word 2010 was not working. Somehow the add-in was disabled. This is what i did to enable it. File --> Options --> Add-Ins --> Go to the Bottom  and click on options for Manage In the list click on Disabled Items , Click Go Select the BI Publisher Add-in and click enable. This did it for me. There are different solutions for each version of MS word. If i get to work on latest MS Word versions, i will update this post. This is only for MS Word 2010.

View --> Toad Options -> Oracle --> Transactions -->  Check  Execute queries in threads This should allow multiple sessions in Toad. Each Session can run its own SQL in parallel.

declare v_request_id number(15); v_user_id               fnd_user.user_id%TYPE := 40827; v_responsibility_id     fnd_responsibility.responsibility_id%TYPE; l_boolean  boolean begin     select name into l_db     from v$database;         SELECT responsibility_id     INTO v_responsibility_id     FROM fnd_responsibility_vl     WHERE responsibility_name = 'AR Receivables';         -- set environment context     fnd_global.apps_initialize (v_user_id,                                 v_responsibility_id,                 ...

Use the API below to create the attachment. This could be a limited text that you want on the order header or line. OE_FND_ATTACHMENTS_PUB.CREATE_SHORT_TEXT_DOCUMENT (1.0, --version P_SHORT_TEXT, --Text to be added as attachment P_CATEGORY_ID, -- Attachment category id P_DESCRIPTION, -- Attachment description NULL, V_SECURITY_ID, --The value is 4 for no security NULL, 'Y', 'O', -- One time usage SYSDATE, NULL, NULL, V_DOCUMENT_ID , -- Document id returned by the API V_RETURN_STATUS_CS, V_MSG_COUNT_CS, V_MSG_DATA_CS); Pass V_DOCUMENT_ID from above API into below second API OE_FND_ATTACHMENTS_PUB.ADD_ATTACHMENT (1.0, P_ENTITY_NAME, --Value of this parameter would be 'OE_ORDER_HEADERS' for header level attachment -- and 'OE_ORDER_LINES' for line level attachment P_PK1_VALUE, --line id or header id (For line level or header level attachment) NULL, NULL, NULL, NULL, 'N', NULL, V_DOCUMENT_ID , --Document id from above ap...