assigned suppIier BANK data

 select /*3-22887520491*/ P.PARTY_NAME AS ACCOUNT_OWNER_PARTY_NAME,ACCT.BANK_ACCOUNT_NAME

from fusion.IBY_ACCOUNT_OWNERS OWN,

fusion.IBY_EXT_BANK_ACCOUNTS ACCT,

fusion.hz_parties P

where OWN.ACCOUNT_OWNER_PARTY_ID <> -99

and OWN.EXT_BANK_ACCOUNT_ID=ACCT.EXT_BANK_ACCOUNT_ID

and ACCT.BANK_ACCOUNT_NUM=

and OWN.ACCOUNT_OWNER_PARTY_ID=P.PARTY_ID

 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