Friday 30 September 2011

Pre-requisites to create Descriptive Flexfield (DFF) in JSP page in R12

Enable 5 basic system profile values (Yes) to enable personalization
link in JSP pages.

Create Seeded Personalizations
FND: Personalization Region Link Enabled
FND: Personalization Seeding Mode
HR: Enable User Personalization
Personalize Self-Service Defn

Go to a JSP page; click on ‘About this page’ on below left side of the
page, then Flexfield References will appear.

Query the Application (i.e. ‘AP’ or ‘AR’) from the JSP page on below
navigated form to have the application name

Application Developer-Application-
Register. (Query in ‘Short name’ block)

Query the Flexfield name from the JSP page to below navigated form for
getting the title.

Application Developer-Flexfield-Descriptive-Register. Query
Application in Application block and Flexfield name in Name block.

Now you will be having the Titel of the DFF as well as Application.

Now go to Application Developer-Flexfield-Descriptive-Segment…and
Query with the Application and DFF Titel.

Now you can create a DFF and view it in required Page.

Thursday 29 September 2011

How to change the prompt of a particular field

How To Change The Prompt Of A Particular Field.

Step 1. Change This """Customer """" Prompt.




Then See Customer Field And Block Name.










Then Open : Help>Diagnostics>Custom Code >Personalize

















Then Press ""Get Value""









Then Change Customer Name As "BRIJESH."






Then Apply Now








Then """"""""""""Validate """"" And Save .


Then Open New Sales Order From And Promt Name Will be Change.















***













How to make a field Mandatory in JSP Page

How To Make A Field Mandatory In Jsp Page
Step 1: Change The (Registry ID) Field As Manadatory.























Then Open """""Personalization Stock Layouts""""""""



































Then open ""Registry id ""field .
















































The Required Field "'"YES""






















Then Apply .

Monday 19 September 2011

PO Tax Sub Query

Select Poh.SEGMENT1 Purchase_Order_Number,Pol.QUANTITY, Pol.UNIT_PRICE,

jpt.TAX_RATE, Jpt.TAX_TYPE,Jpt.TAX_AMOUNT, Jct.TAX_DESCR
FROM
JAI_PO_TAXES jpt

, JAI_CMN_TAXES_ALL jct
, Po_Headers_All Poh

, Po_lines_All Pol

WHERE

Jpt
.po_header_id = Poh.PO_HEADER_ID
And
Jpt.PO_LINE_ID = POl.PO_LINE_ID
And
Poh.PO_HEADER_ID = Pol.PO_HEADER_ID
And
Jpt.TAX_ID = Jct.TAX_ID

Purchase Order’s Headers Based Sub Query

Purchase Order’s Headers Based Sub Query

Step 1:

Select a.PO_HEADER_ID From Po_Headers_All a

Where a.Segment1= 40031000048
-----------

Po_Header_id

349

Po_Lines_All

Select * From Po_Lines_All Where Po_Header_Id =349

Po_Line_Locations_All

Select * From Po_Line_Locations_All Where Po_Header_Id =349;

Po_Distributions_All

Select * From Po_Distributions_All Where Po_header_id =349;

Po_Releases_All

SELECT * FROM Po_Releases_All Where Po_Header_Id =349;

Stage 1: Once PURCHASE ORDER is received data is moved to respective RECEIVING tables and INVENTORY tables.

Step 2:

RECEIVING

RCV_SHIPMENT_HEADERS

Select * From Rcv_Shipment_Headers Where Shipment_Header_Id in(Select Shipment_Header_Id From Rcv_Shipment_Lines Where Po_Header_Id =349);

RCV_SHIPMENT_LINES

Select * From Rcv_Shipment_Lines Where Po_Header_Id =349;

RCV_TRANSACTIONS

Select * From Rcv_Transactions Where Po_Header_Id =349;

RCV_ACCOUNTING_EVENT

Select * From Rcv_Accounting_Events Where Rcv_Transaction_Id IN

(Select Transaction_Id From Rcv_Transactions Where Po_Header_Id =349);

RCV_RECEIVING_SUB_LEDGER

Select * From Rcv_Receiving_Sub_Ledger Where Rcv_Transaction_Id IN (Select Transaction_Id From Rcv_Transactions Where Po_Header_Id =349);

RCV_SUB_LEDGER_DETAILS

Select * From Rcv_Sub_Ledger_Details Where Rcv_Transaction_id in (Select Transaction_Id From Rcv_Transactions Where Po_Header_Id =349);

Step 3: INVENTORY


MTL_MATERIAL_TRANSACTIONS

Select * From Mtl_Material_Transactions Where Transaction_Source_Id =349;

MTL_TRANSACTION_ACCOUNTS

Select * From Mtl_Transaction_Accounts Where Transaction_Id in

( Select TRANSACTION_ID From Mtl_Material_Transactions Where Transaction_Source_Id =349);

Stage 2:Invoicing details

AP_INVOICE_DISTRIBUTIONS_ALL

Select * From Ap_invoice_Distributions_All Where Po_Distribution_Id IN ( Select Po_Distribution_Id From Po_Distributions_all Where Po_Header_Id =349);

AP_INVOICES_ALL

Select * From Ap_Invoices_All Where Invoice_Id In(Select invoice_id from Ap_Invoice_Distributions_All Where Po_Distribution_Id IN ( Select Po_Distribution_Id From Po_Distributions_All Where Po_Header_Id =349));

********************** *** ************************