SELECT

            c.conversion_rate,

            c.conversion_date,

            b.user_conversion_type,

            c.to_currency,

            c.from_currency

            --gl.conversion_date

          FROM

            GL_DAILY_CONVERSION_TYPES b,

            GL_DAILY_RATES c

          WHERE

            b.conversion_type = c.conversion_type

            AND b.user_conversion_type = 'MOR'

How to define new profile values in oracle fusion :

Defined new profile options in system using Manage Applications Core Profile Options.

Updated profile values from manage admin profile values.

Then added new FTP values in BIP management.

1. Update Payment Process Profile-->Reporting tab and remove Separate Remittance Format and uncheck 'Automatically submit when payments' option


2. Update Manage Disbursement System Options and disable following SRA settings both at header level and business unit level:

Separate Remittance Advice from Email
Separate Remittance Advice Subject

Sand Box

def  X_org=121;
   def  X_default =1;
  if ( OrganizationId != X_org)  {
  return X_default
  }

How to set as of now filter to OTBI:

Create veriable from prompt and set the prefix
as SET VERIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate'} this is case senstive
please make sure same prompt copy from prompt.

How to get the BPA number against to PO Number in Fusion:


SELECT        
  FromBlanketHeader.SEGMENT1 AS BPANUMBER,
        FromBlanketHeader.attribute1 
  FROM
  PO_LINES_ALL PurchasingDocumentLine,
  PO_HEADERS_ALL PurchasingDocumentHeader,
  PO_HEADERS_ALL ContractHeader,
  PO_HEADERS_ALL FromBlanketHeader
  WHERE
  PurchasingDocumentLine.PO_HEADER_ID = PurchasingDocumentHeader.PO_HEADER_ID
  AND PurchasingDocumentLine.CONTRACT_ID = ContractHeader.PO_HEADER_ID(+)
  AND PurchasingDocumentLine.FROM_HEADER_ID = FromBlanketHeader.PO_HEADER_ID(+)
  AND PurchasingDocumentHeader.SEGMENT1=:P_YOUR_PONUMBER

select * from iby_pay_service_requests

where CALL_APP_PAY_SERVICE_REQ_CODE like 'PPR Fille name'