Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Payables and Cash Management - EBS (MOSC)

Unable to find Legal entity infomration at document sequce category tables .

May 16, 2024 4:05PM in Payables and Cash Management - EBS (MOSC) 6 commentsAnswered

Hi Team,

Any one have sql query on same requirment in your experiance. I used below tables.

FND_DOCUMENT_SEQUENCES
FND_DOC_SEQUENCE_ASSIGNMENTS
FND_DOC_SEQUENCE_USERS
FND_DOC_SEQUENCE_CATEGORIES
HR_LEGAL_ENTITIES

Expected data.

Doument Seq Name	Category	LE
CAN_INVOICES	DBM INV	Canada LE
CAN_INVOICES	CRM INV	Canada LE
CAN_INVOICES	STD INV	Canada LE
CAN_INVOICES	Global Intercompany	Canada LE
CAN_INVOICES	Intercompany	Canada LE
CAN_INVOICES	PAY REQ INV	Canada LE
CAN_INVOICES	PREPAY INV	Canada LE

CAN_PAYMENTS	EFT PAY	Canada LE
CAN_PAYMENTS	CLEAR PAY	Canada LE
CAN_PAYMENTS	CHECK PAY

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month