Oracle Fusion Queries

Query to get Value Set Values - GL Segments. 

SELECT segvalsets.value_set_code             ,
value                                       ,
segvals.description                      ,
enabled_flag                                ,
start_date_active                           ,
end_date_active                             ,
summary_flag                                ,
flex_value_attribute1 AS POSTING_ALLOWED    ,
flex_value_attribute2 AS BUDGETING_ALLOWED  ,
flex_value_attribute3 AS ACCOUNT_TYPE       ,
flex_value_attribute4 AS CONTROL_ACCOUNT    ,
flex_value_attribute5 AS RECONCILIATION_FLAG,
flex_value_attribute6 AS FINANCIAL_CATEGORY
FROM fusion.fnd_vs_values_vl segvals,
fusion.fnd_vs_value_sets segvalsets
WHERE segvals.value_set_id = segvalsets.value_Set_id
AND segvalsets.value_Set_id IN
(SELECT value_set_id
  FROM FUSION.fnd_kf_segment_instances
 WHERE structure_instance_id IN
 (SELECT fusion.fnd_kf_str_instances_b.structure_instance_id
    FROM FUSION.fnd_kf_str_instances_b
   WHERE application_id =101
 AND key_flexfield_code = 'GL#'
 )
)

flex_value_attribute3 AS ACCOUNT_TYPE  - Mapping

A	Asset
C	Budgetary credit
D	Budgetary debit
E	Expense
L	Liability
O	Owners' equity
R	Revenue

Oracle Fusion - Errors and Solutions

Sales Order Creation Error1 - SourceTransactionLineNumber 1, SourceScheduleNumber 1: The request couldn't be completed because either it doesn't include a value for the TaxClassificationCode attribute, or the value of XXXXXX that it does provide isn't valid.

Solution:  Go to Setup and Maintenance -> Search for "Manage Tax Lookup Codes" --> Search for the following Lookup Code "ZX_OUTPUT_CLASSIFICATIONS"  -->  Add the missing XXXX value , select Common set as a reference data set.  

Use the following Lookup codes for the respective entities. 
ZX_INPUT_CLASSIFICATIONS = Payables
ZX_OUTPUT_CLASSIFICATIONS = Receivables / Sales Orders
ZX_WEB_EXP_TAX_CLASSIFICATIONS = Expenses

Sales Order Creation Error2 - SourceTransactionLineNumber 4, SourceScheduleNumber 4: The request to add an order line failed because fulfillment isn't set up to supply item 1234567777 from warehouse 1234456778. Select another warehouse.

Solution:  Check the item configurations in PIM and make sure the item is associated with the proper inventory organization.