Query to retrieve Default Payment method associated with Supplier

With PO Vendors View
select pv.vendor_name, pv.vendor_id,pv.segment1,pv.party_id, epa.ext_payee_id,pm.payment_method_code
from
po_vendors pv ,
iby_external_payees_all epa,
iby_ext_party_pmt_mthds pm
where pv.party_id = epa.payee_party_id
and epa.ext_payee_id = pm.ext_pmt_party_id
and pm.primary_flag ='Y'
and pm.payment_flow='DISBURSEMENTS'
and pv.vendor_name ='TEST2'


With  HZ Parties table
select hp.party_name, hp.party_id, epa.ext_payee_id,pm.payment_method_code
from
hz_parties hp ,
iby_external_payees_all epa,
iby_ext_party_pmt_mthds pm
where hp.party_id = epa.payee_party_id
and epa.ext_payee_id = pm.ext_pmt_party_id
and pm.primary_flag ='Y'
and pm.payment_flow='DISBURSEMENTS'
and hp.party_name ='TEST2'

ORA-01400: cannot insert NULL into ("APPLSYS"."FND_CONC_REQ_OUTPUTS"."FILE_TYPE")

ORA-01400: cannot insert NULL into .....

Recently while working on XML/BI Publisher reports I encountered following error message

+------------- 1) PUBLISH -------------+

Beginning post-processing of request 39091331 on node VISION at 15-NOV-2013 02:13:12.

Post-processing of request 39091331 failed at 15-NOV-2013 02:13:13 with the error message:

One or more post-processing actions failed. Consult the OPP service log for details.

from the description of error message , it was not clear what went wrong.But during the analysis of the Post processor Log file , i saw the error message 

--

ORA-01400: cannot insert NULL into ("APPLSYS"."FND_CONC_REQ_OUTPUTS"."FILE_TYPE")

--

for my concurrent request 

Reason - System will raise this error while processing the BI Publisher report if value for profile option 

How to Export Sales Orders from Oracle Applications To External Applications

How to Export Sales Orders from Oracle Applications To External Applications

In case you have requirement to  Export Sales Orders from Oracle Applications To External Applications, one easy way to use Oracle Standard API 

OE_ORDER_PUB.get_order.

Below is complete running example 

How Does One Export Sales Orders To External Applications 

Declare

--L_Header_Rec     Header_Rec_Type;

L_Return_Status   Varchar2(10);

L_Msg_Count       Number;

L_Msg_Data        Varchar2(5000);

l_msg_index NUMBER;

l_data VARCHAR2(2000);

L_Loop_Count Number;

L_Lin_Count  Number:=1;

i NUMBER;

--------------------------

Query to Get Form Personalization Details ( Oracle Applications ) from Database.

Query to Get Form Personalization Details ( Oracle Applications )  from Database.

FND_FORM_CUSTOM_RULES - The Rules for the form customizations. A rule must have 1 more more FND_FORM_CUSTOM_SCOPES and a rule may have 1 or more FND_FORM_CUSTOM_ACTIONS.

FND_FORM_CUSTOM_ACTIONS - Holds the Actions for a specified Rule 

FND_FORM - stores information about your registered application forms. Each row includes names (the actual SQL*Forms form name, and the EasyForm form title) and a description of the form. Each row also includes a flag that indicates whether this form is included in the AuditTrail audit set. You need one row for each form in each application. Oracle Application


Select Distinct
A.Id,
A.Form_Name , A.Enabled, C.User_Form_Name, D.Application_Name ,A.Description,Ca.Action_Type,Ca.Enabled,Ca.Object_Type,
ca.message_type,ca.message_text
from FND_FORM_CUSTOM_RULES a,
     FND_FORM b,
     FND_FORM_TL c,
     Fnd_Application_Tl D,
     Fnd_Form_Custom_Actions ca
where a.form_name = b.form_name
And B.Form_Id = C.Form_Id
And B.Application_Id = D.Application_Id
And D.Application_Id = 660 --For Order Management
And C.User_Form_Name Like 'Sales%'  --All the Forms that Start with Sales
And A.Enabled ='Y'
and a.id = ca.rule_id

Query to get the Details and Parameter list for Concurrent Program in Oracle Applications.

Query to get the details and Parameter list for Concurrent Program in Oracle Applications.

SELECT fcpl.user_concurrent_program_name ,
              fcp.concurrent_program_name,
               fcpl.description,
               fcp.concurrent_program_name     ,
               par.column_seq_num,
               par.application_column_name   ,
               par.end_user_column_name     ,
               par.form_left_prompt prompt     ,
               par.enabled_flag     ,
               par.required_flag     ,
               par.display_flag,
               par.default_value
FROM   fnd_concurrent_programs fcp     ,
              fnd_concurrent_programs_tl fcpl     ,
              fnd_descr_flex_col_usage_vl par
Where  Fcp.Concurrent_Program_Id = Fcpl.Concurrent_Program_Id
And  Fcpl.User_Concurrent_Program_Name = 'ENTER_USER_CONCURRENT_PROG_NAME'
     And  Fcpl.Language = 'US'
     AND  par.descriptive_flexfield_name = '$SRS$.'||fcp.concurrent_program_name